SQL*Plus (MOSC)

MOSC Banner

Extract to CSV but retain comma(,) char in the field

edited Jul 4, 2017 5:00AM in SQL*Plus (MOSC) 5 commentsAnswered
Hi Gurus,

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".

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center