Double delimiter

Share icon

Hello,

I have some csv files that I routinely analyze that have semicolon delimiters (see attached file). I load the files using "loadwave /J/V={";","",0,0}/W" but I run into issues because the files sometimes contain double semicolons in the data and not the names so it throws the columns off and excludes some data as a result. Excel handles the double delimiters very well but sometimes the files are too large for excel to handle thus making it a hassle. Is there an easy way to allow igor to exclude these double semicolons? Thanks

 csv file (1.53 KB)
You can load this file using the LoadWave /B flag to tell LoadWave the names of the columns and which columns to skip.

I have attached an Igor procedure file that does this. I believe it works for the file you attached. I assume that all of your files have the same format.
Load Reehilch File.zip (1.33 KB)

January 19, 2015 at 10:39 am - Permalink

hrodstein wrote:
You can load this file using the LoadWave /B flag to tell LoadWave the names of the columns and which columns to skip.

I have attached an Igor procedure file that does this. I believe it works for the file you attached. I assume that all of your files have the same format.


That works perfectly. Thank you for laying it out so nicely to interpret and understand. Am I right to assume there's no way to auto detect double delimiters in case this does change or the files differ?

January 20, 2015 at 06:04 am - Permalink

Quote:
Am I right to assume there's no way to auto detect double delimiters in case this does change or the files differ?


Two consecutive delimiters is taken to mean "missing value" and there is no way to change that.

The only other solution for you is something like http://www.igorexchange.com/node/2607.

January 20, 2015 at 09:16 am - Permalink