RE: Witango-Talk: [OT] Extract data from report

2004-02-27 Thread Wolf, Gene
d it works quite well. -Original Message- From: Chuck Lockwood [mailto:[EMAIL PROTECTED] Sent: Friday, February 27, 2004 10:17 AM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: [OT] Extract data from report I highly recommend a product called Monarch whenever you need to extract data

RE: Witango-Talk: [OT] Extract data from report

2004-02-27 Thread Chuck Lockwood
: [EMAIL PROTECTED] Subject: Re: Witango-Talk: [OT] Extract data from report What I mean is if you don't have to take the report parse it and manipulate it on a moment to moment basses. If you need to periodically get the report then move it into SQL tables or something like that then Filemaker

Re: Witango-Talk: [OT] Extract data from report

2004-02-27 Thread Dan Stein
What I mean is if you don't have to take the report parse it and manipulate it on a moment to moment basses. If you need to periodically get the report then move it into SQL tables or something like that then Filemaker will do a good job for you and it is easy to manipulate the data once it is in t

Re: Witango-Talk: [OT] Extract data from report

2004-02-27 Thread Dan Stein
If you don't need to do it on the fly Filemaker is real good at this. on 2/26/04 22:10, John Shaw at [EMAIL PROTECTED] wrote: > Hello all, > > This is way off topic and not even web related, so stop reading if you don't > want to waste your time on it. > > A legacy system, which I have no contr

Re: Witango-Talk: [OT] Extract data from report

2004-02-26 Thread John McGowan
Sounds like a job for perl! /John John Shaw wrote: Hello all, This is way off topic and not even web related, so stop reading if you don't want to waste your time on it. A legacy system, which I have no control over, provides a huge text file with about a hundred separate fixed-length batches.

RE: Witango-Talk: [OT] Extract data from report

2004-02-26 Thread Troy Sosamon
I normally read files like this one line at a time into a single note field. Read the header line out, Then read the following records and parse them out and put the results into another table. Troy -Original Message- From: John Shaw [mailto:[EMAIL PROTECTED] Sent: Thursday, February 2