Page 1 of 1

Split Files - Specifying file names

Posted: Sun Jun 26, 2011 9:50 am
by othni
I manage to split the input file where I want it. The only thing that I am missing is to be able to assing the filenames based on text within each section.

I have tried a named variable, but it eludes me.

The report is something like this:

Code: Select all

Report ID: 12345                                                                                                     PAGE      1

BANK NO.   0000123   TEAM NO.   000                        RECONCILIATION  REPORT         DATE  06/02/11

   ACCOUNT NO.     0100012345   CLINIQUE            REPORT   MISC-CREDITS           AS OF 05-31-11

C  SERIAL      CHECK AMOUNT   DATE   DATE   SEQ       PAYEE       C  SERIAL      CHECK AMOUNT   DATE   DATE   SEQ       PAYEE
This is a long report that lists a fixed set of reports for each account. I managed to split the file at the beginning of each set of reports by account number.
Now I want to name the files as per the Account number.

I am clueless

Thank you

Othni

Re: Split Files - Specifying file names

Posted: Mon Jun 27, 2011 12:44 pm
by DataMystic Support
Hi Othni,

The output filename of a split is set as soon as the split filename is opened - so you cannot change it based on the content using the split filter.

However - there is a method for doing so - please see sysadmin\rename files according to contents

Re: Split Files - Specifying file names

Posted: Sat Jul 23, 2011 8:41 am
by othni
Thank you so much!

It took me a while to figure out the sample but I did it!

:D