Question

Regex captures using the 9.1 connector

Connector

Updated July 23, 2015

asked on July 23, 2015

Are multiple capture groups supported with regex expressions in the 9.1 connector? I'm trying to capture a string from a web app - a name formatted as "last, first m. (1234)", so last name, first name, middle initial with a period, and then last four of SSN enclosed in parens. I need to strip the period out of the middle initial of that string, and a simple (.*)\.(.*) would do it, but it appears the connector only captures the first group. Any ideas?

Thanks,
Geoff

1 0

Replies

replied on July 23, 2015

Thanks Glen, with the new token dialog in 9.1 all I had to do was use the same token twice and split and recombine:

{[Client Files]:[Client Name]="ClientName ClientName"}

with two different regex expressions applied to the ClientName token to drop the "."

3 0

replied on July 23, 2015

Try making multiple tokens (LastName, FirstName, NiddleInitial, SSN) and combining them.

0 0

replied on July 23, 2015

Never thought about selecting the same field more than once and splitting/combining with the token editor. Worked great, thanks!

Geoff

0 0

replied on July 23, 2015

You should be able to capture the entire string, then customize the profiles XML document to extract only the needed part of the string. There is an example given in the Connector help file in the "Editing control and token strings" section.

0 0

You are not allowed to follow up in this post.

Question

Question

Regex captures using the 9.1 connector

Replies

Sign in to reply to this post.