I have a char field that have special characters in it as well like period(.), comma(,) apostrophes(') etc. I am mapping this char field from XML profile to a char field in a csv and i notice it starts adding lines near the comma like this ||| and at the end i have this in the target(ABX AIR|||, INC._ATSG TrueChoice services agreement on CF6-80C2 engines) instead of this from source(ABX AIR, INC._ATSG TrueChoice services agreement on CF6-80C2 engines).
Any idea how i can take care of this? I tried to use String Remove and Replace but nothing worked.