Replacing characters

[John]

Hi

How can I replace characters like carriage return and double quotes from
strings?

Thanks

Regards

[Randy Harris]

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:41*********************@news-text.dial.pipex.com...

Hi

How can I replace characters like carriage return and double quotes from
strings?

Thanks

Regards

The Replace function will do that.

[MacDermott]

Be careful of using it in a query before A2K2, though.

"Randy Harris" <ra***@SpamFree.com> wrote in message
news:AI*******************@newssvr33.news.prodigy. com...

"John" <Jo**@nospam.infovis.co.uk> wrote in message
news:41*********************@news-text.dial.pipex.com...

Hi

How can I replace characters like carriage return and double quotes from
strings?

Thanks

Regards

The Replace function will do that.

[Thug Passion]

> How can I replace characters like carriage return and double quotes from

strings?

You need to use VB. Like somevalue = replace(somevalue, vbcr, "").
I'm not sure which characters have enums or not, so you can also use
the chr(34) function for example to get a quote. ( Because you can't
say """ )

[almish]

"John" <Jo**@nospam.infovis.co.uk> wrote in message news:<41*********************@news-text.dial.pipex.com>...

How can I replace characters like carriage return and double quotes from
strings?

In Access 2000 and newer use the Replace() function.

Carriage returns can be referenced as vbCr but more likely you want to
deal with Window's CrLf pair so you should use the vbCrLf constant to
remove new line/line breaks:

sUpdatedString = Replace(sSomeString, vbCrlf, "")

here replacing a hex \0x13, \0x10 pair (CR-LF) with an empty string.

'---------------
' John Mishefske
'---------------