topic Extract Text from a String in Alteryx Designer Desktop Discussions

Extract Text from a String

rjesus1987 — Wed, 19 Mar 2025 18:12:50 GMT

Hello,

Need guidance/expertise on how to extract a specific phrase/text from a string using a formula tool (eg. REGEX Replace). I tried REGEX Replace ( REGEX_Replace([Question], '(\d+) .*', '$1') ) but can only get result 1 but having a hard time extracting result 2.

Based on the Question column, I need to show add to new columns (Result 1 & result 2)

Question	Result1	Result 2
1.1 What is your name	1.1	What is your name
2.11 Where do you live	2.11	Where do you live
3.1 What is the name of your 1st pet	3.1	What is the name of your 1st pet
4.15 How old are you	4.15	How old are you

Re: Extract Text from a String

Pilsner — Wed, 19 Mar 2025 18:21:32 GMT

Hello @rjesus1987

I have given this a go using the Regex tool.

The statement used ([1-9\.]+)\s to get all numbers and decimal points, up to the first space.
The statement \s(.*) gets everything after the first space.

By setting the regex to Parse, you can get the two results columns you are after.

Please let me know how you get on.

Regards - Pilsner

Re: Extract Text from a String

binu_acs — Wed, 19 Mar 2025 18:22:12 GMT

@rjesus1987 try