topic Re: [resolved] Escape character in csv in Talend Studio

[resolved] Escape character in csv

Anonymous — Sat, 16 Nov 2024 13:15:13 GMT

Hi all;
I am trying to ignore "\" character in an adress line in a .csv file,
e.g.= "Zoologiska artiklar - Tillverkare Grossister\,",Limex AB in this line backspace (\) character should be an escape character
i tried to use tFileInputDelimited and set Escape Char to "\" but it did not work. Is there any simple way to do it?

Best Regards
bahadir.

Re: [resolved] Escape character in csv

Anonymous — Wed, 13 Oct 2010 14:40:58 GMT

Hello
Did you try "\\"? if it doesn't work, please show us an example file and what are your expected result?
Best regards
Shong

Re: [resolved] Escape character in csv

Anonymous — Wed, 13 Oct 2010 15:23:55 GMT

my input file is like that :
asd\,ghj
asd,dfg
(comma is the field seperator)
what i expect is :
asd,ghj
asd,dfg

Re: [resolved] Escape character in csv

Anonymous — Thu, 14 Oct 2010 08:35:44 GMT

Hi
It is impossible to ignore the character "\" in the example file you gave, however, you can remove it on other component such as tMap later. please see my screenshots.
Best regards
Shong

Re: [resolved] Escape character in csv

Anonymous — Sat, 16 Oct 2010 01:41:42 GMT

Hi,
This one works great, thank you very much Shong.
Best Regards
Bahadir

Re: [resolved] Escape character in csv

_AnonymousUser — Mon, 07 Mar 2011 05:50:24 GMT

Hi there -
I have a csv file in which a particular column (address column) has a text value that contains a comma (e.g. "2000 Redwood Shores, Redwood city, CA"). I want to be able to read this entire value as one value and not be split because there are commas in the value
To do this, I set the csv options for reading this file in tFileInputDelimited as follows:
Row Separator: "\n"
Field Separator: ","
Escape Char: ""
Text enclosure: """
But unfortunately, the tool still considers the comma in the value as a field separator and returns the following as three separate fields:
2000 Redwood Shores
Redwood city
CA
Can you please throw some light on this
Thanks
Sri

Re: [resolved] Escape character in csv

Anonymous — Mon, 07 Mar 2011 08:16:25 GMT

Hi Sri
Try
Escape Char: "\""
Text enclosure: "\""
If it still don't work, please show us an example of file.
Best regards
Shong

Re: [resolved] Escape character in csv

Anonymous — Fri, 19 Aug 2011 14:11:09 GMT

Hi Sri
Try
Escape Char: "\""
Text enclosure: "\""
If it still don't work, please show us an example of file.
Best regards
Shong

Hi Shong,
I had the same issue, in fact only keeping Text enclosure: "\"" is required.
The selection of Escape Char seems to be immaterial.
So just wanted to know in which scenario so we use the escape char?
Regards,
Diwakar
Infocepts India

Re: [resolved] Escape character in csv

Anonymous — Tue, 14 Apr 2015 09:09:03 GMT

Hi,
I have same scenario,
Input Row
1\t"Max"\t"The \" Moon"\t"Sky"
Output Row Should be
1 | Max | The " Moon | Sky

I am using Field Separator "\t" , Text enclosure as """ and Escape char as "\"".But its still not working.
What should i use???

Re: [resolved] Escape character in csv

Anonymous — Sat, 26 May 2018 06:24:40 GMT

thanks in advance,

i have a column value in csv file like "CTH#RIO" for this i want to split this value lke CTH and RIO and join with another table from mysql database using tmap component , how can i doo this job

Thanks & Regards