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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Erase SPACE in a string !

Status
Not open for further replies.

desprits

Programmer
Feb 14, 2004
40
CA
What is the function to erase SPACE in a string !

Exemple : MyString = " 2 "
I want : MyString = "2"

Txk!
 
mystring = replace(myString, thingtoReplace,thingToReplaceWith, [optional start])

So

myString = replace(myString," ","")

BB
 
See also Trim, LTrim and RTrim functions

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top