Home » Developer & Programmer » Forms » remove spaces from string
remove spaces from string [message #81074] Fri, 03 January 2003 08:29 Go to next message
Tyler
Messages: 123
Registered: January 2002
Senior Member
I have a phone number in a text field that I am doing a validation on, I want to make sure that with no spaces, the number is only 10 characters long... anyone know how to remove the spaces. TRIM removes leading and trailing spaces, how do I remove the ones inside the string??

Thanks,
T
Re: remove spaces from string [message #81075 is a reply to message #81074] Fri, 03 January 2003 09:44 Go to previous message
shiva
Messages: 38
Registered: March 2001
Member
Use the replace function:

For example:
select replace('Now I know ',' ') from dual;

returns:
NowIknow
Previous Topic: "autorefresh"
Next Topic: Forms 3.0 to 4.5 conversion
Goto Forum:
  


Current Time: Thu Mar 28 10:17:01 CDT 2024