Comparing Excel Row Values

Help Studio
, ,
1

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

image
image1866×154 46.5 KB

image
image1692×148 43.4 KB

2

you want compare and remove?

3

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.

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.