Help with formula

I need help with the creation of two formulas:

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

Thank you.

Preparation

Accepted answers

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

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

Texting you these answers.

All comments

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

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

Texting you these answers.

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

Example Workflow.yxmd

Thank you Jordan for the assistance.

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703