the looping part isnt your problem, the problem is breaking apart what you got and sorting and if'ing everything
think about what ur doing?
its insane
now if u break the csv list into lists 1 per record then u have some work to do
if not, i think ur SOL (shit outta luck) unless u can control how the list is created which last night u said u cant
well post some of the csv file (change names or whatever) but post a chunk of it so we can see if there is something that can seperate the records
---------- Original Message ----------------------------------
From: "Brant Winter" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Tue, 21 Sep 2004 15:25:27 +1000
>I don't really know how to explain this, but I am still really struggling
>with writing the looping logic for my app.
>
>
>
>My app is basically going to run through a CSV file, produce a query object,
>parse this query object and build arrays or structures that represent a
>prescription. Each prescription can have a maximum of 3 drugs on it, hence
>the complex looping requirements.
>
>
>
>The query object is about 200 rows long.
>
>
>
>Each row holds information relating to the dispensing of a drug. Patient
>name / details, Doctor name, drug name / details etc etc. The only unique
>identifier for each patient is a name medicare number combination.
>
>
>
>I have to write a loop that starts with the first row of the query object,
>gets the name and medicare number, and finds all the othe occurances of that
>patient / medicare combo for that date of drug dispense and get the info
>into a structure or array, or anything to start separating out the actual
>prescriptions.
>
>
>
>The hard part is:
>
>
>
> Each structure / array of drugs making up a script can only have
>3 drugs on it, so I my patient has 5 drugs prescribed on that day I need 2
>structures, one with 3 drugs on it, the other with 2.
>
>
>
>Can someone help me with the looping constructs ???
>
>
>
>
>
>
>
>
>
>
>
>----------------------------------------------------------------
>The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. It is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. Please carry out such virus and other checks, as you consider appropriate. To the fullest extent allowed by law, no responsibility is accepted by Haematology & Oncology Clinics of Australasia for any virus damage caused by this message.
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
