PDA

View Full Version : Striping out the " signs?



Amadeus23
December 29th, 2009, 02:12 PM
Is there a way to use the strip Function to remove the " signs?

For example, to remove a dash, it would look like:

Strip(Name,"-")

But, when removing a quote character, this does not work"

Strip(Name,""")

Any ideas?

Thanks

Data Kruncher
December 29th, 2009, 03:49 PM
To specify a single double quote character " use:

Strip(Name,Chr(34))

where the ASCII value of " is 34.

Kruncher