HOW TO EXTRACT DATA FROM A TRANSACTION ITEM THAT IS A FILE NAME

I have a process whose transaction item is a file name (ACCESS_ATM_CPD_31-Dec-2020_SETT_04-Jan-2021 chk (1)). I need to extract the date(31-Dec-2020) and put it in a column on my output file. How do I do this?

To extract the date u can use below Assign activitiy

date_1=System.Text.RegularExpressions.Regex.Match( Path.GetFileName(transactionitem),“(?<=CPD_).*(?=_SETT)”).Value

Where transactionitem is filepath (I think)

After extracting date_1 u can add to datatable

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed::relaxed: