Split Files - Specifying file names

[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

[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

[othni]

Thank you so much!

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