<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY><!-- Converted from text/plain format -->
<P dir=ltr style="MARGIN-RIGHT: 0px">Hi Tuan!!<BR><BR><BR>There is a couple of
tricks that you need to do to get output you want.<BR><BR>First you need to set
the FORMAT to QUOTE and set the quote character to null. Then enclose your
LITERAL string with single quotes.<BR><BR>Take a
look!!<BR><BR>HTH<BR><BR>Frank<BR><FONT
size=2>-----------------------</FONT></P><FONT size=2>
<P dir=ltr style="MARGIN-RIGHT: 0px"><FONT face="Courier New">DOWNLOAD PERSON
LITERAL '"1"' LAST.NAME SAMPLE FORMAT QUOTE QUOTE.CHAR
"" <BR>DOWNLOAD version
7.02 <BR>Using
input file
PERSON <BR>Output
to
screen <BR> <BR>"1",Williams <BR>"1",Williams <BR>"1",Williams <BR>"1",Williams <BR>"1",Williams <BR>"1",Williams <BR>"1",Williams <BR>"1",Williams <BR>"1",Williams <BR>"1",Williams <BR> <BR>10
records
processed. <BR></FONT>: <BR><BR>_________________________________________<BR>Frank
M.
Bright <BR>fbright@uarts.edu<BR>Administrative
Computing <BR>University
of the Arts (A15)<BR><A
href="http://www.uarts.edu">http://www.uarts.edu</A><BR>215-717-6081(w)<BR>Coll
17.0.14 AIX 5.2.0.4 Uni 6.03<BR><BR></P>
<DIV><FONT face=Arial color=#0000ff></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff></FONT> </DIV>
<P dir=ltr style="MARGIN-RIGHT: 0px"><BR>-----Original Message-----<BR>From:
download-list-bounces@cedarville.edu [<A
href="mailto:download-list-bounces@cedarville.edu">mailto:download-list-bounces@cedarville.edu</A>]
On Behalf Of Tuan Vu<BR>Sent: Thursday, March 09, 2006 3:41 PM<BR>To:
download-list@cedarville.edu<BR>Subject: [Download-List] Double Quotes in
LITERAL command<BR><BR>Greetings folks!<BR><BR>Newbie alert! Run!<BR><BR>How
does one get the LITERAL command to insert a double quotation mark around some
text? (since the LITERAL command already uses double quotation marks to
delineate the character string...)<BR><BR>I'm doing a download to for a CBORD
process in which one of the fields require double quotation marks around
it.<BR><BR>For example, I need to have a line that reads exactly as
below:<BR><BR>!ODYSSEY_HMS, 1, 9, "IDNUMBER"<BR><BR>I've gotten everything else
to come through correctly, with the exception of the double quotation
marks.<BR><BR>Thanks in advance for any advice!<BR><BR><BR>Kind
regards,<BR><BR>Tuan Vu<BR>Assistant Director for Housing<BR>Pratt
Institute<BR><BR>V - 718-399-4550<BR>F - 718-399-4552<BR>E -
tuanvu@pratt.edu<BR>W - <A
href="http://www.pratt.edu/reslife">http://www.pratt.edu/reslife</A><BR><BR><BR><BR><BR>_______________________________________________<BR>download-list
mailing list<BR>download-list@cedarville.edu<BR><A
href="http://mail.cedarville.edu/mailman/listinfo/download-list">http://mail.cedarville.edu/mailman/listinfo/download-list</A><BR></P></FONT></BODY></HTML>