Removing the Last Character in a Field

[aj3221]

Good morning!

I have a string field where the data can vary in length & I need to remove the last character of the field.

Example:

table.field value is currently 12548798

I need to return in my formula: 1254879

Thank you in advance for any assistance!

 

[Charliy]

create a formula:

left({yourfield},length({yourfield})-1)

 

[aj3221]

You rock! Thanks!

 

[aj3221]

I have another field where I have to get rid of the first 3 characters?

BAY4895

and I need 4895.

 

[aj3221]

I thought I had it with:

Right({arss.route}, 5)

But there are spaces in the field so it varies.

The field can be up to 7 characters. But there are spaces and / or dead spots.

MW WF TH

I would like to grab the WF TH of this string.

Sometimes it could be:

MW WF R

I think maybe mid would work. I want to grab positions 4-7.

 

[aj3221]

Mid worked. I walked myself right through that one