text extraction

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
 
A

Allen Browne

Use the Replace() function to replace space with nothing.
Replace([MyField], " " , "")
 
C

chico

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...
 
Top