|
View previous topic :: View next topic
|
| Author |
Message |
ravikumar15
New User
Joined: 27 Mar 2006
Posts: 68
|
|
|
|
Hello,
I am facing a problem with the fixed length file. Earlier our system was having mainframe now its moved out. But the files coming from vendor is still in the same format, with the numeric fields also in signed numeric format. Is there any tool/process to convert the file to excel format or csv with the numeric fields in display format.
I am trying with vba macro but facing difficult in converting the numeric fields.
It would be very helpful if some one can suggest any alternative tool/process which would do the job.
Thanks in advance |
|
| Back to top |
|
 |
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2141
Location: USA
|
|
|
|
Since "mainframe now its moved out" then you are not able to use any mainframe tool to perform your conversion.
I recommend you to visit a Windows forum. |
|
| Back to top |
|
|
ravikumar15
New User
Joined: 27 Mar 2006
Posts: 68
|
|
|
|
I know mainframe tool cannot be used. So I am using VBA. But I am seeking suggestion if there is any other better way.
I saw somewhere that Rexx can be used in Windows as well. If it is, can any suggest, how to run it in windows? |
|
| Back to top |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8700
Location: Dubuque, Iowa, USA
|
|
|
|
| If any of the fields are binary or packed decimal, conversion of them can be challenging. Plus, as was mentioned, mainframes use EBCDIC and PCs use ASCII, so you are guaranteed to need to do that conversion. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10888
Location: italy
|
|
|
|
| Quote: |
| I saw somewhere that Rexx can be used in Windows as well. If it is, can any suggest, how to run it in windows? |
see here
www.rexxla.org/
and here
sourceforge.net/projects/oorexx
remember to inquire with the powers of your organization
about installing open source software on your workstation/PC |
|
| Back to top |
|
|
Joerg.Findeisen
Senior Member
Joined: 15 Aug 2015
Posts: 1335
Location: Bamberg, Germany
|
|
|
|
| This forum should be for Mainframe topics, and not for issues with Mainframe datasets on non-Mainframe platforms. |
|
| Back to top |
|
|
Garry Carroll
Senior Member
Joined: 08 May 2006
Posts: 1205
Location: Dublin, Ireland
|
|
|
|
| Quote: |
| But the files coming from vendor is still in the same format, with the numeric fields also in signed numeric format. |
Have you considered asking the vendor to convert the dataset to the .csv file format you require?
Garry. |
|
| Back to top |
|
|
sergeyken
Senior Member
Joined: 29 Apr 2008
Posts: 2141
Location: USA
|
|
|
|
| ravikumar15 wrote: |
I know mainframe tool cannot be used. So I am using VBA. But I am seeking suggestion if there is any other better way.
I saw somewhere that Rexx can be used in Windows as well. If it is, can any suggest, how to run it in windows? |
Before using ANY tool, at all, one MUST understand well all the details needed to resolve the problem. Starting from: (as I already mentioned, but all has been erased by moderators):
- what is the encoding of the data in the input dataset?
- what is the content of each input field in its hexadecimal presentation?
- what should be the algorithm of conversion of each mainframe-based field to the corresponding Windows-based field?
- etc, many other details.
Without understanding those issues in depth, none of available tools can be useful. In any platform, and any environment.
Erasing my comments from the topic would not help to fix this problem, too. |
|
| Back to top |
|
|
|
|
