RE: CPYTOXLS problem converting a field with ip address

["Luis Colorado" <LuisC@xxxxxxxxxxxxxxxx>]

Fabio,

What is the type of the field (column) containing the IP address?

 -----Original Message-----
From: 	midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx]  On Behalf Of Fabio Kang
Sent:	Monday, January 28, 2008 3:42 PM
To:	midrange-l@xxxxxxxxxxxx
Subject:	CPYTOXLS problem converting a field with ip address

Hi Everyone,  I am having problem converting one field with ip address
information using  the tool CPYTOXLS., which I use and it is great.

I do the following:

1- DSPJRN JRN(QAUDJRN) ENTTYP(PW) OUTPUT(*OUTFILE) OUTFILFMT(*TYPE5)
OUTFILE(mylib/crtdupobj of QASYPWJ5)

2-  CPYTOXLS FILE(mylib/crtdupobj of QASYPWJ5)  TOFILE(myfile.CSV)
TODIR('/mydir')

Looking the file via SQL I can see the IP address field fine, field name is
PWRADR   (QASYPWJ5  Remote address), but  after converting with CPYTOXLS
tool, the field look more like this in excell:   ±ÒÓKÒ±KãͱKã±ã@@@@@@@@@@@.

Any help will be appreciate.

Thank you, Fabio