Setting Variable From Clipboard (Date&Time)

[sterlingmi]

I am assigning variables from the contents of the clipboard.
One of these variables I am creating is $DueDate$
Below is an example of the clipboard

Due: 10/19/2009 9:00:00 PM

Currently I am using 10 characters after the "Due: ", trimming spaces and returns.

The problem is, if the Month and Day are both single digits, i.e.

Due 1/1/2010 9:00:00 PM

How can I go about getting the correct Date each time, regardless if it is 8 or 10 digits. MM/DD/YYYY


Please Advise.. thanks!

[forumsupport]

Hello,

What you can do is,

. Use String Manipulation command to extract the date from $clipboard$.
. In String Manipulation command, use 'Due:' as Before String, space ' ' as after string and occurrence of space, second i.e. 2.

That way the string between 'Due:' and the second space i.e. the entire date would be extracted.

We have attached a sample task for your reference. Please copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.

Hope that helps.