Formula help

[rose1]

Hi there!

I am trying to get this information separated into 4 different columns...

For example, Cat123-456Dog should be separated into 4 columns: "Cat", "123", "456", and "Dog"

Cat123-456Dog

Whale14-32Dolphin

Duck678-21Goose

Tiger44-789Leopard

[Aaron_Harter · Accepted solution]

Hi @rose1, 

You can likely pull out these Fields in one RegEx parse expression, but attached is a sample with the steps broken out a bit more:

 

[DavidP · Accepted solution]

You can do it with a bit of regex

[rose1]

Thank you! This worked!