Extract to CSV but retain comma(,) char in the field
I was thinking if you have gotten in to scenario like this.
I want to extract fields from a table and output it into a csv file format. But i found out that some of the fields contains comma(,) (e.g. Address col - Foursquad, Far City).
So when it was opened to as csv. The above Address column would be treated as a 2 sepate column col1= Foursquad col2= Far City.
How can we make a tweak that we could retain the Address column complete and still we could format the output file as csv. I mean the Address col would still be "Foursquad, Far City".