IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Converting fixed length file to excel/csv


IBM Mainframe Forums -> IBM Tools
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ravikumar15

New User


Joined: 27 Mar 2006
Posts: 68

PostPosted: Mon Jan 09, 2023 7:27 pm
Reply with quote

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
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 1650

PostPosted: Mon Jan 09, 2023 8:19 pm
Reply with quote

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
View user's profile Send private message
ravikumar15

New User


Joined: 27 Mar 2006
Posts: 68

PostPosted: Mon Jan 09, 2023 11:28 pm
Reply with quote

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
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8661
Location: Dubuque, Iowa, USA

PostPosted: Tue Jan 10, 2023 12:15 am
Reply with quote

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
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10838
Location: italy

PostPosted: Tue Jan 10, 2023 1:00 am
Reply with quote

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
View user's profile Send private message
Joerg.Findeisen

Active Member


Joined: 15 Aug 2015
Posts: 940
Location: Bamberg, Germany

PostPosted: Tue Jan 10, 2023 7:53 am
Reply with quote

This forum should be for Mainframe topics, and not for issues with Mainframe datasets on non-Mainframe platforms.
Back to top
View user's profile Send private message
Garry Carroll

Senior Member


Joined: 08 May 2006
Posts: 1176
Location: Dublin, Ireland

PostPosted: Tue Jan 10, 2023 1:27 pm
Reply with quote

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
View user's profile Send private message
sergeyken

Senior Member


Joined: 29 Apr 2008
Posts: 1650

PostPosted: Tue Jan 10, 2023 7:58 pm
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IBM Tools

 


Similar Topics
Topic Forum Replies
No new posts File Aid Batch IBM Tools 7
No new posts To replace jobname in a file with ano... SYNCSORT 12
No new posts Extract record using 2 input file int... JCL & VSAM 2
No new posts I want to append a record in an exist... CLIST & REXX 17
No new posts Converting ASCII values to COMP-3 (ZD... JCL & VSAM 2
Search our Forums:

Back to Top