Requirement: Source file:
abc,''test,data'',valid
xyz,''sample,data'',invalid
the data in source file we need to read dynamically. We are reading entire data in one string column. One of the value and file delimiter have comma separator. I have to load data in target table as follows with out double quotes Target table :
Col1|Col2|Col3
abc|test,data|valid
xyz|sample,data|invalid