Converting different string lengths and types into 5 characters

Hi all,

So I have a field that has disparate length sizes and types.

output can look like:

Field 1

313

00016-F

122

00011-L

I would like to convert the field to a 5 character string and also stripping off the last letter. So the output would look like this:

00313

00003

00016

00122

00011

I feel like this would need to be some sort of IIF and Length statement. Thanks for your guys' help.

Preparation

Accepted answers

Try left (padleft([field1],5,"0"),5)

Try left (padleft([field1],5,"0"),5)

Use a Regex tool with:

Regular expression: (\-\l)

Output method: Replace

Case insensitive: on

nothing in replacement text

This will remove the -letter at the end of some of them. Then you just need to use PadLeft([Field], 5, '0') in a formula tool. Example attached.

Good Luck,

MSalvage

Thank you, that was much more straightforward than I thought!