|
| |
|
|
steveg
Posts: 274
Joined: 10/20/2004
Status: offline
 |
Text File Formatting - 3/14/2007 10:04:23
Don't know if anyone has any ideas but I receive a large text file every day that contains various different reports on all our clients. The file is sequential client order. I need to move through the file and to break it into separate files by client. I then need to add our corporate logo and to generate a .pdf of the resulting files.
There is a client number that appears at the beginning of each report for a client. I somehow need to search for the client number and get all reports with the client number until it changes to the next client number.
I dfon't mind breaking it into a couple of processes, I just need to automate it as much as possible.
Thanks
Steve
|
|
|
|
steveg
Posts: 274
Joined: 10/20/2004
Status: offline
|
RE: Text File Formatting - 3/14/2007 12:07:48
Hi Jaybb
Unfortunately it is a textual representation of the reports with blank spaces to give the layout. The reports (there could be 5, 10 or 20 different reports per client) are all different and so there is no uniformity.
What I think I need to do is create some kind of search that looks for a client number change and then will take all of the data prior to that client number change and export it. Then I need the search to loop on to the next client number.
I think I used a piece ofsoftware years ago called Asksam which allowed you to create pages of text as a record and then identify a record break to the next record, regardless of what the content was in the text. Automating software like that would get me in the right direction.
All help and suggestions still gratefully received.
Steve
| |
|
|
|
steveg
Posts: 274
Joined: 10/20/2004
Status: offline
|
RE: Text File Formatting - 3/14/2007 12:35:53
The report is produced as a .dat file and is produced by a company called Argus Health in the US who are a claims processor.
Steve
| |
|
|
|
steveg
Posts: 274
Joined: 10/20/2004
Status: offline
|
RE: Text File Formatting - 3/14/2007 13:05:03
In fact I have just asked them that very question. It must be easier to produce it differently at souirce than to try to adjust it afterwards!
Thanks for confirming my thought process. It helps to have someone to reason it through with.
Steve
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
