Converting Mainframe DISPLAY data to EXCEL formats
I am doing more FTPs from our mainframe into EXCEL. One problem I struggle
with is the mainframe numbers are formatted in DISPLAY where the last byte of the number contains a sign character (+ 0 = {, +7 = G, -7 = P...). I can write a program on the mainframe to convert the number and place a sign before the data but that increases the size of the field by one byte and also must now be saved as Alpha/Numeric as a minus sign is not a valid numeric value. Ideally a function in EXCEL can be created to accept the DISPLAY format and convert it to a signed, numeric value in EXCEL. Any hints? |
Converting Mainframe DISPLAY data to EXCEL formats
Any hints,
Sub FixIt() Dim rngCell As Excel.Range Set rngCell = ActiveSheet.Range("B6") rngCell.Value = CDbl(rngCell.Value) Set rngCell = Nothing End Sub Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Peter" wrote in message I am doing more FTPs from our mainframe into EXCEL. One problem I struggle with is the mainframe numbers are formatted in DISPLAY where the last byte of the number contains a sign character (+ 0 = {, +7 = G, -7 = P...). I can write a program on the mainframe to convert the number and place a sign before the data but that increases the size of the field by one byte and also must now be saved as Alpha/Numeric as a minus sign is not a valid numeric value. Ideally a function in EXCEL can be created to accept the DISPLAY format and convert it to a signed, numeric value in EXCEL. Any hints? |
All times are GMT +1. The time now is 05:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com