Removing double quotes from string

  • Thread starter Thread starter Treebeard
  • Start date Start date
T

Treebeard

I imported a string and it looks like this when I display it via MsgBox:

AAAABBBB"CCCCDDD"KJH

I would like to remove the double quotes from it so it looks like:

AAAABBBBCCCCDDDKJH

The double quotes won't always show up at the same location every time. I
tried the Replace function to no avail. It will let me replace every
character except double quotes.

Jack
 
You can search for the double-quotes using the Character code:

Replace([MyField], Chr(34), "")


hth,
 
Back
Top