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

Question

Question

Test expression regular expression in workflow question

asked on May 15, 2018

This is the general format of the text:

12345    67890    COMPUTER HARDWARE&RENEWALS - SOME PLACE.

I am aiming to extract just the text. and really just the first 2 words.

I have this regex ([a-z]+)(\s)+([a-z]+) Seems to be work in the "Test Expression" dialog

but doesnt show in the "Click here to test the token" . Is that normal ?

 

and also doesnt seem to work when I run the workflow, which is supposed to filter out that text and then insert into an SQL table. I am going to trace through the tokens now to determine if it's regex or the workflow. 

 

regex1.PNG
regex2.PNG
regex1.PNG (74.91 KB)
regex2.PNG (64.36 KB)
0 0

Answer

SELECTED ANSWER
replied on May 15, 2018

The second one is correct. In-line regular expression is case sensitive, so it needs to be [a-zA-Z]+\s+[a-zA-Z]+

0 0
replied on May 15, 2018

Perfect !  you are brilliant, thanks for your help and quick replies always Miruna

0 0
replied on May 15, 2018

No problem. Bug reference ID 159634 for the Test Regular Expression dialog being wrong.

1 0
replied on May 16, 2018

thanks ! I never think to look in the bugs and issues, I always assume all software is bug free and its me doing it wrong, lol 

0 0

Replies

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

Sign in to reply to this post.