balaji
I've attached a little example that imports some text across multiple lines.
Is this the sort of thing you're trying to do?
Regards
Peter Hearty
Lutris Technologies UK Ltd.
----- Original Message -----
From: "Balaji Krishnamurthy" <bakrishn@cisco.com>
To: <instantDB@enhydra.org>
Sent: Monday, May 08, 2000 10:13 PM
Subject: InstantDB: Importing records with new line chars
> Hi all,
> When I need to import a record that runs to multiple lines from a csv
> file, I get the record minus the new line chars in the db.
>
> When I make a query, I find all the new lines have vanished. So now
> Iam parsing the csv and am appending a "\n" string at the end of each
> incomplete record to maintain my new line chars.
>
> Is there a simpler way or any properties to be set, that would do
> this work for me ?
>
> thanx in advance,
> balaji
begin 666 sql1.txt
M9"!J9&)C+FED8D1R:79E<CL-"F\@:F1B8SII9&(Z8SHO:61B+V)U9W,O<V%M
M<&QE+G!R<#L-"@T*92!3150@15A03U)4(")E>'!O<G0P+G1X="(@1DE8141,
M14Y'5$@@0T],3D%-14A%041%4B!23U=.54U"15)3($-/3E123TQ#3TP@4U5-
M34%264A%041%4CL-"@T*92!3150@24Y#4D5-14Y47T)!4T4@,2!/3B!!3$P[
M#0H-"F4@1%)/4"!404),12!T;7 [#0IE($-214%412!404),12!T;7 @*&EN
M=#$@:6YT+"!D871E,2!D871E+"!C:&%R,2!C:&%R*#(P*2D[#0IE($E-4$]2
M5"!T;7 @1E)/32 B=&UP+G1X="([#0IQ(%-%3$5#5" J($923TT@=&UP.PT*
7#0IC(&-L;W-E.PT*8R!E>&ET.PT*#0H`
`
end
begin 666 tmp.txt
M,2PB,3DY.2TP.2TP.2(L(FAE;&QO(@T*,BPB;F]W(BPB9V]O9 T*8@T*>0T*
B92(-"C,L(C$Y.3<M,#<M,#<B+")H96QL;R!A9V%I;B(-"@``
`
end
-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.
|