topic Re: String Manipulation inCSV File in Application Development and Automation Discussions

String Manipulation inCSV File

Former Member — Thu, 21 May 2009 15:01:52 GMT

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

Re: String Manipulation inCSV File

Former Member — Fri, 22 May 2009 14:52:13 GMT

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

Re: String Manipulation inCSV File

Former Member — Wed, 16 Mar 2011 06:38:41 GMT

thanks

Re: String Manipulation inCSV File

Former Member — Thu, 14 Feb 2013 21:52:22 GMT

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.