<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2900.2802" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=453512120-15122005><FONT face=Arial color=#0000ff
size=2>Fernando, what machine platform are you running on?</FONT></SPAN></DIV>
<DIV><SPAN class=453512120-15122005><FONT face=Arial color=#0000ff size=2>I have
tools that will strip out comma's and quotes from any CSV
file.</FONT></SPAN></DIV>
<DIV><SPAN class=453512120-15122005><FONT face=Arial color=#0000ff size=2>If
this is what you are looking for let me know.</FONT></SPAN></DIV>
<DIV><SPAN class=453512120-15122005><FONT face=Arial color=#0000ff
size=2>Ken</FONT></SPAN></DIV>
<DIV><SPAN class=453512120-15122005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com] <B>On
Behalf Of </B>Latimer, Richard<BR><B>Sent:</B> December 15, 2005 2:53
PM<BR><B>To:</B> fernando.olmos@hpa.com.au;
powerh-l@lists.sowder.com<BR><B>Subject:</B> [Bulk] RE: Nifty function
required<BR><BR></FONT></DIV>
<DIV dir=ltr align=left><SPAN class=604354619-15122005><FONT face=Tahoma
color=#0000ff size=2>Fernando,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=604354619-15122005><FONT face=Tahoma
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=604354619-15122005><FONT face=Tahoma
color=#0000ff size=2>If you are prepared to fool with your dictionary (and I'm
not that brave so have tested with the default '¬' character) try
this:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=604354619-15122005><FONT face=Tahoma
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=604354619-15122005><FONT face=Tahoma
color=#0000ff size=2>Redefine the substitution character to be a comma
</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=604354619-15122005><FONT face=Tahoma
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=604354619-15122005><FONT face=Tahoma
color=#0000ff size=2>then use the substitute function as below
</FONT></SPAN><SPAN class=604354619-15122005><FONT face=Tahoma color=#0000ff
size=2></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=604354619-15122005><FONT face=Tahoma
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=604354619-15122005><FONT face=Tahoma
color=#0000ff size=2>acc
flight_data
<BR>def test1 char*10 =
"1¬234¬567"
<BR>def test2 char*10 = substitute(test1,"","","") <BR>def
test6 num*10 =
nconvert(test2)
<BR>rep test1 test2
test6 <BR></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=604354619-15122005><FONT face=Tahoma
color=#0000ff size=2> </DIV></FONT></SPAN>
<DIV dir=ltr align=left><SPAN class=604354619-15122005><FONT face=Tahoma
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=604354619-15122005><FONT face=Tahoma
color=#0000ff size=2> TEST1
TEST2
TEST6
<BR>
<BR> 1¬234¬567
1234567 1234567
<BR> 1¬234¬567
1234567 1234567
<BR> 1¬234¬567
1234567
1234567 </FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=604354619-15122005><FONT face=Tahoma
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=604354619-15122005><FONT face=Tahoma
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=604354619-15122005><FONT face=Tahoma
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=604354619-15122005><FONT face=Tahoma
color=#0000ff size=2>good luck !!</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=604354619-15122005><FONT face=Tahoma
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=604354619-15122005><FONT face=Tahoma
color=#0000ff size=2>regards</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=604354619-15122005></SPAN><SPAN
class=604354619-15122005><FONT face=Tahoma color=#0000ff size=2><SPAN
lang=en-us><FONT face=Arial>Richard Latimer</FONT></SPAN> <BR><SPAN
lang=en-us><I><FONT face=Arial size=2>MIS Manager</FONT></I></SPAN> <BR><SPAN
lang=en-us><I><FONT face=Arial size=2>Airways New
Zealand</FONT></I></SPAN> <BR></DIV>
<DIV dir=ltr
align=left>
</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
powerh-l-bounces+richard.latimer=airways.co.nz@lists.sowder.com
[mailto:powerh-l-bounces+richard.latimer=airways.co.nz@lists.sowder.com] <B>On
Behalf Of </B>fernando.olmos@hpa.com.au<BR><B>Sent:</B> Thursday, 15 December
2005 7:01 p.m.<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> Nifty
function required<BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>Hi gang,</FONT> </P>
<P><FONT face=Arial size=2>To save me re-inventing the wheel (and I won't take
the credit - I promise!), I need a set of defines that will strip off comma
characters "," from a field with numerics.</FONT></P>
<P><FONT face=Arial size=2>i.e. def a char*10 = "1,234"</FONT>
<BR> <FONT face=Arial size=2>def b =
ncon(a)</FONT> <BR> <FONT face=Arial
size=2>rep b</FONT> </P>
<P><FONT face=Arial size=2>this gives ZERO</FONT> </P>
<P><FONT face=Arial size=2>obviously, what I need is to report... 1234 and not
0.</FONT> </P>
<P><FONT face=Arial size=2>I can do it with ten defines and later concatenating
them into a single define, then later converting that to a numeric, but there
could be a "one line" solution? ;)</FONT></P>
<P><FONT face=Arial size=2>Thanks</FONT> </P>
<P><I><FONT face=Arial color=#0000ff size=4>Fernando Olmos</FONT></I>
<BR><B><FONT face=Arial size=2>MIS</FONT></B> <BR><B><FONT face=Arial
size=2>Senior Analyst Programmer</FONT></B> </P>
<P><SPAN lang=en-au><B><FONT face=Arial color=#0000ff
size=2>HPA</FONT></B></SPAN><B><SPAN lang=en-us></SPAN></B><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><FONT
face=Arial><BR></FONT></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au><FONT
face=Arial color=#000000 size=2>Direct: 03 9217 5411</FONT></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us><BR></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-au></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-au><FONT face=Arial color=#000000 size=2>Mobile:
0410 382 857</FONT></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us><FONT face=Arial><BR></FONT></SPAN><SPAN
lang=en-au></SPAN><SPAN lang=en-au><FONT face=Arial color=#000000
size=2>Fax: 03 9217 5716</FONT><FONT
face=Arial></FONT></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us> </SPAN></P>
<P><SPAN lang=en-au></SPAN><A
href="file:///H:/Appdata/Microsoft/Signatures/www.hpa.com.au"><SPAN
lang=en-au></SPAN><SPAN lang=en-au><U></U></SPAN><SPAN lang=en-au><U><B><FONT
face=Arial color=#0000ff size=2>www.hpa.com.au</FONT></B></U></SPAN><SPAN
lang=en-au></SPAN></A><SPAN lang=en-au></SPAN><SPAN lang=en-au></SPAN><SPAN
lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN lang=en-us></SPAN><SPAN
lang=en-us></SPAN> </P><BR><PRE>**********************************************************************
IMPORTANT
The contents of this e-mail and its attachments are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you received this e-mail in error, please notify the HPA Postmaster, postmaster@hpa.com.au,
then delete the e-mail.
This footnote also confirms that this e-mail message has been swept for the
presence of computer viruses by Ironport. Before opening or using any
attachments, check them for viruses and defects.
Our liability is limited to resupplying any affected attachments.
HPA collects personal information to provide and market our services. For more
information about use, disclosure and access see our Privacy Policy at
www.hpa.com.au
**********************************************************************
</PRE>
<P><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'">**********************************************************************</SPAN></P>
<P><SPAN style="FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'">This electronic message
together with any attachments is confidential. If</SPAN></P>
<P><SPAN style="FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'">you receive it in error:
(i) you must not use, disclose, copy or retain</SPAN></P>
<P><SPAN style="FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'">it; (ii) please contact
the sender immediately by reply email and then</SPAN></P>
<P><SPAN style="FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'">delete the emails. Views
expressed in this email may not be those of the</SPAN></P>
<P><SPAN style="FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'">Airways Corporation of New
Zealand Limited</SPAN></P>
<P><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'">**********************************************************************</SPAN></P>
<P><SPAN
style="FONT-SIZE: 8pt; FONT-FAMILY: 'Arial'"></SPAN> </P></BODY></HTML>