String

C

Craig

Really what I want to do is create a function that takes a
string and replaces characters with other characters.
For instance...

turns: N-45/2*3
into: N4523

in other words, it substitues Null for all the funky
characters

i want to write a function i can call within a query. any
help would be appreciated. someone already said
the "regex" function, but I don't know the sytax
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace, but ignore certain characters 4
String centering 2
function to replace multiple characters.. 3
VBA - exporting serial letters to single documents 0
Replace data to right of string problem 6
find and replace numeric strings in larger text strings 8
decimal to string 2
Garbage in a string variable loaded from a field 2

Top