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.