Difference in Data from Queue and Excel

Hi Team,

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.

I am getting values till my if condition but does not go inside ‘Then’.

Below is the output difference:
Queueitem: “As per DATA, The PO to Tech data shall be cancelled\\n Data will be preparing information for Supplier”

row(3).ToString: “As per DATA, The PO to Tech data shall be cancelled\nData will be preparing information for Supplier”

Does \n and \\n create difference ?

please advise :expressionless:

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”

image

Regards
Anand

Hi @anandji05,

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.