Regex help for SAINT Rule Builder

[ForgotPassword4Times]

Currently have strings coming in with two formats. Some strings end with the character “|” and other strings do not. For example, one value might is “ush|park-map|” and another value is “ush|theme-parks”. The goal is to remove the last pipe “|” from the string IF the string ends with a “|”.

In the SAINT Rule Builder, I was able to remove the last pipe “|” from strings that ended with a pipe “|”. However in the final output, the strings that did NOT end in a pipe had “**Unmatched**” as the final value (1st screenshot below).  The question is how can you return the original/default value if the string doesn’t meet the rule criteria (aka ending with a “|”)?  

We'd greatly appreciate your help, thanks!

David

[ForgotPassword4Times]

I'm not very knowledgeable about regex, but I think you can adapt this to work for your use case.

^((.+)\_(.+)\_(.+)\_(.+)\_(.+)\_(.+)|(.+)\_(.+)\_(.+)\_(.+)\_(.+))$

In this case $2$8 mapped to the first field (depending on if there are 4 or 5 underscores.  You could shift and shorten this for the pipe.

[AlexisCazes]

try this (.+)(\|)?$

[AlexisCazes]

SO basically you are saying there is either zero or one of pipe at the end like a? Zero or one of a

[#5]

Dear Dabressler,

You just need to stack the conditions properly. Below you go:

And the test results are as below:

I Hope, this is what you are expecting.

Thank You, Arun.

[#6]

The correct regex is (.+)(\|)?$

Notice the ? at the end of (\|) which stand of zero or one of pipe