You are viewing limited content. For full access, please sign in.

Question

Question

Quickfields regular Expressions not working

asked on October 2, 2017 Show version history

I have been having a lot of issues with Regular expressions not working with Quickfields lately.

Regular Expression: 

Patient\S\s?(.+)\s+Health Plan ID\S\d+

 

String testing:

Claim #: 99999E99999 Provider: AYERS, CHASE
Patient: JOBS, STEVE E Health Plan ID:000099999999 Patient #:9999999999
Dates of Procedure Msg Billed Allowed Provider Deductible Copay Coinsurance Ili Other Paid

Total Net Payment  $384.00 
Patient Responsibility: $96.00
Claim #: 88888E88888 Provider: AYERS, CHASE
Patient: TESLA, NIKOLA Health Plan ID:000023138200 Patient #:1361969157
Dates of Procedure Msg Billed Allowed Provider Deductible Copay Coinsurance Ineligible Other Paid

 

 

I am also trying to use Multi-Value Groups for these Patient names and it is not working as well.

I use the token accumulator and pass the values through but no success thus far.

Here is the Pattern Matching Token.

Here is the Token Accumulator for the Multi-Value Field "Patient Name"

Testing REGEX:

Looks as though (.+) grabs all up to a certain point and ignored the Health Plan after.  I'm trying to grab anything between "Patient: " and " Health Plan"

 

Any help as to why the (.+) isn't working would be appreciated.

0 0

Answer

SELECTED ANSWER
replied on October 3, 2017

[ ] is for "characters in the specified range" (for ex, [abc] matches a, b or c.

[^ ] is for "characters not in the specified range" (for ex, [^abc] matches any character except a, b or c.

\n is the end of the line, so [^\n] matches any on character on the current line. That restricts the search for the pattern only to the current line.

1 0

Replies

replied on October 3, 2017 Show version history

It appears that since you have multiple customers in the text it is pulling all the way to the last Health Care text.  In my testing it stops after Nikola.

 

2 0
replied on October 3, 2017

This works as designed since .+ matches everything between the first "Patient:" and the last "Health Plan ID". Try changing .+ to [^\n]]+ so it will stop at the end of the line when figuring out how much to match.

2 0
replied on October 3, 2017

Amazing!  Yes I knew it had to be the ".+" since it grabs all essentially.  I wasn't sure how to stop it up to knew line and look at only the current line information. 

Looks to be outputting my test example as I expected now.  I will play around more with the [^\n]+  Thank you!

0 0
SELECTED ANSWER
replied on October 3, 2017

[ ] is for "characters in the specified range" (for ex, [abc] matches a, b or c.

[^ ] is for "characters not in the specified range" (for ex, [^abc] matches any character except a, b or c.

\n is the end of the line, so [^\n] matches any on character on the current line. That restricts the search for the pattern only to the current line.

1 0
replied on October 2, 2017 Show version history

Output result I was expecting was:

Pattern Match:

JOBS, STEVE E

TEALS, NIKOLA

 

And the Multi-Value Field Group:

Patient Name - JOBS, STEVE E

Member ID - xxxxx

 

Patient Name - NIKOLA, TESLA

Member ID - xxxxx

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.