RegEx question

[Miki2021]

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!

[Nanoq · Accepted solution]

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]

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

[atcodedog05]

Hi @Miki2021 

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

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

Hope this helps : )

[MarqueeCrew]

@Miki2021 ,

Keep it simple:

8000555555  is equivalent to 8000000000 plus 555555

Try this formula:

8000000000 + [SAP Number]

Cheers,

Mark