Newbie regex - Replace and phrase to coloumns

[Hamder83]

Hi 

As the topic states, i'm kinda new to alteryx. And ive been googeling for hours now, and im still not able to do a simple regex task.

1.: Filename: "Faktura_04827407_Kolli"

I wrote \<Faktura_ in regex as replace 

and then done a formula removing the last _Kolli - since im not able to add them in the same expression? 

2.: Filename: "PostNord AS kundenummer 3802006 UNITED BROKER AS/MASAI CLOTHING"

I want to remove everything beside 3802006 - and then I want to use kundenummer as header for the coloumn, and fill the coloumn with 3802006

Does it make sense? 

[afv2688 · Accepted solution]

Hello @Hamder83,

By using on the regex tool the command  [^\d] you will get only the numbers from each line:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

[Hamder83]

Hi 

Thank you very much, that did the trick! 

[afv2688]

No prob! 🙂

Welcome to the community! And if you need anything else just let us know! We are here to help

Regards