|
I know it has been discussed many times, but I still can not find specific scenario I am stuck with. I need to transfer some data base files to PC in ASCII format. I have only character and signed numeric values in these files, no packed fields. When I try to use CPYTOIMPF command to transfer these files into flat files, I am getting problem in numeric fields. For every numeric field it drags the position of next value by two digits because of placing sign (-ve) and decimal point. Is there any way to convert these values without decimal point, say for 12.50 just convert to 1250. I also tried to use CPYF file to copy the data in one text field file, so I can eliminate decimal point it works great but then I got problem if there is any -ve value exist. The value looks like "125}". Any idea ? Thanks Dawer
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.