<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"
xmlns:ns0="urn:schemas-microsoft-com:office:smarttags" xmlns:ns1="">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>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.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>I really need to get coffee
first before I do this!!<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>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.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><ns0:place><ns0:PlaceName><span
style='color:#990000'>Marc</span></ns0:PlaceName><span style='color:#990000'>
</span><ns0:PlaceName><span style='color:#990000'>Bessler<br>
</span></ns0:PlaceName></ns0:place><ns0:place><ns0:PlaceName><span
style='color:#990000'>Data</span></ns0:PlaceName><span style='color:#990000'>
</span><ns0:PlaceName><span style='color:#990000'>Support</span></ns0:PlaceName><span
style='color:#990000'> </span><ns0:PlaceName><span style='color:#990000'>Specialist</span></ns0:PlaceName><span
style='color:#990000'><br>
</span><ns0:PlaceName><span style='color:#990000'>Phillips</span></ns0:PlaceName><span
style='color:#990000'> </span><ns0:PlaceName><span style='color:#990000'>Exeter</span></ns0:PlaceName><span
style='color:#990000'> </span><ns0:PlaceType><span style='color:#990000'>Academy</span></ns0:PlaceType></ns0:place></span><span
style='color:#1F497D'><br>
</span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:#990000'>20 </span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><ns0:address
ns1:style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"
ns1:tabIndex="0"><ns0:Street><span style='color:#990000'>Main Street</span></ns0:Street><span
style='color:#990000'><br>
</span><ns0:City><span style='color:#990000'>Exeter</span></ns0:City><span
style='color:#990000'>, </span><ns0:State><span style='color:#990000'>NH</span></ns0:State><span
style='color:#990000'> </span><ns0:PostalCode><span style='color:#990000'>03833</span></ns0:PostalCode></ns0:address></span><span
style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><ns0:address
ns1:style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"
ns1:tabIndex="0"><ns0:PostalCode></ns0:PostalCode></ns0:address><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D'>Telephone:
603-777-3367<br>
Fax: 603-777-4382<br>
Email: </span><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'><a href="mailto:mbessler@exeter.edu"
title="mailto:mbessler@exeter.edu"><span style='font-family:"Verdana","sans-serif"'>mbessler@exeter.edu</span></a><br>
</span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif";
color:#1F497D'>Website: </span><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'><a href="http://phillips.exeter.edu/"
title="http://phillips.exeter.edu/"><span style='font-family:"Verdana","sans-serif"'>http://www.exeter.edu/alumni</span></a></span><span
style='color:#1F497D'><o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'> </span><span
style='color:#1F497D'><o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Bessler, Marc <br>
<b>Sent:</b> Monday, May 09, 2011 9:13 AM<br>
<b>To:</b> 'download-list-bounces@cedarville.edu'<br>
<b>Subject:</b> Forcing DEFAULT.VALUE with MV field<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>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.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>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.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Any suggestions on how to get that space in for the rest of
them?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>CA R18 Unidata/Envision<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><ns0:place><ns0:PlaceName><span
style='color:#990000'>Marc</span></ns0:PlaceName><span style='color:#990000'>
</span><ns0:PlaceName><span style='color:#990000'>Bessler<br>
</span></ns0:PlaceName></ns0:place><ns0:place><ns0:PlaceName><span
style='color:#990000'>Data</span></ns0:PlaceName><span style='color:#990000'>
</span><ns0:PlaceName><span style='color:#990000'>Support</span></ns0:PlaceName><span
style='color:#990000'> </span><ns0:PlaceName><span style='color:#990000'>Specialist</span></ns0:PlaceName><span
style='color:#990000'><br>
</span><ns0:PlaceName><span style='color:#990000'>Phillips</span></ns0:PlaceName><span
style='color:#990000'> </span><ns0:PlaceName><span style='color:#990000'>Exeter</span></ns0:PlaceName><span
style='color:#990000'> </span><ns0:PlaceType><span style='color:#990000'>Academy</span></ns0:PlaceType></ns0:place></span><br>
<span style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#990000'>20
</span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'><ns0:address
ns1:style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"
ns1:tabIndex="0"><ns0:Street><span style='color:#990000'>Main Street</span></ns0:Street><span
style='color:#990000'><br>
</span><ns0:City><span style='color:#990000'>Exeter</span></ns0:City><span
style='color:#990000'>, </span><ns0:State><span style='color:#990000'>NH</span></ns0:State><span
style='color:#990000'> </span><ns0:PostalCode><span style='color:#990000'>03833</span></ns0:PostalCode></ns0:address></span><o:p></o:p></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><ns0:address
ns1:style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x"
ns1:tabIndex="0"><ns0:PostalCode></ns0:PostalCode></ns0:address><span
style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Telephone:
603-777-3367<br>
Fax: 603-777-4382<br>
Email: </span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><a
href="mailto:mbessler@exeter.edu" title="mailto:mbessler@exeter.edu"><span
style='font-family:"Verdana","sans-serif"'>mbessler@exeter.edu</span></a><br>
</span><span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Website:
</span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'><a
href="http://phillips.exeter.edu/" title="http://phillips.exeter.edu/"><span
style='font-family:"Verdana","sans-serif"'>http://www.exeter.edu/alumni</span></a></span><o:p></o:p></p>
</div>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>