How to convert a List in text file to single line with commas

Question

I have text file with data as a list with each word on new line:

'GBL26707819i'
'GBL26707944i'
'GBL26707972i'
'GBL26708071i'
'GBL26708070i'

I want to show it in single line seperated by commas.
For example, the ticket numbers are 'GBL26707819i','GBL26707944i','GBL26707972i' etc.

Answer 1

Using powershell:

$content = [IO.File]::ReadAllLines("file.txt")  
$result = [string]::Join(",", $content)
write $result