I think you need quotes around the single word datasets as well, because the quotes act as String delimiters and help in indicating the start and end of a String.
Is there a reason why the single word strings cannot be in quotes as well? -----Original Message----- From: Divya Gehlot [mailto:[email protected]] Sent: Tuesday, August 01, 2017 3:04 AM To: [email protected] Subject: delimiter in column values Hi, I have data set which has delimeter in first column value when I read the data set It provides the output below : col_Column1 Column2 Column3 Column4 Column5 "This col6 data" coltwodata6 -33.869732 151.2055553 "This col7 data yes." coltwodata7 1.2845045 103.8482739 Chifley coltwodata5 colonedata1 coltwodata1 -35.924476 138.5987123 colonedata2 coltwodata2 -27.4372536 153.0304583 137 colonedata3 coltwodata3 -35.2793885 149.1233503 134 colonedata4 coltwodata4 -33.8724176 151.2067579 colonedata5 coltwodata5 How can I read the column1 values as is without getting split into two columns for instance the Column values should be Column1 colonedata1, colonedata2, colonedata3, colonedata4, colonedata5, "This, col6 data" "This, col7 data" Chifley, Appreciate the help ! Thanks , Divya
