Load csv file with text qualifier as general text
Fri, 10/21/2022 - 11:18 pm
I want to load a csv file and auto-skip the header and column names row.
LoadWave/G was supposed to do this work, but my csv files contain the qualifier "", preventing /G to detect the data block.
I know /J and /L can be used for file loading but the number of header lines and column names may change per file, making it challenging to find the first line of the data block.
If I delete all "" from the csv file, I could load the data with LoadWave/G. I believe the problem happens in the text qualifier.
Is there a technique I can load csv file with text qualifiers as general text?
String message = "Select one or more files"
String fileFilters = "Data Files (*.csv,*.txt):.csv,.txt;"
Open /D /R /MULT=1 /F=fileFilters /M=message refNum
outputPaths = S_fileName
if (strlen(outputPaths) == 0)
Variable numFilesSelected = ItemsInList(outputPaths, "\r")
for(i=0; i<numFilesSelected; i++)
string path = StringFromList(i, outputPaths, "\r")