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
Solved! Go to Solution.
Hi @ssaz
Sorry to ask more questions, as you have used (\d{2})(.)(\s+)([^a-z]+)
Each () helps to parse as a separate column, hence wanted to understand more what is the expected output.
Also input is more important too.
Hi!
The input will have rows of string but i would like to filter the row with this pattern only: 31. TOPIC which start with numbers and then alphabet.
Hi! The input will have rows of string but i would like to filter the row with this pattern only: 31. TOPIC which start with numbers and then alphabet.
@binuacs @ShankerV
Thank you it works! but this regex syntax "\d{2}\.\s[A-Z]+" and "\d{2}.\s{0,1}[a-z]+"not working if the alphabet having space or dash or starts with 1 digit only, example of other input
31. TOPIC
22. SHARE CAPITAL
2. SHARE-CAPITAL
i have updated to range for digit to "\d{0,3}.\s{0,1}[a-z]+" and it works well if the digit only 1 or 2 but still not working for other pattern of words with dash or space