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

[Ghosh612]

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.

Above 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.

[gjeremy1617088143 · Accepted solution]

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]

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.