AnsweredAssumed Answered

How to remove lines from a Char field instead of comma ,

Question asked by priyanka1.sharma567251 on Jun 6, 2016
Latest reply on Jun 8, 2016 by Thameem Khan


Hi,

 

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.

 

 

Thanks

Outcomes