Regex extract 2 values (dates) from string using tExtractRegExFields

[mobmsc2]

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

"(\\d{2}-\\D{3}-\\d{4})"

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

(\d{2}-\D{3}-\d{4})

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 ?

[mobmsc2]

The following regex strings either generate an error or don't extract both dates

"(\\d{2}-\\D{3}-\\d{4}).(\\d{2}-\\D{3}-\\d{4})"
"\\+(\\d{2}-\\D{3}-\\d{4})"
"(\\d{2}-\\D{3}-\\d{4})//g"

[TRF · Accepted solution]

Hi,

Define the tExtractRegexFields schema as:

and the regex as:

"(^.*)(\\d{2}-\\D{3}-\\d{4})(.*)(\\d{2}-\\D{3}-\\d{4})(.*$)"

Here is the result from tLogRow:

Hope this helps,

[mobmsc2]

Thanks the 

.*

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

"(\\d{2}-\\D{3}-\\d{4}).*(\\d{2}-\\D{3}-\\d{4})"

[cterenzi]

Well that escalated quickly.  I missed three replies while typing my own!