export excel to EBCDIC fixed-width text file

S

SRCC

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel export formatting problem for fixed width files 1
how do i set up a Cobol Comp-3 data field in Excel? 6
Macro to Export to a Fixed Width txt file 5
Exporting Fixed Width Text File 4
Help with macro. Import text file (fixed width) 6
Export fixed width file from Access 2003 2
Exporting Fixed Width Text 3
Text to Column with fixed width in VBA 1

Top