topic Re: Text Enclosure and Escaping Character in Talend Studio

Text Enclosure and Escaping Character

Anonymous — Wed, 05 Dec 2018 06:28:53 GMT

TestColumn1;TestColumn2;"TestColumn3:1;TestColumn3:2";TestColumn4

the above sample data contains delimiter as data in the 3rd column and i wish to fetch the data as

TestColumn1

TestColumn2

"TestColumn3:1;TestColumn3:2

TestColumn4

the main concern here is to understand the working of "Text Enclosure and Escaping Character" option in tfileInputdelimited .

it would be really helpful if someone can explain this in detail that what these 2 options works and how they works.

Re: Text Enclosure and Escaping Character

manodwhb — Wed, 05 Dec 2018 07:45:14 GMT

@CK395,since when you enable CSV option,in tFileInputDelimited,you can set those two options.

check the below link,you will understand the use case.

https://stackoverflow.com/questions/43512095/usage-of-escape-char-and-text-enclosure

Re: Text Enclosure and Escaping Character

Anonymous — Thu, 06 Dec 2018 06:58:30 GMT

Hi @manodwhb ,

I am through that link already and it did not perform as it mention.

it would be helpful if you can explain it.

Regards

Chandra Kant

Re: Text Enclosure and Escaping Character

manodwhb — Thu, 06 Dec 2018 07:19:02 GMT

@CK395,for Text Enclosure,for suppose your filed data is in like "Hello" then you will specify the """ .

for Escaping Character,which you want to be print as part of the data.

Re: Text Enclosure and Escaping Character

Anonymous — Thu, 06 Dec 2018 12:56:08 GMT

Hi @manodwhb,

You mean if the data contains inverted commas <"$$$$$$"> then only data<$$$$$$$> can be fetched using TextEnclosure """ and to keep some symbol within the data that must be specified as Escape Character.

can you specify the <Text Enclosure> and <Escape Character> for case given below and please test it in a job.

input :< TestColumn1;TestColumn2;"TestColumn3:1;TestColumn3:2";TestColumn4>

output :

Column1	Column2	Column3	Column4
TestColumn1	TestColumn2	TestColumn3:1;TestColumn3:2	TestColumn4

Column1	Column2	Column3	Column4
TestColumn1	TestColumn2	"TestColumn3:1;TestColumn3:2"	TestColumn4

i think it would clear some doubts.

Regards

Chandra Kant

Re: Text Enclosure and Escaping Character

manodwhb — Fri, 07 Dec 2018 05:09:05 GMT

@CK395,for input :< TestColumn1;TestColumn2;"TestColumn3:1;TestColumn3:2";TestColumn4> you will get the below output.

if you wan to know more about these,try to create metadata in the repository by using CSV option and you can play with option and get to know how the would be extracted form that csv.

Re: Text Enclosure and Escaping Character

Anonymous — Fri, 07 Dec 2018 06:54:57 GMT

hi @manodwhb,

this one simply worked with Escape<"""> and Enclosure<"""> once I restarted the Talend but was not working previously ,

Talend might be having some processing issues.

I appreciate your helpful replies and patience.

Thanks and Regards

Chandra Kant

Re: Text Enclosure and Escaping Character

manodwhb — Fri, 07 Dec 2018 06:56:30 GMT

@CK395,great, Please provide Kudos also