Compare the words from two rows?

[hernan]

Hello everyone! I'm doing a reconciliation so I have to compare two rows from my collection but the column description sometimes can be different.. so my question is if there is something... action that could tell me if there is something equal there? thanks!

 

[VJR]

Hi hernan,

I guess by "column descriptions are different" you meant that the column headings or the collection fields are different each time.
If so, see if you can make use of the below two actions of the 'Utility - Collection Manipulation' VBO-
Get Collection Fields
Read Collection Field

 

[hernan]

For example in one row I have the description "AXAYAZ 2824242 ABC" and the next one is "2824242 ABC AXAYAZ".. if I see both are from the same operation but it depens of the user who writes it... and sometimes it could be more different but there is something (sometimes) that tell me that is about the same thing... so my question is if robot can read the descriptions and tell me if there is something related to. Thanks!

 

[VJR]

Hi hernan,
Instr function is used to check if one word is within another string.