Removing Spaces and character in a text string

  • Thread starter Thread starter Bookmdano
  • Start date Start date
B

Bookmdano

I have a text string that represent "Account Number". The current format is
1 -0 -32 -61234-1220?

I want the "Account Number" to read 1-0-32-61234-1220

I know I should use an update query but what I have tried so far doesn't
work.

Thanks
 
You are the man! Thanks

Clifford Bass said:
Hi,

Use the Replace() function:

Replace([Account Number], " ", "")

Clifford Bass

Bookmdano said:
I have a text string that represent "Account Number". The current format is
1 -0 -32 -61234-1220?

I want the "Account Number" to read 1-0-32-61234-1220

I know I should use an update query but what I have tried so far doesn't
work.

Thanks
Click to expand...
Click to expand...
 
I have a text string that represent "Account Number". The current format is
1 -0 -32 -61234-1220?

I want the "Account Number" to read 1-0-32-61234-1220

I know I should use an update query but what I have tried so far doesn't
work.

Thanks
Click to expand...

Run an Update query. Select the Account Number field; on the Criteria line put

LIKE "* *"

to restrict the update to those records that have blanks, and put

Replace([Account Number], " ", "")

on the Update To line. This will replace each blank by an empty string.
 
Hi,

You are welcome. John's advice is good should you need to repeat the
process--no need to update rows that are already fixed.

Clifford Bass
 
Back
Top