String Manipulation inCSV File

[Former Member]

Hi Gurus,

I have got to make a csv file with

NAME ADDRESS PH. No.. and LOCATION

now the address field contains a value as

"Flat 3, Sector 1"

The comma after Flat3 is being considered as a new entity in address...in the csv file So we are getting two fileld values as

Flat 3 and Sector 1

instead of one single field value

How to overcome this without removing the comma ","

[Former Member]

Have you tried the standard double-qoutes around the value with the comma in it?

Here is a link in wikipedia regarding comma-separated-values.

http://en.wikipedia.org/wiki/Comma-separated_values

Hope this helps,

Mark

[Former Member]

thanks

[Former Member]

Hello Supriyo,

So, when you send the data which has comma in embedded format, how do you read it ? Say, its an input file to another program, in that case the comma is interpreted as a delimiter and the data shifts right automatically in my internal table.

1999,Chevy,"Venture ""Extended Edition, Very Large""",,5000.00

Did you try to read this file??

Thanks.