Comparing Excel Row Values

[marina.dutta]

Hi All,

I want to compare two Excel row values ignoring any spaces (front /back ) and also ignoring any special characters $, . etc . Please let me know , how can I compare the row values.

Below are my two Excel Rows

[natanael.mendes]

you want compare and remove?

[Dari (César Dariel Arévalo Pérez)]

At the moment that you are extracting the values for comparison you can use ‘contains’
Example:
Value1.ToString.Contains(Value2.ToString)

You can use this in an Assing Activity. ‘Contains’ return boolean.