Compare two strings which has few words same and few is differently wrote

Help Activities
, ,
1

Want to compare two strings for each of the row in my Excel Filtered Data.
For each row :

024-abc abc abc - from Extracted data table
abc abc abc-24 - from Excel

022-xyz xyz xyz - From extracted data table
xyz xyz xyz-22 - from Excel

Thanks

2

Each row as a combined string or field by field ? @PALKUMARI_PATEL

3

Hello @PALKUMARI_PATEL

Do you need to split the string to individual words and then do the comparison?

lIKE 024-abc-abc-abc to 024,abc,abc,abc. ???

4

No, not each words but if string is 24 - abc xyz pqr then have to look for abc xyz pqr in other string.

5

Field by field.

6

If that is field by field then you have another datatable?

7

I have to get only text values … there is number and - (symbol) so just have to compare text values.

8

@Rahul_Unnikrishnan
Can you please help me here ?

9

Kindly post a sample text. Regex can be used here.

10

The text is in the question. Do you need something else ?

Want to compare two strings for each of the row in my Excel Filtered Data.
For each row :

024-abc abc abc - from Extracted data table
abc abc abc-24 - from Excel

022-xyz xyz xyz - From extracted data table
xyz xyz xyz-22 - from Excel

11

Hello @PALKUMARI_PATEL

So do you you need to get the matched items and unmatched items in both the tables? is that the requirement? if yes, you can do as below video.

12

Hello @Rahul_Unnikrishnan , Thanks for sharing.

Want to compare two strings for each of the row in my Excel Filtered Data.
For each row :

024-abc abc abc - from Extracted data table
abc abc abc-24 - from Excel

022-xyz xyz xyz - From extracted data table
xyz xyz xyz-22 - from Excel

13

After comparing are you trying to find any matched string or can you share a expected output.

14

I have to match the strings and then have to perform further actions if match then process if not then not .

IF match the strings then working on something to achieve. See below.

15

I achieved this by using below.
image

Thank You Everyone for helping.

16

Hello @PALKUMARI_PATEL

Here you will be getting the first 2 characters. How this will help for the comparision?

17

So, here I am removing first 3 characters of the first string. I have to remove only first 3 character of the each string that I am getting from DT1.

Then use the Contains condition .

I am checking Var2.contains(Var1).
Which is giving me true or false value if it matches or not.

18

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