[Download-List] Double Quotes in LITERAL command

[Bright, Frank]

Hi Tuan!!


There is a couple of tricks that you need to do to get output you want.

First you need to set the FORMAT to QUOTE and set the quote character to
null.  Then enclose your LITERAL string with single quotes.

Take a look!!

HTH

Frank
-----------------------

DOWNLOAD PERSON LITERAL '"1"' LAST.NAME SAMPLE FORMAT QUOTE QUOTE.CHAR
""      
DOWNLOAD version 7.02

Using input file PERSON

Output to screen

 

"1",Williams

"1",Williams

"1",Williams

"1",Williams

"1",Williams

"1",Williams

"1",Williams

"1",Williams

"1",Williams

"1",Williams

 

10 records processed.

:                    

_________________________________________
Frank M. Bright                           
fbright at uarts.edu
Administrative Computing               
University of the Arts (A15)
http://www.uarts.edu
215-717-6081(w)
Coll 17.0.14  AIX 5.2.0.4  Uni 6.03



 
 
 
 


-----Original Message-----
From: download-list-bounces at cedarville.edu
[mailto:download-list-bounces at cedarville.edu] On Behalf Of Tuan Vu
Sent: Thursday, March 09, 2006 3:41 PM
To: download-list at cedarville.edu
Subject: [Download-List] Double Quotes in LITERAL command

Greetings folks!

Newbie alert! Run!

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...)

I'm doing a download to for a CBORD process in which one of the fields
require double quotation marks around it.

For example, I need to have a line that reads exactly as below:

!ODYSSEY_HMS, 1, 9, "IDNUMBER"

I've gotten everything else to come through correctly, with the
exception of the double quotation marks.

Thanks in advance for any advice!


Kind regards,

Tuan Vu
Assistant Director for Housing
Pratt Institute

V - 718-399-4550
F - 718-399-4552
E - tuanvu at pratt.edu
W - http://www.pratt.edu/reslife




_______________________________________________
download-list mailing list
download-list at cedarville.edu
http://mail.cedarville.edu/mailman/listinfo/download-list


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20060309/dd815a38/attachment.html>