REGEX Replace

[ryanmor24]

So I have ID numbers that need to be fixed. They consist of 2 formats: SV0N00555. and SV0I0555. I need to take the 

"N" and "I" out of these. How can I best do that?

[Luke_C]

Hi @ryanmor24 

You can do this with a simple replace formula, assuming N and I will never appear in another part of the field.

replace(replace([Field],"N",''),'I','')

[Elias_Nordlinder · Accepted solution]

Hello @ryanmor24 ,

I think something like this should work, I have attached a workflow as well.

It takes out the first character (S or I) after the first number (0).

- \d{1}([A-Z]{1})

* \d{1} -> One number

* ([A-Z]{1}) -> Thing to replace, one letter after one number

Let me know if you have any more questions 🙂