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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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