[Download-List] Forcing DEFAULT.VALUE with MV field
Bessler, Marc
mbessler at exeter.edu
Mon May 9 09:22:03 EDT 2011
Never mind I got it. Using VALUE.SEPARATOR solved the issue for me. I
had to hard code the pipe from my COMMA.CHAR into the value separator,
but it works.
I really need to get coffee first before I do this!!
P.S. - In case you are wondering why you never saw my initial message, I
sent that to the opt-out address my mistake. More evidence I need
coffee! This is just in case anyone else ever needs this info.
Marc Bessler
Data Support Specialist
Phillips Exeter Academy
20 Main Street
Exeter, NH 03833
Telephone: 603-777-3367
Fax: 603-777-4382
Email: mbessler at exeter.edu <mailto:mbessler at exeter.edu>
Website: http://www.exeter.edu/alumni <http://phillips.exeter.edu/>
From: Bessler, Marc
Sent: Monday, May 09, 2011 9:13 AM
To: 'download-list-bounces at cedarville.edu'
Subject: Forcing DEFAULT.VALUE with MV field
I seem to have hit a wall on something that perhaps someone here could
help with. I have a large DOWNLOAD paragraph with about 140 fields I am
downloading. All except the last are single valued. My file format must
insert a space (not null) for any field without data. Using
DEFAULT.VALUE I can get this for all my single valued elements. However,
I am forcing 9 values on my lat field using NUM.VALUES 9.
My last field is REUNION.CLASS so every record will have at least one
value. Since there is data being returned for at least the first
position of the multi-valued field, the DEFAULT.VALUE statement is not
working.
Any suggestions on how to get that space in for the rest of them?
CA R18 Unidata/Envision
Marc Bessler
Data Support Specialist
Phillips Exeter Academy
20 Main Street
Exeter, NH 03833
Telephone: 603-777-3367
Fax: 603-777-4382
Email: mbessler at exeter.edu <mailto:mbessler at exeter.edu>
Website: http://www.exeter.edu/alumni <http://phillips.exeter.edu/>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20110509/f9e442e8/attachment.html>
More information about the download-list
mailing list