topic Re: Regex extract 2 values (dates) from string using tExtractRegExFields in Talend Studio

Regex extract 2 values (dates) from string using tExtractRegExFields

mobmsc2 — Wed, 19 Apr 2017 12:22:16 GMT

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 ?

Re: Regex extract 2 values (dates) from string using tExtractRegExFields

mobmsc2 — Wed, 19 Apr 2017 13:47:28 GMT

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"

Re: Regex extract 2 values (dates) from string using tExtractRegExFields

TRF — Wed, 19 Apr 2017 13:52:30 GMT

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,

Re: Regex extract 2 values (dates) from string using tExtractRegExFields

mobmsc2 — Wed, 19 Apr 2017 14:01:39 GMT

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})"

Re: Regex extract 2 values (dates) from string using tExtractRegExFields

cterenzi — Wed, 19 Apr 2017 14:04:42 GMT

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