loading date in datafile
mwpro
LoadWave/Q/A/J/D/O/W/L={0,7,1,0,0}/B="C=1,F=-2,T=4; C=1,F=6,T=4,N=StartDate;"/R={English, 2, 2, 1, 1, "Month/DayOfMonth/Year", 4} pathname+fileName
and I have attached an example file. Thanks very much for the help!!
For clarity and ease of debugging, I rewrote your code like this:
String columnInfoStr = ""
columnInfoStr += "C=1,F=-2,T=4,N='_skip_';"
columnInfoStr += "C=1,F=6,T=4,N=StartDate;"
String dateLayout = "Year/Month/DayOfMonth"
LoadWave/Q/A/J/D/O/W/L={0,7,1,0,0}/B=columnInfoStr/R={English,2,2,1,1,dateLayout,4}
End
September 14, 2017 at 12:21 pm - Permalink
September 14, 2017 at 02:16 pm - Permalink
September 15, 2017 at 06:09 am - Permalink
That way you see the file the way it really is, instead of the way Excel represents the file.
--Jim Prouty
Software Engineer, WaveMetrics, Inc.
September 15, 2017 at 09:34 am - Permalink
September 15, 2017 at 09:47 am - Permalink