Extract a text from right to left in excel

I need the robot to read a description in Excel and extract only the text that is right to left into the space, but the size of this text is dynamic

for example:

Description
too long text - extract : text
tomorrow and today - extract: today
0923483574 123 - extracts: 123

You can loop through by row and use split function and get last value of the array

Same like this

1 Like

@lourena.coutinho - How about this??

image

https://regex101.com/r/fzsZ2h/2/

Hope this helps…

2 Likes

@prasath17

I’m trying to use it, but when the robot goes to write the extracted value in excel, the following error occurs:

image

I don’t know if I’m using it correctly

@lourena.coutinho - Your Input text may be different i guess. Whatever the text you have provided, I was able to extract the values…

If you could share the exact text (by masking the sensitive info)…we can take a look…

I Used the right and left activity and works.

Thanks

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