Add a double quote to a string

Posted February 7th, 2010 by wbayne333

I need to build strings which will look like this:

The 2 url strings are from data fields. I need to bring them together and build links. The double quote is used by your program as a qualifier (is that the right term?) However I need to actually have a double quote included in my strings.

How do I do that? I looked at all of the concatenated examples but didn't see one for this.

Goldmine Email Field ›

RE: Add a double quote to a string

On February 8th, 2010 jterrell said:

Hi wbayne333,

You can add virtually any "constant" to a text string...as long as the target application or database allows the constant.

The easiest way to add a constant to a text string is to use the concatenation operator (&) as in this simple example: Fields("SourceField1") & "constant"

Refer to the help topic entitled "Literal Values in Expressions" in the product documentation for details.

However, when the constant is a special character (anything except alpha and numeric characters or a space), you will need to use the Chr Function, as in this example:
Fields("SourceField1") & Chr(34)
...where Chr(34) will insert a quotation mark immediately after the data field value.

Refer to the Chr Function help topic for details about how to use that function AND for a link to a reference table of hex and decimal values.

- Jo

issue with character

On February 8th, 2010 wbayne333 said:

Thanks Jo for your reply.

I've added this to the program:
"

RE: issue with character

On February 8th, 2010 jterrell said:

Glad you got it to work!

- Jo