I have a requirement to extract some data from an approval letter in word document to an excel document. I was able to use Word Application Scope, read content and extract some data. But I am having a challenge in extracting a date.
Date Requirements:
May or may not be present
May be in any format – mm/dd/yy or Month DD, YYYY or DD Month YYYY etc.
May be anywhere above the body of the letter.
It would be great if anyone can provide any insights.
hi @arunasan …Paste your text in any regex tool, I would prefer .NET Regex Tester - Regex Storm - (this works well with UiPath) and the regex pattern …and see if you are getting any result.
@prasath17
Thank you Prasath. I tried with the tester and it didnt result any match for December 23, 2020. I removed the comma and it returned one match.
@wasea
Thank you so much. I was going to remove commas from text to get the date as I didnt realize I can add more patterns.
Is it possible to convert dates in any format to mm/dd/yyyy esp format like December 23, 2020?