Alteryx Designer Discussions

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

RegEx question

Miki2021
8 - Asteroid

Hi all,

 

I want to replace the original sales order number to SAP number: 

 

Order number on sales platform: 555555 

Order number on SAP: 8000555555

 

Is there a better way to use RegEx to do the trick rather than using Excel to change the raw data?

 

thanks in advance!

 

4 REPLIES 4
Nanoq
8 - Asteroid

if you "just" need to add 8000 in front of the platform number, you can do the folowing in a formula tool:
"8000"+tostring([PlatformNumber])
-no need for regex

Miki2021
8 - Asteroid

@Nanoq thanks for the tip - do I need to change the original numeric format to string?

atcodedog05
21 - Polaris

Hi @Miki2021 

 

You can use the formula like below should take numeric type and give numeric type.

 

ToNumber("8000"+tostring([PlatformNumber]))

 

atcodedog05_0-1634300757203.png

 

Hope this helps : )

 

MarqueeCrew
19 - Altair
19 - Altair

@Miki2021 ,

 

Keep it simple:

 

8000555555  is equivalent to 8000000000 plus 555555

 

Try this formula:

 

8000000000 + [SAP Number]

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Please Subscribe to my youTube channel.
Labels