I am trying to read a queueitem and check via for each row if that queueitem is available in the excel, if matched, it should update the status in specific column.
If this value is fixed and only difference is “\n” and “\\n” then you replace this value. like this.
Assignment activity…
String str=“As per DATA, The PO to Tech data shall be cancelled\nData will be preparing information for Supplier”
Thanks for your revert, I tried str.Replace("\\n", System.Environment.Newline) str.Replace("\\n", "\n") str.Replace("\\n", vbCrLf)
in all of the cases, it gives below statement in message box:
As per DATA, The PO to Tech data shall be cancelled\nData will be preparing information for Supplier
I had this happen to me with some unicode decimal characters. I applied regex to do the data-cleaning.
For your newline \n and \\n problem, try having a Match activity and build a regex statement such as match all charcters. That should strip away any special newline items.