Help with a formula

[Danny_L]

Hello all,

I'm trying to come up with a formula that will do the following:

Look at DataCardValue9.Text field and if it contains an = sign, display everything before the = sign.

Example: 123456=01 should come back as 123456 only.

The = sign is always followed up by 2 digit number so it's always going to be the last 3 characters of the string.

Any thoughts? 

[timl · Accepted solution]

Hi @Danny_L 

This should hopefully work for you:

First(Split(DataCardValue9.Text,"=")).Result

[Danny_L]

That did it. Thanks!