community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

Quick help with RegEx

Meteor

I am looking to create a formula that finds a string where the end letter is a capital and the letter before that is lower case.

 

So (lower case)(uppercase)(space).

 

How do I translate that to a RegEx? I am struggling to find a good guide to get started with RegEx.

 

Thanks so much,

 

James.

Meteor

Actually I think it is "[a-z][A-Z]\s"?

Alteryx Certified Partner

@jamesgough Hi... you can try test this website... https://regex101.com/

 

Best regards

Alteryx
Alteryx

Hi @jamesgough,

 

I think you got how to look for (lower case, uppercase, space) pattern. Just bare in mind that the "Match" configurationg mode of the AlteryxRegex tool is looking for exact FULL matches, rather than partial. I believe your expression is not going to give you the match that you want. I'd place a .* before your expression.

 

Hopefully the attachment will clarify what I mean.

 

Also, I'd recommend to look at the pre-built RexEx examples in Designer (right click on the RegEx tool -> open example).

 

As already suggested, I also use Regex101.com or Regexr.com to test expressions quickly, before building them in Designer.

 

Hope this helps!

Highlighted
Meteor

Thank you Giuseppe, that's really helpful. 

Labels