Removing spaces and character

  • Thread starter Thread starter Lou
  • Start date Start date
L

Lou

I have data that has _,* and spaces before the frist
charater and I want to remove them. Can someone tell me
how to make a query that can delete these charaters and
spaces.
TIA
 
Okay,
I'm going to pretend that you have _,* and 3 spaces.
So you want to start pulling your field from position 7.
(Skip 3 characters and 3 spaces).

Create a new query, and create a new field in your query:

Newfld:MID([yourfld], 7, LEN([yourfld]) - 6)

The MID function wants to know what field to use
(yourfld), what position to start in (7, explained above),
and for how many positions (length of your original field,
minus the 6 characters that were skipped).

The LEN function just tells you how long your field is in
characters.

Hope this helps.
 
Les,
It works great!
Thanks you..
-----Original Message-----
Okay,
I'm going to pretend that you have _,* and 3 spaces.
So you want to start pulling your field from position 7.
(Skip 3 characters and 3 spaces).

Create a new query, and create a new field in your query:

Newfld:MID([yourfld], 7, LEN([yourfld]) - 6)

The MID function wants to know what field to use
(yourfld), what position to start in (7, explained above),
and for how many positions (length of your original field,
minus the 6 characters that were skipped).

The LEN function just tells you how long your field is in
characters.

Hope this helps.

-----Original Message-----
Yes, it is the same number of spaces.
.
Click to expand...
.
Click to expand...
 
Back
Top