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?
Solved! Go to 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
Hi
Thank you very much, that did the trick!
No prob! 🙂
Welcome to the community! And if you need anything else just let us know! We are here to help
Regards