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: 
Ghosh612
Contributor
Contributor

There is a comma in data in lookup file, cant seem to read it as one column

Dear All,

I have been on this issue, but couldnt get it to work, I have a transaction file, and 5 lookup files, so i am doing this:

tfileinputdelimited_Transactions>>>>Tmap>>>>tfileoutputdelimited

|

tfileinputdelimtited_textfilelookup

The problem is that one of the lookup files has a comma in the data, so it reads it as a new column.

0695b00000EbEVNAA3.pngAbove is the image.

How to get this as "Scissors Rulers and Trimmers" as one column data?

I am using a tfileinputdelimited (csv) for reading the schema.

Thank you.

Labels (2)
1 Solution

Accepted Solutions
gjeremy1617088143

Hi , if your file have only 2 fields like your example :

(your string).replaceAll("(?<!(CAT(\\d{1,5}))),","")

 

it will supress comma not preceded by (CAT+ 1 to 5 digits).

Send me Love and Kudos

 

View solution in original post

2 Replies
gjeremy1617088143

Hi , if your file have only 2 fields like your example :

(your string).replaceAll("(?<!(CAT(\\d{1,5}))),","")

 

it will supress comma not preceded by (CAT+ 1 to 5 digits).

Send me Love and Kudos

 

Ghosh612
Contributor
Contributor
Author

I had to take the output to a new file,take that file as the schema and then work with that.

 

Your expression helped in understanding the basic thing.

 

Thank you.