Removing double quotes from string

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
 
C

Cheryl Fischer

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

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


hth,
 
Top