[Technical] Export from CASES SQL contains CR/LF within fields.Can't find unique end of record.

[Stephen Digby]

Exporting from CASES to csv.  Imprting into MS Access.
Access has a heart attach when it gets the excess CR/LF's
If I massage with text editor, it cannot distinguish between CR/LF's IN the fields and the CR/LF at the end of the record.
I have trieed to create an SQL statement that places a fixed text marker at the start of each field in the output file, but can't
get CASES to accepts such things as :

SELECT 'zzzzz',DF.*
FROM DF

But CASES refuses to allow it.

======================================================================================
Stephen Digby, Learning Technology Manager digby.stephen.p at edumail.vic.gov.au
Cheltenham Secondary College www.cheltsec.vic.edu.au Ph: 613 955 55 955  Fx: 9555 8617
======================================================================================


 

Some minds should be cultivated, others plowed under.

-----Original Message-----
From: tech-bounces at edulists.com.au [mailto:tech-bounces at edulists.com.au] On Behalf Of Con Zymaris
Sent: Thursday, 2 March 2006 1:13 PM
To: Technical Discussion in Schools Mailing List
Cc: edulists.com.au IS; edulists.com.au Off Topic
Subject: Re: [Technical] Export from CASES SQL contains CR/LF within fields.Can't find unique end of record.

On Thu, Mar 02, 2006 at 01:02:34PM +1100, Stephen Digby wrote:
> Can't seem to write  an SQL query in CASES that generates a unique 
> string start or end of record marker.
> Can't import CASES export because so many fields allow CR/LF within fields.
> Any ideas ? suggestions ?

What tool are you using for bulk record import?

Cheers,

Con Zymaris

- CEO, Cybersource Pty. Ltd.
- Director, Open Source Industry Australia, Limited.
- Convenor, Open Source Victoria (A Government-funded industry cluster.)

--
___________________________________________________________________________
Con Zymaris <conz at cyber.com.au> Level 4, 10 Queen St, Melbourne, Australia
Cybersource: Australia's Leading Linux and Open Source Solutions Company 
Web: http://www.cyber.com.au/  Phone: 03 9621 2377   Fax: 03 9621 2477


_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe Technical Mailing List kindly supported by
http://www.vcaa.vic.edu.au - Victorian Curriculum and Assessment Authority and http://www.vitta.org.au  - VITTA Victorian
Information Technology Teachers Association Inc



Important - 
This email and any attachments may be confidential. If received in error, please contact us and delete all copies. Before opening or using attachments check them for viruses and defects. Regardless of any loss, damage or consequence, whether caused by the negligence of the sender or not, resulting directly or indirectly from the use of any attached files our liability is limited to resupplying any affected attachments. Any representations or opinions expressed are those of the individual sender, and not necessarily those of the Department of Education & Training.