>Does anyone know how to convert data in a packed decimal field to a standard numeric field.
>
>THe data file is an FTP download off a IBM Mainframe and the data was in DB2
>
>All of the file converts to standard ASCII text except the packed decimal field.
I suspect the "packed decimal" is the same format that is also known as BCD. If it is so, in each byte, the first four bits represent one digit, and the next four bytes, another digit.
The first half-byte would probably be the sign.
HTH,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)