Using CVTPFXLS to convert a datafile

Can anyone help here please. I am using the CVTPFXLS command to convert a datafile to xls but the negative packed fields are not getting translated correctly. The negative signs are dropping out. Cannot see any options on the command. Cheers!

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your response...

Discuss This Question: 9 &nbspReplies

There was an error processing your information. Please try again later.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Here is the DDS for the file (only the numeric fields are the issue. The negative sign is not being carried thru:
:
A WP1$ 13S 2
A TEXT('WP Year -2')
A NB1$ 13S 2
A TEXT('NB Year -2')
A WP2$ 13S 2
A TEXT('WP Year -1')
A NB2$ 13S 2
A TEXT('NB Year -1')
A WP3$ 13S 2
A TEXT('WP Year 0')
A NB3$ 13S 2
A TEXT('NB Year 0')
A WPP$ 5S 2
A TEXT('WP % Change')
A NBP$ 5S 2
A TEXT('NB % Change')

I have not been able to find the PTF nor a later version of the command. Seems its no longer on the web. Its a fairly straight foward file and can't see why it cannot handle negatives.
Anyway, I have resolved the problem by converting the numerics to alpha and adding the negative sign myself.
Thanks guys.

Hi Teandy,
Thanks for your tips. I had the fields as packed intially. When it didn't work, changed them to zoned which also did not work. Some are saying that it is a known bug and there is a PTF to fix it. But I am not able to find the website from where I got the original. Wonder if anyone can direct me to download the later version of the command.
Thanks.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

Share this item with your network:

To follow this tag...

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States.
Privacy