As Asked: September 10, AM Last updated: October 25, 7: 31 PM. Related Questions. how to convert physical file to spool file? Navigation. We have a requirement, where in the AS spool file (report) needs to be converted to a formatted excel sheet and mailed to the respective. It can be painful to convert spool files from the IBM i, iSeries or AS to user friendly reports such as PDF and Excel without the right tools. Paperless Report.

Author: Femi Ditilar
Country: Liechtenstein
Language: English (Spanish)
Genre: Life
Published (Last): 9 April 2014
Pages: 320
PDF File Size: 20.37 Mb
ePub File Size: 10.72 Mb
ISBN: 586-8-81347-923-5
Downloads: 40170
Price: Free* [*Free Regsitration Required]
Uploader: Dogis

To follow this tag These are pretty much your options for conversion of different type of files to plain text format.

How to convert AS/ spool file into text file ? – Objectif Lune Tech Support Self Help

There are almost always far better ways to get data into a spreadsheet. Check here to start a new keyword search. The source physical file should be created with a record length at least 13 columns greater how to convert as400 spool file to the page width to accommodate not only the First Character Form Control FCFC byte, but also the source sequence number which contains 6 bytes and the date which vile 6 bytes which exist on each line of text in the source physical file member. Can any one help me out with the code?

If it is possible, can you give me some instructions on it?


Convert spool file to physical file in AS/ – IT Answers

For example, if the page width isuse the following command to create a source physical file with a record length ofsince an extra byte is not needed for the First Character Form Control FCFC: Sign up using Email and Password. Login or Sign Up.

We use cookies and other similar technologies Cookies to enhance your experience and to provide you with relevant content and ads. Save the changes to spoil source physical file member.

Next use the following Copy Spooled File CPYSPLF command for how to convert as400 spool file to remaining spooled files to add them to the end of the existing physical file member, which combine all of the spooled files into a single physical file member: Can it converts captured data into text format?

Without this, the OVRPRTF command may not take effect at all which would result in losing all line and page breaks in the new spooled file. Is it use for capture inputted spool data?

Contact and feedback Need support? This allows the first character to be used as a control how to convert as400 spool file to so that you can convert the contents of the physical file back to a spool file and maintain proper page breaks and so forth. If “cells” are needed regularly, there are two general options other than manual: Naturally, there is no hoe of “cells” in the spreadsheet when I do that.


sponsored links

So if that’s what you have you can usually see the word “EMF” in the first line if you open it with a text editor Include as much of the requirements as are needed. That needs to be done manually when I open the file.

The real issue is how do you expect to map a free flowing format such as your example to a row and column format like Excel? By using our site, you acknowledge that you have read and understand aa400 Cookie PolicyPrivacy Policyand our Terms of Service. Document information More support for: None of the above, continue with my search.

A CSV file is simply a file where each “row” is delimited by a carriage return, and each “value” is delimited by a comma. This site uses cookies to deliver our services and to show you relevant ads and job listings. X Forms to PlanetPress 5.

We’ll email you when relevant content is added and updated. Below are the options you have as far as converting to text goes: Stack Overflow works best with JavaScript enabled.

By fille our website, you are agreeing to the use of Cookies. Then I can based on the text files to design the form in planetpress design. Forgot Password No problem!