I could do with some help with tExtractRegexFields from the community. Given the string below
some text to begin with Start Date : '01-SEP-2016' , End Date : '30-SEP-2016'. Download 30-SEP-16
I want to extract Start Date and End Date values. I have the following RegEx
which will extract "a valid value" but doesn't extract both dates (I'm doing further processing to get the download date). My output schema is a generic schema of 2 nullable strings but only the 2nd value is extracted and stored in the 1st schema position.
When I use http://regexr.com/ and remove the escape "\" chars the regex above becomes
and will highlight both matching dates which seems to imply the regex is valid for both date values, it just won't extract both values.
Can anyone provide me with some pointers to capture the 1st and 2nd dates and store them in the correct positions in the output ?
Solved! Go to Solution.
The following regex strings either generate an error or don't extract both dates
you had inside the capture group to extract the middle text (which I'm reading as zero or more characters) was what I needed followed by the Date extractor again which gave me