add comma to end of every line txt file on mac

Add comma to end of every line txt file on mac how to#

In theory, yours is better but when applied in an AppleScript is gave a wrong behavior. I can't guess if the value 17 creating an extraneous column is normal or the result of a data error.įor the tab count, I didn't used your scheme. Well worth investing the time to learn it if you have to deal with editing complicated or really large files.Īnyway, that's enough 'vi' trivia for the day and thanks again to both of you for verifying that Numbers really does have the bug and thanks even more for the work-around!!!

Add comma to end of every line txt file on mac how to#

regular-expression manipulation is a really handy thing to know how to do with 'vi' and has saved me countless hours over the years in doing data-file cleanup. If you don't understand 'vi' syntax, read the man page about 'regular expression' substituions for more info. To change multiple spaces into one tab character in one step: S/ *$// - tells vi to substitute one or more spaces at the end of the line, noted by the $, with nothingĢ. % - tells vi to apply the command to the entire file : - tells vi to go to command mode, or whatever they call it To remove the trailing spaces at the end of the line: One thing that I've found really handy in editing text files like this is to use the command line 'vi' editor or one of it's GUI clones:ġ.

A clever idea to do the copy/paste instead of the file open!! Thanks to both Barry and Yvan - very very much. I think I'll stay with my previous comment-OOo, or one of its offshoots, might be the better choice here. And, after I had closed that file, successfully opened the tab separated. One more dialogue box to choose the separator character-Hmmm., comma was selected, but another choice was 'tab'. About a page down the list, in the spreadsheet section and between the groups for Excel 97/2000 and the group for Excel 2007 was an Aha!-'Text CSV (*.csv, *.txt, *.xls)'-which I selected, and proceeded to opening the. With, I noticed the File Type pop-up menu below the file list in the Open dialogue. csv extension.Īttempting to open this with Numbers produced the same 'the document is too large' message. I haven't tested, but removing the header cells should make at least a slight reduction in the delay between actions and responses.īack in Text Edit, I replaced all of the tabs with commas, and saved the file with the. Several minutes into the wait, I thought that deleting the header column (and perhaps the header row) from the default Blank table might have been a good idea. I didn't scan the sheet to determine what had caused them. There also appeared to be two empty columns beyond the end of the data rows. I opened a new blank Numbers document, selected cell A1 and Pasted.Īfter a lengthy wait, the beachball finally disappeared and the data appeared in the table-all 43534 rows of it. 😟īack in TextEdit, I Selected All, then copied. txt file, but into a Write document, not a Calc one. I got the same 'too large' message on trying to open the.

Replaced all the single spaces with tabs.

I used Find/replace in TextEdit to replace all of the double spaces with single spaces.

dat file in TextEdit, removed the information lines at the top (tagged with a #), leaving only the field names and the data.