topic Re: parse using regex in Alteryx Designer Desktop Discussions

parse using regex

umairah — Mon, 07 Sep 2020 05:18:29 GMT

Hello,

I have data that I want parse and try to do the expression to get the result but it's only work in some field. Really appreciate anyone can point out what I do wrong here. .

I will attached the sample data for your reference.

Re: parse using regex

seinchyiwoo — Mon, 07 Sep 2020 07:25:49 GMT

This should work:

(\d+.\d+\s*)(\(.*\))([\w*\s*\.*\,*]*)\s(\d{1,2})

and the output looks like this:

Cheers,

Seinchyi

Re: parse using regex

umairah — Mon, 07 Sep 2020 07:43:51 GMT

Hi @seinchyiwoo ,

Thank you..It helps me alot.