Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Get Invoice number from string (REGEX Function?)

jaapkluck
6 - Meteoroid

Dear Community,

 

I am looking for a way to extract invoice number from a string.

The invoice numbers always start with: EE and has 6 numbers after EE*.

 

However, the position of the invoice number in the field might differ and sometimes a dot is put behind the invoice number.

 

Text
BGRT - 1234-2314 - Credit invoice for EE205135
BGRT - 1234-2314 - Credit invoice for EE205115.
BGRT - 1234-2314 - Credit invoice for EE245135
BGRT - 1234-2314 - EE205935 Credit invoice

 

I hope somebody can help me.

 

Kind regards,

Jaap 

3 REPLIES 3
messi007
15 - Aurora
15 - Aurora

@jaapkluck,

 

Please see below:

 

messi007_0-1615967058632.png

Attached the workflow,

 

If this solve the problem please make it as solved it will help others,

 

Regards,

jaapkluck
6 - Meteoroid

Thanks a lot. Is there some clear guidance how to use the Regex tool so i can learn this myself?

 

 

messi007
15 - Aurora
15 - Aurora

@jaapkluck,

 

Alteryx provide an example for each tool

 

messi007_2-1615968368910.png

 

 

You can take a look here as well 

 

messi007_1-1615968324988.png

 

Google is your best friend also 🙂

Best Regards,

 

 

 

 

Labels
Top Solution Authors