How to load text data contatining delimiter @@@ (thrice) in it , into the postgres database using talend

[Anonymous]

Could you please help with , How to load text data contatining delimiter @@@ (thrice)  in it , into the postgres database using talend.

And Please could you specify how talend is better than pgloader ?

[Anonymous]

Could you please help with , How to load text data contatining delimiter @@@ (thrice)  in it , into the postgres database using talend.

And Please could you specify how talend is better than pg loader ?

[manodwhb]

@sam_6295,delimiter you specify in tFileinputDelimited as shown below load it tpostgressqlouput.

[manodwhb]

@sam_6295,still do you have this issue?

[Anonymous]

Hi Manohar,

the solution that u suggested worked for me as well,  however if we get the same delimiter as a value, how shall we proceed ??

[TRF]

In this case the content must be protected in source file (using "") or delimitors must be escaped (using \ before each character to be protected).

Tick the "Option CSV" field to defined the desired options.

[manodwhb]

@saurabh06101987, As you need to use like below. and data should be in enclose.