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
Happy Automation