Jump to content
  • 0

Replace numbers with letters


Accountability
 Share

Question

I would like to create a field that is populated with letters that are the result of numbers in other fields. I would like to accomplish the following.

From:

Field 1) Price: $12.50 (will be grabbing intiger only .. disregarding any .50)

Field 2) Percentage: 15%

Field 3) Date: 01/14/2012

Desired Result:

[based on conversion table 1=A, B=2,C=3,D=4,E=5 etc.]

Field 4) AB-AE-AL (AB=12 from field 1, AE = 15 from field 2 and AL = 112 (month/year) from field 3.

I want to get the desired values from fields 1,2,and 3 then convert those values, cancntenate and insert into field 4 (with a "-" between values).

Would appreciate any help. Thanks !

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...