probably use the replace function
---------- Original Message ----------------------------------
From: "Brant Winter" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Wed, 22 Sep 2004 10:22:48 +1000
>The CSV is as below - not sure how it will wrap though if I just paste it in
>here ( I have put an extra line break at the end of each record to make it
>clearer ) :
>
>
>
>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/2
>004","","","714718","Dr 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","ETOPOSIDE
>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"
>
>
>
>
>
>
>
>----------------------------------------------------------------
>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]
