Hi all
I had code that worked fine for all the comma-separated texts and prevented my text from being spanned into different columns
as I was spooling it into a CSV file.
For e.g.
If I had a text - ABDC,DEFG as a value in column col1, whenever I used to spool it into a csv file, it became
2 columns .i.e. ABC and DEFG in my csv file.
I handled that using chr(34) .i.e. " .i.e. chr(34)||col1||chr(34) and it worked fine until I received a text having double
quotes in the text. say for e.g. abc"xy,z. This again spans the value into multiple columns instead of just 1.
Please provide a way if we can handle this so that my code handles both comma and double quotes.
Thanks