Thanks John for the great video, it's very helpful. I have a slightly different requirement though. I need to use multicharater delimiter e.g. !~! The reason being, most single characters like comma and colon appear in my data. I tried using !~! and some other two/three character delimiters but it doesn't seem to be workin. Could you please let me know if there is a way to make it work. Thanks in advance!
Kirti, I don't know that SN allows the multi character delimiter..I haven't tried that one out lately. however the CSV specification is supposed to allow for special characters. When special characters are in a field, that field's data is supposed to be surrounded in double-quote characters. Here is a link from stack overflow answering the question about delimiters in a CSV file: stackoverflow.com/a/769675. The link takes you to the response I would have given.
Thanks John for the great video, it's very helpful.
I have a slightly different requirement though.
I need to use multicharater delimiter e.g. !~!
The reason being, most single characters like comma and colon appear in my data.
I tried using !~! and some other two/three character delimiters but it doesn't seem to be workin.
Could you please let me know if there is a way to make it work.
Thanks in advance!
Kirti, I don't know that SN allows the multi character delimiter..I haven't tried that one out lately. however the CSV specification is supposed to allow for special characters. When special characters are in a field, that field's data is supposed to be surrounded in double-quote characters. Here is a link from stack overflow answering the question about delimiters in a CSV file: stackoverflow.com/a/769675. The link takes you to the response I would have given.