Removing double quotes from string

[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

 

[Cheryl Fischer]

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

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


hth,

 

[Treebeard]

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

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