topic Re: File containing [ in Talend Studio

File containing [

Karuetl — Fri, 12 Oct 2018 17:03:12 GMT

I have a file which is as below

"a","1212","["abac@gmail.com"]","12"

Unable to load due to there is doublequotes inside the [

Need help to resolve this

Re: File containing [

TRF — Sat, 13 Oct 2018 18:30:04 GMT

In such a case you can use a tFileInputFullRow and replace the undesired character sequences using String.replaceAll() method in a tMap.
If you don't want to remove anything, use String.split() method to retrieve each part of the record.

Re: File containing [

Karuetl — Thu, 18 Oct 2018 16:55:34 GMT

I need to get load as entire ["abac@gmail.com"]

i meant including the brackets into the table