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

Two Stars

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

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 ?

Two Stars

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

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 ?

Thirteen Stars

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

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

Manohar B
Thirteen Stars

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

@sam_6295,still do you have this issue?

Manohar B
Six Stars

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

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 ??

 

delimeted file processing.PNG

Forteen Stars TRF
Forteen Stars

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

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.


TRF
Thirteen Stars

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

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

Untitled.png

Manohar B