Help with formula

[sbb]

I need help with the creation of two formulas:

1. I need to convert a string value that says "Mid-Atlantic" to "MA"
2. I need to remove the dashes from a SSN (e.g., xxx-xx-xxxx converted to xxxxxxxxx)

Thank you.

[MarqueeCrew · Accepted solution]

2. Replace([string],"-",'')

1. Regex_replace([string],"[^A-Z]",'')

Texting you these answers.

[JordanB]

Hi sbb,

I have attached a workflow which shows the function I used. 

I used the Replace and RegEx replace functions. 

Best,

Jordan Barker

Client Service Support Engineer

[sbb]

Thank you Jordan for the assistance.