I'm looking to parse out the original field to look like the new field. Remove the R from each and if there is a . remove that as well so I only see the numbers for example 50204-10763 Original FieldNEW FIELDR50204-1073350204-10733R50204-10733.250204-10733R50204-1076350204-10763R50204-10775.250204-10775

Parse Fields

I'm looking to parse out the original field to look like the new field.

Remove the R from each and if there is a . remove that as well so I only see the numbers for example 50204-10763

Workflow

Developer

Regex

Parse

EDIT:

Now I see you want to remove everything after the dot (.)

LEFT([Original Field], FindString([Original Field], "."))

Cheers,

I would create a formula that does this:

left(
replace([Field1],"R",""),
FindString([Field1], ".")-1)

Basically it removed the R then find the first period/dot and only takes what is on the left of that.

There's a lot of ways to do this.

One of them is this:

Right([Original Field], Length([Original Field]) - 1)

It will remove the first letter (R).

Cheers,

Another one:

Replace([NEW FIELD], "R", "")

Removes any R occurence in your Original Field.

Cheers,

Awesome thanks! How would you remove the . ?

It might not always have only 1 number like .2 it might be .24

I would create a formula that does this:

left(
replace([Field1],"R",""),
FindString([Field1], ".")-1)

Basically it removed the R then find the first period/dot and only takes what is on the left of that.