Split Files - Specifying file names

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

othni
Posts: 34
Joined: Tue Mar 01, 2005 1:47 am
Location: San Juan, Puerto Rico
Contact:

Split Files - Specifying file names

Postby othni » Sun Jun 26, 2011 9:50 am

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

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Split Files - Specifying file names

Postby DataMystic Support » Mon Jun 27, 2011 12:44 pm

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
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

othni
Posts: 34
Joined: Tue Mar 01, 2005 1:47 am
Location: San Juan, Puerto Rico
Contact:

Re: Split Files - Specifying file names

Postby othni » Sat Jul 23, 2011 8:41 am

Thank you so much!

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

:D


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: No registered users and 1 guest