Topic Options
#40319 - 08/02/12 02:19 PM Split Flat File with Dynamic Data
Sal Offline
OL Newbie

Registered: 08/02/12
Posts: 11
I am trying to figure out the best method to split a flat text file with dynamic vendor data. Basically it is one text file of multiple vendor PO's. I do not have a breaking character but there are page numbers in the header. For example 1/3 or first page of three. I would like to split the file into individual PO's. I am running Planet Press 7.0. Any suggestions would be very helpful. Thank you

Top
#40320 - 08/02/12 02:27 PM Re: Split Flat File with Dynamic Data [Re: Sal]
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 3631
Loc: Objectif Lune Montreal
Sal,

I assume we can identify a new PO when we see "Page 1" on the page. So you could use a splitter to split whenever you find the word "Page 1" as the area where the page counter is in your data. This way, you'd split everytime you start a new PO.

Regards,
Raphaël Lalonde Lefebvre

Top
#40321 - 08/02/12 03:12 PM Re: Split Flat File with Dynamic Data [Re: Raphael Lalonde Lefebvre]
Sal Offline
OL Newbie

Registered: 08/02/12
Posts: 11
The page number is at the top(header) of every PO in the flat file. It prints as Page: 1/X at the top right corner. So I can split the file with a in stream splitter that will look for page 1 at the top of every PO in the file? The file is like this: PO 1
Page 1
Page 2
Page 3
PO 2
Page 1
Page 2
PO 3
Page 1

Top
#40322 - 08/02/12 03:53 PM Re: Split Flat File with Dynamic Data [Re: Sal]
Raphael Lalonde Lefebvre Offline
OL Expert

Registered: 10/14/05
Posts: 3631
Loc: Objectif Lune Montreal
Sal,

Yes, you can use the In Stream Splitter, and look for the word "Page: 1" in the column where it's supposed to be. This should split every new PO.

Regards,
Raphaël Lalonde Lefebvre

Top
#40323 - 08/02/12 03:57 PM Re: Split Flat File with Dynamic Data [Re: Raphael Lalonde Lefebvre]
Sal Offline
OL Newbie

Registered: 08/02/12
Posts: 11
I will give it a try. Thank you Raphael!

Top