Last words in an item

Hi Team,

I am reading row items. In message box item contains like below
Reference Name Amount Date Description
R12345 ABC $555 08/08/20 This is me

How to extract the last column(Description) that is “This is me”

1 Like

Hellow @Robotics,

You can use Matches Activity and Pass Items as Input to the Matches Activity and use this pattern to get Description (?<=\d{1,2}/\d{1,2}/\d{2,4}).*

Cheers
@Robotics

Its not working. There will be different words will be there just like This is me. If bot encounters the words ‘This is me’ it has to perform an action.

Hello There,

You have two methods to achieve this,

  1. String.contains method,
  2. String.substring method.

Thanks,
Pankaj

1 Like

@Robotics Use (?<=(\d{2}/\d{2}/\d{2}).).* to obtain the description column value. It matches the Date and then return the description in result.
image

Although @Pankaj.Patil has a valid answer if you just want to take decision True or False

Thanks Pankal, i found a solution with the given options.