Get Last 3 digits in each cell

Hi!

I have a list of data that goes like this:
SGS1102
SGS1103
SGS1104

I need to get the last 2 digits of the string and then compare it with one cell above (for eg: comparing 04 with 03) to see whether there are any missing entries. May I know what the process will look like in Uipath?

Thank you!

is your list of data an excel column or just a list in uipath?

Example list:
image

create new list that contains last 3 characters of “testList”
image

print out new list
image

Result
image

Thank you! It works!

1 Like

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