> in a description field ????
Then your data will be out of line with your columns and the CSV will be
invalid. You need those quotes. cfhttp should take care of the quotes for
you automatically. The next step is to use query of queries to re-sort the
data, then cfoutput to loop through the data as Stephen has already
described.
_____
From: Brant Winter [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 22 September 2004 2:52 p.m.
To: CF-Talk
Subject: RE: Looping....again
Ok - same data no quotes, and I have checked that it still returns a query
object with cfhttp - I am still unsure what will happen if a comma turns up
in a description field ????
SRXNO,SDISPDATE,PTITLE,PFIRSTNAME,PSURNAME,PADDRESS,PSUBURB,PPOSTCODE,PMEDIC
ARE,PMEDICDATE,PCONCTYPE,PCONCNO,PCONCVDATE,PSAFENTNO,PREPATNO,SDOCPRESNO,SD
OCNAME,SDRUGDESC,SALTDESC,SQTY,SRPTS,SAUTHORITY,SSIGS,SWARDNO
977669,22/12/2003,MR,ROBERT,ROBBERY,1 CITIZEN
COURT,BRISBANE,4000,1234567890,31/07/2008,,,,,,714718,Dr Bob Jones,SODIUM
CHLORIDE IV 0.9% VFLEX 1L,SODIUM CHLORIDE,5,0,0,Use,CLIN
46470,3/03/2004,MRS,PATRICIA,JOHNSON,2 CITIZEN
COURT,BRISBANE,4000,1098765432,30/09/2007,C,406930987B,30/09/2004,,,714718,D
r Bob Jones,TAXOL VL 300mg/50mL C'trate,PACLITAXEL,1,0,-1,,CLIN
940528,18/11/2003,MR,BARRY,SMITH,3 CITIZEN
COURT,BRISBANE,4000,2468101214,30/04/2010,C,405091751V,,,,823793,Dr Bob
Jones,NEULASTA PFS INJ 6mg/0.6mL,PEGFILGRASTIM PFS,1,0,-1,administer 6mg
(0.6ml) from one prefilled syringe by subcutaneous injection the day after
chemotherapy as directed,CLIN
941320,18/11/2003,MR,GLENN,BRETT,4 CITIZEN
COURT,BRISBANE,4000,5672453678,31/03/2009,,,,,,823793,Dr Bob Jones,ETOPOPHOS
VL 113.6mg,ETOPOS,IDE PHOSPHATE,5,0,0,,CLIN
108923,4/05/2004,MRS,DOROTHY,REES,5 CITIZEN
COURT,BRISBANE,4000,6666666666,30/09/2007,C,406003520C,,,,823793,Dr Bob
Jones,PROMETHAZINE AMP 50mg,PROMETHAZINE,10,0,0,,CLIN
109139,4/05/2004,MRS,DOROTHY,REES,5 CITIZEN
COURT,BRISBANE,4000,6666666666,30/09/2007,C,406003520C,,,,823793,Dr Bob
Jones,SODIUM CHLORIDE IV 0.9% VFLEX 1L,SODIUM CHLORIDE,5,0,0,Use,CLIN
108923,4/05/2004,MRS,DOROTHY,REES,5 CITIZEN
COURT,BRISBANE,4000,6666666666,30/09/2007,C,406003520C,,,,823793,Dr Bob
Jones,ETOPOPHOS VL 113.6mg,ETOPOSIDE PHOSPHATE,10,0,0,,CLIN
109139,4/05/2004,MRS,DOROTHY,REES,5 CITIZEN
COURT,BRISBANE,4000,6666666666,30/09/2007,C,406003520C,,,,823793,Dr Bob
Jones,PANADOL TABLET 200mg,PANADOL,5,0,0,Use,CLIN
_____
From: dave [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 22 September 2004 12:04 PM
To: CF-Talk
Subject: RE: Looping....again
i think 1st thing to do is run a script to get rid of all the quotes
probably use the replace function
----------------------------------------------------------------
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]
