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
[quote=hrodstein]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.[/quote]

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?[/quote]

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