[Download-List] download

[Bright, Frank]

Hi Pat,

I saw your email.  To add a null value as a field, you could use the
LITERAL feature.  It places whatever is in the quotes in that place of
the record.  For example....

DOWNLOAD PERSON FORMAT QUOTE LITERAL "Current Project" LAST.NAME
FIRST.NAME LITERAL "" MIDDLE.NAME

This would download records from the PERSON file.  The first LITERAL
stores the tag 'Current Project'	in the first field and the
second LITERAL store a null in the fifth field.

To remove the quotes, I think you want to download the records in the
COMMA format.  This does not add quotes around the literal text.  

DOWNLOAD PERSON FORMAT COMMA LITERAL "Current Project" LAST.NAME
FIRST.NAME LITERAL "" MIDDLE.NAME

HTH


Frank




_________________________________________
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 Minatra, Pat
Sent: Tuesday, March 07, 2006 2:16 PM
To: download-list at cedarville.edu
Subject: [Download-List] download

I have two situations in which I need a little nudge:

1)  I need to download basically a null field into a comma delimited
file (i.e. xxx,,,xxx)) where the information between the commas is null,
has no value.  I do not know how to build my idescriptor to do this.

2)  Also, when downloading to a comma delimited file, I remember
something about being able to remove the quotes but I can't find that
reference.  Can anyone help with that.

Thanks for any help and have a GREAT day!


-------------------------
"Life is but a twinkle in the eye of eternity"
"The shortest distance between a problem and a solution is the distance
between your knees and the floor"
"sorrow looks back - worry looks around - faith looks up"
Regards,
Pat H. Minatra - N5GJR
(325) 670-5804 voice
(325) 670-1570 fax
Hardin*Simmons University
www.hsutx.edu
PO BOX 16040
Abilene, TX  79698

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