Strip Characters

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

Am importing data from a text file (daily) that has underscores and dashes
in it (exp: Part --- a34567_____A36___beam). Once I have it imported to a
table, I would like to run an action query that would strip the dashes and
underscores, and just leave on spce in their place (Exp: Part a34567 a36
beam)

Any Ideas?

Terry Schawe
 
Check out the Replace function. It'll do exactly what you want as part of an
Update Query!
 
Thanx - I will try that - but in some cases there are multiple underscores
or dashes togeather that I would want to replace with only one space. I know
how to do this in Excell with the Trim function, but don't see the
equivelant in Access - is there a way to do this?

Terry
 
Never mind. 1) I am blind - trim function is there - 2)Replace function
worked great without it - thanx for the help
 
You're welcome.

--

Ken Snell
<MS ACCESS MVP>

Terry said:
Never mind. 1) I am blind - trim function is there - 2)Replace function
worked great without it - thanx for the help
of to
Click to expand...
 
Back
Top