time format

Share icon

Hi I have a time wave to import which has the format "2017-07-01" , I tried something like
String columnInfoStr = ""
    columnInfoStr += "C=1,F=6,T=4,N=DateLC;"
    columnInfoStr += "C=1,F=7,T=4,N=TimeLC;"
    columnInfoStr += "C=1,F=0,T=4,N=CO2;"
    
LoadWave/Q/A/D/J/O/W/L={1,2,0,0,0}/B= columninfostr


but the DateLiCor only shows 2017 for the entire wave. I had the same issue with or without specifying B. I also wonder what should be used for numeric values, help file says 0-5, what does each mean?
May I also ask how do I introduce a path for loadwave function? Right now I wait for the window asking for the file location after executing the command.

Many thanks!!
Thanks Jim! Example file attached and my complete code looks like this:
String columnInfoStr = ""
    columnInfoStr += "C=1,F=-1,T=4,N=DateLiCor;"
    columnInfoStr += "C=1,F=7,T=4,N=TimeLiCor;"
    columnInfoStr += "C=1,F=1,T=4,N=CO2_ppm;"
    columnInfoStr += "C=1,F=0,T=4,N=H2O_ppt;"
    columnInfoStr += "C=1,F=0,T=4,N=H2O_C;"
    columnInfoStr += "C=1,F=0,T=4,N=Cell_Temperature_C;"
    columnInfoStr += "C=1,F=0,T=4,N=Cell_Pressure_kPa;"
    
LoadWave/Q/A/D/J/O/W/L={1,2,0,0,0}/B= columninfostr

Thanks!
Log_20170630_CO2.txt (3.42 MB)

September 6, 2017 at 02:34 pm - Permalink

Macro Load()
    String columnInfoStr = ""
//  columnInfoStr += "C=1,F=-1,T=4,N=DateLiCor;"
    columnInfoStr += "C=1,F=6,T=4,N=DateLiCor;"
    columnInfoStr += "C=1,F=7,T=4,N=TimeLiCor;"
    columnInfoStr += "C=1,F=1,T=4,N=CO2_ppm;"
    columnInfoStr += "C=1,F=0,T=4,N=H2O_ppt;"
    columnInfoStr += "C=1,F=0,T=4,N=H2O_C;"
    columnInfoStr += "C=1,F=0,T=4,N=Cell_Temperature_C;"
    columnInfoStr += "C=1,F=0,T=4,N=Cell_Pressure_kPa;"
 
//  LoadWave/A/D/J/O/W/L={1,2,0,0,0}/B= columninfostr
    LoadWave/A/D/J/O/W/L={1,2,0,0,0}/R={English, 2, 2, 2, 1, "Year-Month-DayOfMonth", 40}/B= columninfostr
EndMacro


--Jim Prouty
Software Engineer, WaveMetrics, Inc.

September 6, 2017 at 04:39 pm - Permalink

mwpro wrote:
I also wonder what should be used for numeric values, help file says 0-5, what does each mean?


Any of those values produces the same result. Those are just the numbers between -2 and 10 that aren't used for other purposes. Use F=0.

mwpro wrote:

May I also ask how do I introduce a path for loadwave function? Right now I wait for the window asking for the file location after executing the command.


Use /P=path


If you use /P=pathName , note that it is the name of an Igor symbolic path, created via NewPath. It is not a file system path like "hd:Folder1:" or "C:\\Folder1\\". See Symbolic Paths for details.


And also specify the name of the file as the last (string) parameter. Obviously you must supply/know this name to do this.

--Jim Prouty
Software Engineer, WaveMetrics, Inc.

September 6, 2017 at 04:50 pm - Permalink

Thank you Jim! This solves my problem! So R specification works on the F=6 in /B right? Thank you so much!

September 7, 2017 at 03:30 pm - Permalink

mwpro wrote:
Thank you Jim! This solves my problem! So R specification works on the F=6 in /B right? Thank you so much!

It does, and you're welcome!

--Jim Prouty
Software Engineer, WaveMetrics, Inc.

September 7, 2017 at 04:08 pm - Permalink