comma and quote problem in csv file

[Former Member]

Hi

My requirement is to append data in an csv file. This is Proxy to File FCC Scenario. for some of the fields from proxy which contains comma(,) and also double-quote("). for these fileds the in the csv file it is spiting in to two columns and appending in to the next column. and the double-quote symbol is not inserting in the csv file.

1. why the double-quote(") is not inserting in to the csv file columns?

2. how to over come the comma problem? I want that particular file need to append in one column only.

Thanks

Vankadoath

[Former Member]

hi vankadoath,

Were you able to solve comma issue in CSV file.

Even i am facing similar issue.....

wheneever there is a comma in field, it is updating data after comma into next field.

If anybody has solution for the same.......

pls suggest the same............

santosh.

Edited by: santosh koraddi on Jan 20, 2011 9:44 PM

[stefan_grube]

First of all you have to discuss with your project memebers/lead what should happen with that comma.

Maybe you decide to replace it with another character or delete it, that can be done easily with standard function replacestring in graphical mapping.

[Former Member]

Can you please provide the source and the target structures to understand the issue. So that we can suggest a solution.

Thanks,