Used Notepad++ 'find & replace' function, to find all blank spaces followed by comma, & replace w/ just a comma.

For this, I didn't have to use a Regular Expression (which I know nothing about). It was talking about adding spaces, so figured might work in reverse - it did. (It has links to more detailed pages on using regular expressions & examples).Ĭaught a bit about using 'search & replace' in Notepad ++. Thanks Frazell, took a quick look at the page linked. In short, the spreadsheets aren't saving the edited files in the EXACT same CVS format (w/ no spaces) as the original CVS file.Īny ideas how to do it the way (I think) I need to do it, w/o introducing spaces? Thanks. cvs format, then reopen it in something other than a spreadsheet (text editor, etc.), it either has no commas at all, or put spaces between data. I'm * assuming * it's because of the spaces - but I'm no expert on this.Įverything I've tried w/ Open Office, Excell (older ver), the CVS editors, Notepad ++, always winds up putting a space after each comma - before next piece of data.Įven when I delete everything from the orig CVS file except the column I want, once opened in the spread sheets, then save it in. It appears when I enter the data (including spaces) in the other prgm's text file, it does NOT use it correctly. Just a command then data list, w/ each piece of data separated by commas, but no spaces. The syntax for the prgm (text file) I'm trying to enter the data into, shows no spaces to be used between each comma & next data. When you look at any CSV file in a text editor, there are NO spaces after each comma & before next data (datum). Want to take 1 of the columns (by what ever method), & get it into a text config file in another prgm. Have a CSV file w/ about 15 columns - when opened in spread sheet (also have couple of 'CSV editor' prgms).

Notepad++ hex editor columns