Hi
Iam trying parse data using regex with : (\w+) as expression . But tool considers decimal as spac
Hi @Nandakishore - see attached. Does this help?
hi @Bren_Spill ,
It worked for that column . But it stopped parsing the other columns there on . Rest of the columns are null .
Thanks.
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.
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
hi @Swathi, @apathetichell , @Bren_Spill ,
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 | Null |
Thanks
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+)
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.