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