Text File Formatting (Full Version)

All Forums >> [Community] >> Computer Software and Hardware issues



Message

steveg -> 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



jaybee -> RE: Text File Formatting (3/14/2007 11:37:01)

If the text file is comma delimited format or similar you can import it to Excel, sort it or whatever.

If you want to get really flashy you could import it into access and write a few macros and reports to do it automatically.



steveg -> 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



jaybee -> RE: Text File Formatting (3/14/2007 12:21:35)

What produces these reports?



steveg -> 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



jaybee -> RE: Text File Formatting (3/14/2007 13:03:05)

Can you talk to them and see if they produce it in another format or whether they can recommend a program you can use to play with the data? I'm sure you can't be the only one jumping through hoops.



steveg -> 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



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875