Simple Regex question

[Hamder83]

Hi 

I get a bounch of excel files every month and I wanna automate a flow around this.

I need simply to extract the customer number - and the files always has a similar structure like this:

Same goes with month:

Ubsend - Draft 1006609 Jill & Joy A S (DKK) Account no 1000000003 Month oktober

Ubsend - Draft 1005719 Tøj Holstebro ApS. (DKK) Account no 1000000017 Month juli
Ubsend - Draft 1006618 Tøj Holstebro ApS. (DKK) Account no 1000000017 Month oktober

Ubsend - Draft 1006381 T.S. Retail A S (DKK) Account no 1000000016 Month september

Ubsend - Draft 1004434 Bestseller Stores Austria GmbH (EUR) Account no 1000000338 Month februar


So Customer number and Month 🙂 

Can any of you regex gods help me? 🙂 

How can I 

[atcodedog05 · Accepted solution]

Hi @Hamder83 

This regex should work

Regex Tool | Parse mode

(\d*)\sMonth\s(.*)

Config:

Output:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Qiu · Accepted solution]

@Hamder83 
Just to elaborate the suggestion from @atcodedog05 

[Hamder83]

Hi

Holy you guys are geniuses!

Thank you for the help 🙂 

[atcodedog05]

Happy to help 🙂 @Hamder83 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂