S
SharePointGuy123
Guest
I'm running into some issues parsing a CSV that has commas in the field as well as the fields are separated by commas.
example, I line within the CSV file looks like this
column1, column2, column3,column4
1,00099,"Ford f250, Big Ranch",used, Smith
1,99878,"GMC, Denalli", New, Rogers
1,4456779,"Chevy", Used, Rogers
1,99888997,"Chevy, High Country", New, Smith
the issues I'm running into is that the string is splitting at the comma in column 2. What can I do to remove the quotes, split each column at the comma, however, not split at the comma if it is in the column itself?
Continue reading...
example, I line within the CSV file looks like this
column1, column2, column3,column4
1,00099,"Ford f250, Big Ranch",used, Smith
1,99878,"GMC, Denalli", New, Rogers
1,4456779,"Chevy", Used, Rogers
1,99888997,"Chevy, High Country", New, Smith
the issues I'm running into is that the string is splitting at the comma in column 2. What can I do to remove the quotes, split each column at the comma, however, not split at the comma if it is in the column itself?
Continue reading...