• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Options for Monarch Data Separation

I

imcrystal

New Member
Is there a way in Excel to take a report in a .prn or .txt file and have the multiple "wrapped" rows appear in one row. Some people use Monarch models for this but I don't want to spend the money on the software if Excel can produce such a thing. My report headers look something like this: It's wrapped all over the place then places a blank row before it goes to the next set of data. Any ideas? Would love to save some money and NOT buy the Monarch software. Thanks!!


VENDOR-ITEM# ITEM CODE DESCRIPTION 1 DESCRIPTION 2 PURCH CL SALES CL

TYPE TRANSACTION # DATE TIME CHG IN FREE CHG IN ALLOC CHG IN BO CHG IN PO CHG IN TRANS

USER ID COMMENT 1 COMMENT 2 NEW FREE NEW ALLOC NEW BO NEW PO NEW TRANS
 
I'm unfamiliar with .prn extension, but Excel can usually handle txt files pretty well. Any chance you can have your source file output the txt with comma separated data?

e.g.,

VENDOR-ITEM#, ITEM CODE, DESCRIPTION 1, DESCRIPTION 2, PURCH CL, SALES CL


That would make things tremendously easy.
 
This rule is run from our ERP system and in the old days would come out on green bar paper with all of the headers wrapping around and the data following suit so it could be easily read. Now that Monarch models are a thing of the past here, getting that wrapped report to somehow separate into its own column in excel is proving to be difficult.

What I'm wanting is for Excel to pull the headers and information for each header in its own column. Here's an example of the first portion.

[pre]
Code: 
VENDOR-ITEM#  ITEM CODE                  DESCRIPTION 1               DESCRIPTION 2         PURCH CL   SALES CL
TYPE      TRANSACTION #       DATE      TIME        CHG IN FREE    CHG IN ALLOC       CHG IN BO       CHG IN PO    CHG IN TRANS
USER ID   COMMENT 1            COMMENT 2                  NEW FREE       NEW ALLOC          NEW BO          NEW PO       NEW TRANS
==================================================================================================================================

LAns  -00002  SIMG 11254                 DEGREASER SIMPLE GAL) 6/CASE (GL)              00         01
TI.TRN   1080400-0014        02/26/13  09:56:22            -3.00           3.00             0.00            0.00            3.00
Bsmith   TRANS: GEN           TRANS    1 TO   16            24.00          21.00             0.00            0.00            3.00
[/pre]
 
Hi Crystal ,


For details on the .prn file , refer to the following links :


http://www.fileinfo.com/extension/prn


http://filext.com/file-extension/PRN


It is possible the .prn file is a straightforward text file ; it may be that it contains junk characters ; would it be possible for you to upload your .prn file ?


This forum does not have a provision for either uploading files or attaching files to posts.


What you can do is to use your preferred file-sharing website ( RapidShare , Hotfile , DropBox , SkyDrive , GoogleDocs , SpeedyShare ... ) to upload your file , give others permission to access and download the file , and then post that access link here , in this same topic.


Narayan
 
You must log in or register to reply here.
Back
Top