Page 1 of 1

text to num

Posted: Mon Dec 03, 2018 8:57 pm
by TheRedLord
hello i have text : 1+1 or 2+1 or 2+1 that doesnt matter how i convert him to full answer in numbers?
i mean i have 1+1 in field 1,how i am making field 2 to show 2,and not 1+1?
thank you!

Re: text to num

Posted: Mon Dec 03, 2018 9:29 pm
by Klaus
Hello TheRedLord,

welcome to the forum!

Not sure I understand, but looks like you mean something like:

Code: Select all

...
## fld 1 -> 1+1
put VALUE(fld 1) into fld 2
## fld 2 -> 2
...
Best

Klaus

Re: text to num

Posted: Tue Dec 04, 2018 9:42 am
by TheRedLord
wow! thank you very much! you helped me a lot !!!!!
its exactly how i wanted it!
:D :D :D :) :) :)

Re: text to num

Posted: Tue Dec 04, 2018 5:06 pm
by dunbarx
What you are asking is how to make "1 + 1" evaluate itself.

Klaus has given you the short correct answer.

I would suggest that you change the way that information was entered into the field in the first place. In other words, do not leave such expressions the way you did, rather have the user enter those two numbers, and manage their sum in the program.

Just a suggestion...

Craig Newman