Hi,
I have a csv file with text qualifier " (quotes). This is what the file looks like
line 1>"first name","xxxxxx yy",n,y,3
line 2>"first, xyz","kdjfkh las",n,y,2
How do i seperate the values, I cant use explode on , (comma) because itll mess up line 2;notice it has a comma in the first field.