Forum Stats

  • 3,767,865 Users
  • 2,252,726 Discussions
  • 7,874,367 Comments

Discussions

A column value has comma which leads to different columns when exported into a CSV file

User_UH6TP
User_UH6TP Member Posts: 3 Green Ribbon

I have columns which needs to be generated as CSV file. The problem is that one column value has three commas in it. so it creates three seperate columns in CSV file. 


E.g


Select DOC_TITLE AS "Document_Title".


Value: STEELWORK DRAWINGS VESSELS (PLATFORMS, LADDERS, CATWALK) - UNIT 1400 TRAIN 6 STRUC. STEELWORK AREA 8 PLATFORM FOR V-1202


In the CSV file it gives me three columns


Column 1 = STEELWORK DRAWINGS VESSELS (PLATFORMS

Column 2 = LADDERS

Column 3 = CATWALK) - UNIT 1400 TRAIN 6 STRUC. STEELWORK AREA 8 PLATFORM FOR V-1202

I am using Oracle 11g and Oracle developer

What do I do in order to have the entire column value fit into one column in the CSV file

Appreciate any help.

Tagged:

Best Answers

Answers