Append to each line

When I started this apprenticeship in July last year (officially September) I was put into the IT-Support team.
Most of my tasks were – as one would expect – solving tickets.

Sometimes we’d get a table with IDs to modify/ delete from a database. To make things easier I looked up the following batch script which adds ‘ ‘, to each line.

for /f "tokens=*" %a in (myfile.txt) do (echo '%a',) >> output.txt

For example if you got a table containing:

123456
123457
123458
123459

You’d save that in myfile.txt after running the script it creates an output.txt containing

'123456',
'123457',
'123458',
'123459',

which clearly makes it easier to format into an SQL query given sometimes those tables would contain thousands of entries.