RegexMatch Digit and Alphabet

[ssaz]

Hello,

Appreciate if anyone could help on how to write regex to find the match for below:

31. TOPIC

I have tried (\d{2})(.)(\s+)([^a-z]+) which it works in regex101.com but not working in Alteryx.

Thanks

[ssaz · Accepted solution]

I found the solution and updated the regex syntax to REGEX_Match([Data], "\d{0,3}.\s{0,1}[A-Za-z\-\_\s]+") these matches well , anyway thanks for the initial help!

[ShankerV]

Hi @ssaz 

Please find the expected output is both ways.

Many thanks

Shanker V

[binuacs]

@ssaz 

[ssaz]

I realised one more thing my criteria for the words supposedly matching for all uppercase characters only, i updated the regex to this REGEX_Match([Data], "\d{1,3}\.\s+[A-Z\-\_\s]+") but not working to get pattern of numbers with uppercase alphabet.

[binuacs]

@ssaz attaching the regex

REGEX_Match([Input], '^\d{1,}.*[A-Z]+[\s\-]?[A-Z]+$',0)

[ssaz]

@binuacs

seems like the above regex capturing this pattern as well "3.2c Standard by ABCD"

[ssaz]

I have updated the regex to this REGEX_Match([Data], "\d{1,}\.\d{1}\s+[A-Z\-\_\s]+$",0) or
REGEX_Match([Data], "\d{1,}\.\s+[A-Z\-\_\s]+$",0), its working almost perfect now just not efficient enough since need to use both regex pattern

[binuacs]

@ssaz please try

^\d{1,}\.\s.*[A-Z]+[\s\-]?[A-Z]+$