Hello,

Creating synonym using Delimited Flat file and TAB is Delimiter, but one of field is come with double quotes for example "ABC, RI" how to avoid or remove this double quotes. Is possible in synonym creation process or data flow and how ?

Those Double quotes are telling you that this is a string. When you are creating your synonym select Delimiter = TAB, And Enclosure (double Quotes). they do this because there is a comma in the field "ABC,RI"

If it was a comma delimiter file without the Double quotes around it would not parse right.

This message has been edited. Last edited by: ray_In_Vancouver,

Thank Ray.

It works after adding double quote in the enclosure.