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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Find and replace a character in a query 1
- Thread starter ovie52
- Start date
-
1
- #2
tomschafer
Technical User
Paste this function into a module and call it in the query like so... The example replaces "/" with "*"
select
ReplaceCharacter(FieldName, "/", "*"
from
TableName
Function ReplaceCharacter(strData As String, strFind As String, strReplace As String) As String
While InStr(strData, strFind) > 0
Mid(strData, InStr(strData, strFind)) = strReplace
Wend
ReplaceCharacter = strData
End Function
select
ReplaceCharacter(FieldName, "/", "*"
from
TableName
Function ReplaceCharacter(strData As String, strFind As String, strReplace As String) As String
While InStr(strData, strFind) > 0
Mid(strData, InStr(strData, strFind)) = strReplace
Wend
ReplaceCharacter = strData
End Function
- Status
Similar threads
- Locked
- Question
- Question
