Need to add two commas to the end of each line in a text file

Feek · 16 Dec 2011 at 21:50

I have a text file which contains around 80,000 rows

I need to add two commas to the end of each row.

I thought I could do it in Numbers but it won't handle that many rows.

Does anyone have any suggestions as to how I can do this?

Randomface74 · 16 Dec 2011 at 21:56

write a program?

Feek · 16 Dec 2011 at 21:57

I'm not a programmer. If I were, I would have done that already.

Randomface74 · 16 Dec 2011 at 21:57

or open in excel, add two column headers, save as csv

Feek · 16 Dec 2011 at 21:58

I don't have Excel.

Randomface74 · 16 Dec 2011 at 22:02

find+replace new line with comma comma new line?

Chief Wiggum · 16 Dec 2011 at 22:09

open terminal
locate the file and then type vim [filename.txt]
then enter:

Code:

:%s/$/\,,/g

press esc

if it adds ,, to the bottom move the cursor over that and type

Code:

dd

then type

Code:

:wq

Try it on a backup of the file first

Feek · 16 Dec 2011 at 22:19

Thanks Chief, that worked perfectly.

Chief Wiggum · 16 Dec 2011 at 22:23

you're welcome sir, vim / vi (*nix) is really quite useful for exiting text (once you know your way about)

Feek · 16 Dec 2011 at 22:24

I use vi at a very basic level at work, didn't even think of it!