ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   export excel to EBCDIC fixed-width text file (https://www.excelbanter.com/excel-programming/412137-export-excel-ebcdic-fixed-width-text-file.html)

SRCC

export excel to EBCDIC fixed-width text file
 
How do I convert a 40 column spreadsheet, containing both text and numeric
data, to a 200 field EBCDIC fixed width TXT file for uploading to a
mainframe? Output length = 1300. The additional 160 fields will be
defaulted to spaces or zeros. Several of the source columns will map to
signed numeric (S9(8)v99) fields.


All times are GMT +1. The time now is 04:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com