Extract a text from right to left in excel

lourena.coutinho · July 20, 2021, 3:42pm

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

ganesh4 · July 20, 2021, 3:45pm

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

Same like this

prasath17 · July 20, 2021, 4:06pm

@lourena.coutinho - How about this??

Hope this helps…

lourena.coutinho · July 20, 2021, 6:11pm

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

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

prasath17 · July 20, 2021, 6:28pm

@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…

lourena.coutinho · July 21, 2021, 6:28pm

I Used the right and left activity and works.

Thanks

system · July 24, 2021, 6:28pm

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