filemaker convert number 1234567890 in a word abcdefghil or so..

Scripting Forums AppleScript | Mac OS X
#1

hi everybody,
anybody knows how to automatically convert a number field with a specific number, in a text fiel with a word in result:

4 examples :
if i decide that 1 became A
if i decide that 2 became B
if i decide that 3 became C
if i decide that 4 became D
if i decide that 5 became E
if i decide that 6 became F
if i decide that 7 became G
if i decide that 8 became H
if i decide that 9 became L
if i decide that 0 became M

so if my number in a field is “145000”
i will ave a word in result in another field of “ADEMMM”

so 137421 will became ACGDBA and so and so…,

thx,dave

#2

You can adaptate something as this:

set table1 to "0123456789"
set table2 to "MABCDEFGHL"

set theNum to 54487
set theNum to theNum as text --> "54487"

set output to ""

repeat with i from 1 to count theNum
	set output to output & ¬
		(item (offset of theNum's item i in table1) of table2)
end repeat

output --> "EDDHG"