Removing spaces and character

[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

 

[Les]

The MID or REPLACE functions may help you. Do you always
have the same number of spaces?

 

[Guest]

Yes, it is the same number of spaces.

-----Original Message-----
The MID or REPLACE functions may help you. Do you always
have the same number of spaces?

.

 

[Les]

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.

 

[Guest]

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

.