Parse Fields

[ashleyinman]

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 Field	NEW FIELD
R50204-10733	50204-10733
R50204-10733.2	50204-10733
R50204-10763	50204-10763
R50204-10775.2	50204-10775

[Thableaus]

Hi @ashleyinman 

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,

[Thableaus]

@ashleyinman 

Another one:

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

Removes any R occurence in your Original Field.

Cheers,

[ashleyinman]

Awesome thanks! How would you remove the . ? 

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

[Thableaus · Accepted solution]

@ashleyinman 

EDIT:

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

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

Cheers,

[cmcclellan · Accepted solution]

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.