hi all, I don't this software can done this idea of not.

my idea is like below:

1=N,2=L,3=K,4=P,5=R,6=O,7=D,8=U,9=C,0=T

Now I want to convert my price field to text field. How I relationship all this think?

When the price field is 20.00 mean 2=L,0=T,0=T,0=T, so the text field show me LTTT

any idea? hope your all understand my issue....thank for reply!

Hi, Questions King!

Hi tried substitute function, and it works.

Near such:

Substitute(Substitute(Price,"1",,"N"),"2","L")..... and so far.

May be there is more easy way...

in fm7 & 8 we no longer need to "nest" substitute functions within itself, so we reformat aaa's calc to be:

Substitute(Price;

[ "1" ; "N" ] ;

[ "2" ; "L" ] ;

[ "3" ; "K" ] ;

)

and also the seperating character is a semi-colon not a coma aaa.

~genx

Very thank all.....there is the solution I want!!!

Thank you ll

hahaha....to fast to happy, ok now my problem is when my price is 20.00 should be L(2)T(0)T(0)T(0) and now only show two number L(2)T(0)??

any idea?

Substitute (

Price * 100 ;

[ "1" ; "N" ] ;

[ "2" ; "L" ] ;

...

Thank!!!!