EBCDIC to ASCII Conversion

  • Thread starter Thread starter gary
  • Start date Start date
G

gary

Four records in a mainframe file look like this:

--------------------------
a m
0809100000805F001460008000
0104F000F002F20009C014C20C
--------------------------
| ¬B
0054400000115C001760012000
1688F000F083F20014C017C20C
--------------------------
d ¬
1810500000017F002770169000
0400F000F042F20161C026C20C
--------------------------
& ¬ g
3590500000804C000100090000
4002F000F071F20093C001C20C
--------------------------


How can I convert those records to look like this:

008100941F0000000F0080025FF2000010496C0001048C02000C
010658484F0000000F0018135FC2000011746C0001172C02000C
108410005F0000000F0004127FF2000126717C0012669C02000C
345090025F0000000F0087014FC2000009130C0000910C02000C
 
I don't know of anyway to do this without writing a macro.
Can you not download the records in an ASCII format then use the file
converter in XL to split them out?

--
Regards;
Rob
------------------------------------------------------------------------
Four records in a mainframe file look like this:

--------------------------
a m
0809100000805F001460008000
0104F000F002F20009C014C20C
--------------------------
| ¬B
0054400000115C001760012000
1688F000F083F20014C017C20C
--------------------------
d ¬
1810500000017F002770169000
0400F000F042F20161C026C20C
--------------------------
& ¬ g
3590500000804C000100090000
4002F000F071F20093C001C20C
--------------------------


How can I convert those records to look like this:

008100941F0000000F0080025FF2000010496C0001048C02000C
010658484F0000000F0018135FC2000011746C0001172C02000C
108410005F0000000F0004127FF2000126717C0012669C02000C
345090025F0000000F0087014FC2000009130C0000910C02000C
 

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

Convert EBCDIC to ASCII file 5
create ascii file to unique design 2
Character conversion ASCII to UTF-8?= Old Accesstable to Unicode 3
"Horizontal" output from many-to-many tables 2
Converting a Grid (or range) of Data to a List 1
HOW TO MAKE THIS console application in C#.NET or VB.NET 1
Problems Loading Large String Array into Array variable 6
FWT Newsletter - Weekly - November 1, 2004 0

Back
Top