Converting different string lengths and types into 5 characters

[whitkrieng]

Hi all,

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

output can look like: 

Field 1

313

3

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.   

[patrick_digan · Accepted solution]

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

[MSalvage]

@wkrieng1, 

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

[whitkrieng]

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