converting numerics

Thu, 2 Sep 2004 09:35:22 -0500

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C490FA.145821A0
Content-Type: text/plain;
	charset="iso-8859-1"

Hi All,

I am writing out data via Quiz extracts. Due to the size of the files we are
using the subfiles versus the textfiles and I noticed that my number formats
are gone in the subfiles. I tried the PICTURE command but it basically
ignores it. So for example, 114.56 looks like +00000011456. When we read
this data into our Progress database, it comes in as 11,456. 

Is the only way to get around this in Quiz to convert the numerics to ASCII
and then physically place the decimal? If so, do I have to check for values
between 0.01 and 0.09 (my 0.01 came across as ". 1") or am I missing
something here? Would it be easier to just use a Progress procedure to
convert the numerics before reading them in? Any input is greatly
appreciated.

Thanks,
-Kristina
Ext. 2459

------_=_NextPart_001_01C490FA.145821A0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">

<meta name=3DProgId content=3DWord.Document>
<meta name=3DGenerator content=3D"Microsoft Word 9">
<meta name=3DOriginator content=3D"Microsoft Word 9">
<link rel=3DFile-List href=3D"cid:filelist.xml@01C490D0.2B767F80">
<!--[if gte mso 9]><xml>
 <o:OfficeDocumentSettings>
  <o:DoNotRelyOnCSS/>
 </o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
 <w:WordDocument>
  <w:View>Normal</w:View>
  <w:Zoom>0</w:Zoom>
  <w:DocumentKind>DocumentEmail</w:DocumentKind>
  <w:EnvelopeVis/>
  <w:DrawingGridHorizontalSpacing>2.85 =
pt</w:DrawingGridHorizontalSpacing>
  =
<w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery>=

 </w:WordDocument>
</xml><![endif]-->
<style>
<!--
 /* Font Definitions */
@font-face
	{font-family:"Century Gothic";
	panose-1:2 11 5 2 2 2 2 2 2 4;
	mso-font-charset:0;
	mso-generic-font-family:swiss;
	mso-font-pitch:variable;
	mso-font-signature:647 0 0 0 159 0;}
 /* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{mso-style-parent:"";
	margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:9.0pt;
	mso-bidi-font-size:12.0pt;
	font-family:"Century Gothic";
	mso-fareast-font-family:"Times New Roman";
	mso-bidi-font-family:"Courier New";}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
	{margin:0in;
	margin-bottom:.0001pt;
	mso-pagination:widow-orphan;
	font-size:9.0pt;
	mso-bidi-font-size:12.0pt;
	font-family:"Century Gothic";
	mso-fareast-font-family:"Times New Roman";
	mso-bidi-font-family:"Courier New";}
span.EmailStyle15
	{mso-style-type:personal-compose;
	mso-ansi-font-size:10.0pt;
	mso-ascii-font-family:"Century Gothic";
	mso-hansi-font-family:"Century Gothic";
	mso-bidi-font-family:Arial;
	color:#333399;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.0in 1.0in 1.0in;
	mso-header-margin:.5in;
	mso-footer-margin:.5in;
	mso-paper-source:0;}
div.Section1
	{page:Section1;}
-->
</style>
</head>

<body lang=3DEN-US style=3D'tab-interval:.5in'>

<div class=3DSection1>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'>Hi
All,<o:p></o:p></span></font></span></p>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>=

I
am writing out data via Quiz extracts. Due to the size of the files we =
are
using the subfiles versus the textfiles and I noticed that my number =
formats
are gone in the subfiles. I tried the PICTURE command but it basically =
ignores
it. So for example, 114.56 looks like +00000011456. When we read this =
data into
our Progress database, it comes in as 11,456. =
<o:p></o:p>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>=

Is
the only way to get around this in Quiz to convert the numerics to =
ASCII and
then physically place the decimal? If so, do I have to check for values =
between
0.01 and 0.09 (my 0.01 came across as &#8220;. 1&#8221;) or am I =
missing something here?
Would it be easier to just use a Progress procedure to convert the =
numerics
before reading them in? Any input is greatly =
appreciated.<o:p></o:p>

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'><![if =
!supportEmptyParas]>&nbsp;<![endif]><o:p></o:p></span></font></span></p>=

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'>Thanks,<o:p></o:p><=
/span></font></span></p>

<p class=3DMsoNormal><!--[if supportFields]><font =
color=3D"#333399"><span=20
style=3D'color:#333399'><span =
style=3D'mso-element:field-begin'></span><span=20
style=3D"mso-spacerun: yes">&nbsp;</span>AUTOTEXTLIST \s &quot;E-mail=20
Signature&quot; <span =
style=3D'mso-element:field-separator'></span></span></font><![endif]--><=
span
class=3DEmailStyle15><font size=3D2 color=3D"#333399"><span =
style=3D'font-size:10.0pt;
mso-bidi-font-size:12.0pt'>-Kristina<o:p></o:p></span></font></span></p>=

<p class=3DMsoNormal><span class=3DEmailStyle15><font size=3D2 =
color=3D"#333399"
face=3D"Century Gothic"><span =
style=3D'font-size:10.0pt;mso-bidi-font-size:12.0pt'>Ext.
2459</span></font></span><font color=3D"#333399"><span =
style=3D'color:#333399;
mso-color-alt:windowtext'><o:p></o:p></span></font></p>

<p class=3DMsoNormal><!--[if supportFields]><font =
color=3D"#333399"><span=20
style=3D'color:#333399'><span =
style=3D'mso-element:field-end'></span></span></font><![endif]--><font
color=3D"#333399"><span style=3D'color:#333399'><![if =
!supportEmptyParas]>&nbsp;<![endif]></span></font><font
color=3D"#333399"><span =
style=3D'color:#333399;mso-color-alt:windowtext'><o:p></o:p></span></fon=
t></p>

</div>

</body>

</html>

------_=_NextPart_001_01C490FA.145821A0--