text extraction

[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

 

[Allen Browne]

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

 

[chico]

THANKS A MILLION

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

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

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

.