topic Re: Data Parse in Alteryx Designer Desktop Discussions

Data Parse

Nandakishore — Thu, 13 Jun 2024 21:42:56 GMT

Iam trying parse data using regex with : (\w+) as expression . But tool considers decimal as spac

Re: Data Parse

Bren_Spill2 — Sun, 18 Feb 2024 18:11:59 GMT

Hi @Nandakishore - see attached. Does this help?

Re: Data Parse

Nandakishore — Sun, 18 Feb 2024 18:16:51 GMT

hi @Bren_Spill2 ,

It worked for that column . But it stopped parsing the other columns there on . Rest of the columns are null .

Thanks.

Re: Data Parse

apathetichell — Sun, 18 Feb 2024 19:32:02 GMT

Do you have sample data of your input and what you are looking for? decimal is not a \w in regex. If have additional characteristics you are looking for - you'll need to to specify them another way.

Re: Data Parse

Swathi — Sun, 18 Feb 2024 20:45:08 GMT

Try this in your RegEx

(.*\..*)

.* - match any char except newline zero or more times

\. - the actual dot

.* - match any char except newline zero or more times

Please mark it as solution if it helps

Re: Data Parse

Nandakishore — Mon, 19 Feb 2024 01:42:18 GMT

hi @Swathi, @apathetichell , @Bren_Spill2 ,

My data is this : 12345.4566 ASDFGH QWERT

Result after parse must be :

12345.4566

ASDFGH

QWERT

When using the expression (\w+\.\w+) the result is :

12345.4566

Null

Thanks

Re: Data Parse

gawa — Mon, 19 Feb 2024 02:50:28 GMT

hi @Nandakishore

Please try the attached WF with regex as follows.

First captured group (-?\d+\.?\d*) can match any positive(+) or negative(-), integer/decimal. Please check it out.

(-?\d+\.?\d*)\s(\w+)\s(\w+)

Re: Data Parse

Nandakishore — Mon, 19 Feb 2024 17:54:11 GMT

Hi @gawa ,

This is not working . Regex is applied only to one column and rest are null.

Re: Data Parse

Nandakishore — Mon, 19 Feb 2024 18:08:29 GMT

@gawa my data set looks like this :

0000011 0 2.000 KGM 1

Re: Data Parse

gawa — Tue, 20 Feb 2024 00:56:30 GMT

@Nandakishore

Now I see your point. If my understanding is correct, you should use Text to Column tool with space as a delimiter.

You can choose option (1) Split into columns or (2)Split into rows, whichever you like.

Regex tool is still an option, it seems Text to Column should be the best to pick first.