Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Karuetl
Creator II
Creator II

File containing [

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

 

 

Labels (2)
2 Replies
TRF
Champion II
Champion II

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.
Karuetl
Creator II
Creator II
Author

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

 

i meant including the brackets into the table