[Offtopic] Export from CASES SQL contains CR/LF within fields.
Can't find unique end of record.
Stephen Digby
digby.stephen.p at edumail.vic.gov.au
Thu Mar 2 13:02:34 EST 2006
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 ?
Wasted 3 or 4 hours !!!!!!!
======================================================================================
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
======================================================================================
I worry that the person who thought up Muzak may be thinking up something else. Lily Tomlin
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/offtopic/attachments/20060302/890210aa/attachment.html
More information about the offtopic
mailing list