Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Remove unwanted characters

Status
Not open for further replies.
bdm1

bdm1

Programmer
Feb 4, 2002
75
0
0
US
I have inherited an access table that needs cleaning.
the Document Name field contains unwanted characters that I need to get rid of. This is what it looks like now: IRT%20INTERIOR%20TRIM.pdf

What I need to do is remove all instances of %20. Is there a routine that will accomplishe this? I would hate to have to go through each record and manually change things. Thanks much
 
Sort by date Sort by votes
Take a look at the Replace function:
Replace([Document Name], "%20", " ")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Remove everything including the comma from the last comma of a string. 1
Replies
10
Views
182
Andrzejek
Andrzejek
irethedo
  • Locked
  • Question
Removing one of two of the leading characters in a table field 2
Replies
7
Views
59
irethedo
irethedo
aliendan
  • Locked
  • Question
Limited number of characters per line of code problem
Replies
8
Views
39
combo
combo
airwolf09
  • Locked
  • Question
csv file breaking after numeric characters and special characters
Replies
1
Views
37
SkipVought
S
air1access
  • Locked
  • Question
Remove unwanted contents of string 1
Replies
13
Views
32
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top