asked on November 12, 2019
Hi all,
In my form, I'm using a lookup table to load informations.
In my Database, the field "price" is a string (don't ask me why) e.g : "23 627" (with espace between 23 and 627).
In my Form, the field "price" is a number.
So when I'm loading the information, I get an error because of type.
My question is : how can I delete the espace to get a number ?
E.G : "23 627" to "23627"
I tried the fonction SUBSTITUTE but it doesn't wokr.
=SUBSTITUTE(PU.HT," ","")
0
0