Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

replace function

Status
Not open for further replies.

LimonaM

Programmer
Joined
Oct 27, 2004
Messages
50
Location
SI
Hello.

How must i use function replace so i can in one item in my form replace ',' with '.' ?

Users are writeing nubmers and some write ',' and some '.' It has to be '.'

Now i want that every time someone write ',' it would be replaced by '.'. Help please

Thanks
 
use the following built-in:

translate(item_name , ',' , '.')
 
replace(item_name , ',' , '.')
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top