Help with quotes

[anotherfmnewbie]

I have a field that contains text.. Here is an example:

[color:red]CONCEPTRONIC Discovery Mark VII Forced Convection SMD Reflow Soldering System

Electrical: 480 VAC 3 Phase

Dimensions: 53” wide x 172” long x 51” tall

Shipping weight 2,500 lbs

Included are operation and service manual, wiring diagrams, schematics and drawings.

This text can be used by users when searching the database, but I see that a query will fail as a result of the quotes used in the dimension description. My question is: How can I comment out those quotes without using the Quote () function? Substitute () doesn't seem to work either. The issue is that I can't have the entire query turned into a string by wrapping everything in quotes. Any thoughts.

The result I am looking for is this:

[color:red]CONCEPTRONIC Discovery Mark VII Forced Convection SMD Reflow Soldering System

Electrical: 480 VAC 3 Phase

Dimensions: 53” wide x 172” long x 51” tall

Shipping weight 2,500 lbs

Included are operation and service manual, wiring diagrams, schematics and drawings.

TIA!!

[comment]

Substitute () doesn't seem to work either.

Why not?

Substitute ( YourField ; """ ; """ )

should work fine. Note that if you are using smart quotes (as you seem to be), you need to add some more substitutions to catch those as well.

[anotherfmnewbie]

That worked perfectly!! Thanks!