<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Embedded Quotation Marks</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3020" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><FONT face=Tahoma color=#0000ff><SPAN
class=684251316-08022007>OK, everyone here's the solution.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Tahoma color=#0000ff><SPAN
class=684251316-08022007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Tahoma color=#0000ff><SPAN
class=684251316-08022007>Several people said you need a double
quote.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Tahoma color=#0000ff><SPAN
class=684251316-08022007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Tahoma color=#0000ff><SPAN
class=684251316-08022007>This is true, but if you are starting your string
literal with a " mark, you actually need a triple quote!!! E.g.,
"""</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Tahoma color=#0000ff><SPAN
class=684251316-08022007>So I found the following would work (assume that LAT_SS
= 23.345.</SPAN></FONT></DIV>
<DIV dir=ltr align=left><FONT face=Tahoma color=#0000ff><SPAN
class=684251316-08022007></SPAN></FONT> </DIV>
<DIV dir=ltr align=left><FONT face=Tahoma color=#0000ff><SPAN
class=684251316-08022007>LAT_SS & """ N"</SPAN></FONT></DIV>
<DIV><FONT face=Tahoma color=#0000ff></FONT> </DIV>
<DIV><SPAN class=684251316-08022007><FONT face=Tahoma color=#0000ff>Displays
correctly as:</FONT></SPAN></DIV>
<DIV><SPAN class=684251316-08022007><FONT face=Tahoma
color=#0000ff></FONT></SPAN> </DIV>
<DIV><SPAN class=684251316-08022007><FONT face=Tahoma color=#0000ff>23.345"
N</FONT></SPAN></DIV>
<DIV><FONT face=Tahoma color=#0000ff></FONT> </DIV>
<DIV><SPAN class=684251316-08022007><FONT face=Tahoma color=#0000ff>Thanks, it
was the third " mark that threw me off.</FONT></SPAN></DIV><!-- Converted from text/rtf format -->
<P><B><SPAN lang=en-us><FONT face="Brush Script MT" size=6>--
John</FONT></SPAN></B><SPAN lang=en-us></SPAN> </P>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> shrug-l-bounces@lists.dep.state.fl.us
[mailto:shrug-l-bounces@lists.dep.state.fl.us] <B>On Behalf Of </B>Sykes,
John<BR><B>Sent:</B> Thursday, February 08, 2007 10:13 AM<BR><B>To:</B>
shrug-L@lists.dep.state.fl.us<BR><B>Subject:</B> shrug-l: Embedded Quotation
Marks<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Tahoma>Here's a little bug that bothers me.</FONT> </P>
<P><FONT face=Tahoma>In most languages, there is a way to embed special
characters in a string literal.</FONT> </P>
<P><FONT face=Tahoma>So that, for example if $ has a meaning to a language, you
might use %$ in a literal to tell the language to embed the $ sign in the
literal and not run the $ function (whatever it may be). In this example,
a %% would tell the parser that the literal contains a percent sign.</FONT></P>
<P><FONT face=Tahoma>I have not been able to find a similar feature in the VB
scripting language (I've tried a bunch of the "usual" special characters, but
none seem to work). So in a literal (which starts and ends with a " sign)
if you want to include the " sign as part of the literal, there is no way to
tell VB that " is a symbol and not the end of the string. I have
temporarily gotten around this by using two ' signs in my literals (e.g., for
degrees, minutes and seconds of lat/long) but there has to be a better
solution.</FONT></P>
<P><FONT face=Tahoma>I looked through the VB 6.0 manuals and could not find such
a solution, however.</FONT> </P>
<P><FONT face=Tahoma>Any thoughts?</FONT> </P>
<P><B><FONT face="Brush Script MT" size=6>-- John</FONT></B> </P></BODY></HTML>