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.
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.