Ignore the delimiter in a string


(Jayant Singh) #1

Hello friends,
We are importing a .txt file with comma as separator into a text file reader. The text file reader has commas as the delimiter. But our field data might have commas n the data, so we enclosed it in double quotes so that it doesn’t get treated as two columns.

"14ALLP_Obligation_Num_High_Lev_Adv_Null_Blank","Obligation Number Highest Level Advised","RISKCOML.IN.CLL_YYYYMM.Obl_Num_HLA","if Obligation number is populated and act_sys_id <> 'DSI', then Obligation Number Highest Level Advised shd not be null or  blank",68410,0,68410,100,"95","Completeness","14ALLP-CLL","T13097A",2019-03-14 16:11:48,"FRY14A-69","2019-01-29

As we can see there is a comma after DSI, which is causing the trouble here. Can we get help on how to configure the text file reader so that the entire string;
if Obligation number is populated and act_sys_id <> 'DSI', then Obligation Number Highest Level Advised shd not be null or blank

is treated as one column. We have a huge .txt file with millions of records, therefore we are trying to avoid manual changes here. Can I kindly get some help?

Thanks in advance.


(Victoria Tuktarova) #2

Hello Jayant,

Please, edit File Metadata by changing String qualifier to " symbol.
It solved the issue for me.

Kind regards,
Victoria