• 0

# Replace numbers with letters

## 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 !

## Recommended Posts

• 0

I think this need to add JavaScript code.

##### Share on other sites

• 0

Hi - just an update. You may now use Calculated Value in this kind of workflow. If you want to change the numerical value to a corresponding letter, you can use this formula:

```REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
REPLACE([@field:FIELDNAME_NUMBER], '1', 'A')
, '2', 'B')
, '3', 'C')
, '4', 'D')
, '5', 'E')
, '6', 'F')
, '7', 'G')
, '8', 'H')
, '9', 'I')
, '10', 'J')```

For example, if you have 123.45 the result will be ABC.DE

## 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.

×   Pasted as rich text.   Paste as plain text instead

Only 75 emoji are allowed.