Jump to content

Serial Number to Alpha


This topic is 5764 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I need to convert a serial number (01,02,03...) to an Alpha? i.e. 01=A, 02=B,...10=J,...26=Z. I have a portal set up which creates new line items for a specific Job# (related by Job#). I have a couple of calculation fields in the related file that give each related entry a unique serial number (-001, -002,...).

In my master file I want a "Line Item" field. It is simple enough to have a calculation using the Right function to get a serial (01,02etc) and I can convert this to Alpha using a longwinded Case statement. Is there a simpler way of achieving this

Link to comment
Share on other sites

I'll add to this by saying that if you are us the US version of 6, you need to change the ; to , (semicolons to commas).

Choose(

Right(Number,3) , "" ,

"A",

"B",

"C",

"D",

"E",

"F",

"G",

"H",

"I",

"J",

"K",

"L",

"M",

// and so on....

"Y",

"Z")

Link to comment
Share on other sites

Hi bigchiefs,

I think I'd cheat ... I'd use a global text or a single text field in Preference (field called TEXT) to hold the values (in multiline) as:

A

B

C ... Then the calc (serial would be your serial field) would simply be:

MiddleValues ( TEXT; serial ; 1)

The line count becomes the result. You could even hit AA BB etc if you wished. Your 'calculation' then wouldn't be limited to your field definition ... certain personnel could add the letters at the bottom and it'd stretch forever for you, handled in Browse mode. :wink2:

Ooops - you are vs. 6. You would need to use: MiddleWords( TEXT, serial, 1)

LaRetta

Edited by Guest
Added calc for vs. 6
Link to comment
Share on other sites

This topic is 5764 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.