text extraction

  • Thread starter Thread starter chico
  • Start date Start date
C

chico

extract a unwanted space out of a string

example return
120 -0-01-01 120-0-01-01
130 -0-01-01 130-0-01-01
140 -0-01-01 140-0-01-01
150 -0-01-01 150-0-01-01
 
Use the Replace() function to replace space with nothing.
Replace([MyField], " " , "")
 
THANKS A MILLION
-----Original Message-----
Use the Replace() function to replace space with nothing.
Replace([MyField], " " , "")

--
Allen Browne - Microsoft MVP. Perth, Western Australia.


chico said:
extract a unwanted space out of a string

example return
120 -0-01-01 120-0-01-01
130 -0-01-01 130-0-01-01
140 -0-01-01 140-0-01-01
150 -0-01-01 150-0-01-01
Click to expand...


.
Click to expand...
 
Back
Top