How to get date from list

Help
1

Hi,
I have a different list of String and the list contains different strings, i want to print the date from list. But note that the format of date is not fixed. Following are the example of different list.

List 1
S/B
No/Dt.
34536
28/06/2018

List 2
SB
No.
/
Date
4545765
21-Jun-2019

List 3
Job
No.
5465
Job
Dt
10/Sep/2019
User
Job

2

Hi @akshay765

Use this based on add to collection activity and pass the list and collection as item

and print the item

Thanks
Ashwin S

1 Like
3

You can use Regex to retrieve the dates from each list (you will have to play around as there could be other variations as you have shown.)
Example Regex below (Regex Option Ignore Case should be selected):
"^([0-2][0-9]|(3)[0-1])(\/?-?)(((0)[0-9])|((1)[0-2])|(\w{3})?)(\/?-?)\d{4}$"

This should match all three dates you have mentioned.

1 Like
4

@TimK Thank you it worked fine…

1 Like
5

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