|
Home > Archive > MS Access Database with External Data > November 2005 > question on importation
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
question on importation
|
|
|
| I have a text file with data. the values are comma separated, quoted values
(double quotes).
one of the fields that i'm outputting in my text file is, in essense, a memo
field. this field COULD potentially contain CRLFs.
When I go to import the data in to Access 2003, it is assuming that a CRLF
is an indicator of an end of row of data.
Because my memo data has CRLFs in it, even though it's quoted, comma
separated, it hits that CRLF and the importation starts processing it as if
it's the next record.
How can I tell Access to NOT use CRLF as an end of row marker? For example,
let's say I output my text file with a character (say the pipe | character)
as the indicator that it is the end of the row of data.
In other words, I have memo textual data that I need to put into a memo
field that might contain CRLFs that are screwing up the import.
how do i handle this?
i know I could strip the CRLF's out of my memo data. but then it makes the
format of my memo data incorrect.
| |
| John Nurick 2005-11-18, 3:24 am |
| Hi Bob,
Access usually has no problems importing CSV files that include line
breaks (CRLF pairs) within records. I've just tested this with Access
2003.
It's essential that the text and memo fields be "qualified" with double
quotes: the import routine relies on counting the double quotes to tell
whether a CRLF is part of the data (i.e. between double quotes) or the
end of the record.
Consequently there are problems if the data contains double quotes, e.g.
a field whose contents are
"Legs" O'Reilly
If this is surrounded by double quotes it appears in the text file as
""Legs" O'Reilly"
there's obvious room for confusion. To avoid this, any double quotes in
the data have to be doubled, so this in the text file
"""Legs"" O'Reilly"
will import as
"Legs" O'Reilly
One thing that will cause the problem you're having is if your import
settings don't specicy " as the text qualifier. Otherwise, the problem
is much more likely to be in the text file than in Access.
Access's built-in text import routine doesn't allow anything except CRLF
at the end of a record.
On Thu, 17 Nov 2005 17:25:25 -0500, "bob" <rb@somewhere.com> wrote:
>I have a text file with data. the values are comma separated, quoted values
>(double quotes).
>
>one of the fields that i'm outputting in my text file is, in essense, a memo
>field. this field COULD potentially contain CRLFs.
>
>When I go to import the data in to Access 2003, it is assuming that a CRLF
>is an indicator of an end of row of data.
>
>Because my memo data has CRLFs in it, even though it's quoted, comma
>separated, it hits that CRLF and the importation starts processing it as if
>it's the next record.
>
>How can I tell Access to NOT use CRLF as an end of row marker? For example,
>let's say I output my text file with a character (say the pipe | character)
>as the indicator that it is the end of the row of data.
>
>In other words, I have memo textual data that I need to put into a memo
>field that might contain CRLFs that are screwing up the import.
>
>how do i handle this?
>
>i know I could strip the CRLF's out of my memo data. but then it makes the
>format of my memo data incorrect.
>
>
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
| |
|
| here's a sample of my file. errors start on line 24/25.
you can see that the last quoted field has crlf's in it and that there is a
final matching double-quote. yet it still separates.
i looked at the file in a hex file editor. it is using 0d 0a as the CRLF
which looks purely legit and contains no other extra characters.
it's killin me....it looks like i have it right? i went into access,
imported it, and set field11 as a memo field. yet it reports there were
errors during import.
HELP!
;-)
"bob" <rb@somewhere.com> wrote in message
news:evx3PX86FHA.3684@TK2MSFTNGP12.phx.gbl...
>I have a text file with data. the values are comma separated, quoted values
> (double quotes).
>
> one of the fields that i'm outputting in my text file is, in essense, a
> memo
> field. this field COULD potentially contain CRLFs.
>
> When I go to import the data in to Access 2003, it is assuming that a CRLF
> is an indicator of an end of row of data.
>
> Because my memo data has CRLFs in it, even though it's quoted, comma
> separated, it hits that CRLF and the importation starts processing it as
> if
> it's the next record.
>
> How can I tell Access to NOT use CRLF as an end of row marker? For
> example,
> let's say I output my text file with a character (say the pipe |
> character)
> as the indicator that it is the end of the row of data.
>
> In other words, I have memo textual data that I need to put into a memo
> field that might contain CRLFs that are screwing up the import.
>
> how do i handle this?
>
> i know I could strip the CRLF's out of my memo data. but then it makes the
> format of my memo data incorrect.
>
>
begin 666 eventlogdata.zip
M4$L#!!0``@`(`(Y,<C/VD,WL8RT``(/ G`@`0````979E;G1L;V=
D871A+G1X
M=.Q=:V_;1K/^? 3X/RSRY22 K>Z%]P'<&RG<6L[@NTVIT" @A9IB[!$ZB4I
MN^Y[WO]^9I>D1)&*(TO4DE39I*UE\3+/W'9F=G?VW<U+%+N3=X?O//\^""=V
M[ 4^?-(QT^!_\!?#OX.3CX.3\UM,X6="?B+Z3Q1C%>D6U2U%0<>7'O^&T*(
MCG6J*TH?BW^.&.;WW& #91;CADS=TT4G@QV$P1I
>V;S^X(7S#X-_;D8NNW4D0N^AX
M.'2CB%_GNT-.2G8IBM)'N'[LAJZ#8K@IG/F^YS^@*+9CM__NH/?N^VC4!,:W
MP308VW[TZ#4/VK,=H6@F+KN?C<<O\(4?(YO#"V,T3%[P`YA2A7;KCMWI*/!?
MMI:.5+)O;DX'Z-2+AL&3&[Z@[(8J-.SJ%AW_=OOYR_7Y[1_?;OZXN3V[; JL
M%FI7./%\>YPAB5HOH>\C:IUP;EXF-DAAB([]V/O="V=1NWS \70Z]H;B[>C"
M?@$O_#-0^&SOCSM8'V'KE._*C9^#\!%=!"F^XV<& #91;='T^O+Z_NCC^T'K9
K0UP
M:]$)J#_$I5F,E7!IC"WC^LKHK3=Q<SAB^#BGU8N0'SRCZ,4?CL+ ]_[FTN"2
MB01IR<7/7CP2O^2?#GI1, OA5GOBQJ'GN_WI\*X_#";HO1]/^\[_$9WV*?SM
M,XM0=O0_Z6>E3S'_Q8?7D&N 9#WLF):Q8[J,_>P)&'\1/.3 BU^A<?"P+"TN
M&=?Y`67FSBB[](9A$ 7W,7I__0%]]7PG>([$SVH?DSZ"!^"YAQC8PT=$T>5L
M''O3,.!J%H3H4^BZ/Z#_%7>@)?0#\:JEF&B0HU\C!E85<V/.!M/IZYQ]W5&E
ME#&+FI9""Y2IU%3H-CXX^7;"*9>5RT@'M.. 11,LY6DJ65%_CCI:2UJ:
=-4)K
MG="DI)W5D]V(M%,ZK)U&*&J"1K548JG&DH-3B:X2U9 5H1Q?GMU^!L:O$Z$0
MK4]PGY(5(0J$>5SP`A[1V#K(L<5P"3EF>!GYJ1\=3[GSH2GP%-*][8VYT@4H
M=!\\^%6(1D$$P0$$F:&;@@O=81 Z/$JXCCX@$,Y!ST\C5-NQIW#304^P)7+C
M&,B/K(,>_X/0<?(UNH((#EGHW]14SYC.S"/3,-F1HAOFT3$SR1'[J'XT*3ME
M9^ST/\FMGSD9Z7W U.G0BS%-OAJ$WL0&73L- )K;GHYO9_;WW5W(9YWUR
T>G5
MC1 LO'T,P)"5_!JA_\I%B8<H+Y#DBANNH+. I`Z;'^9(^PTJNY'^2R\X
'@,X!
M'D7O7>#*_/$+B2=,X,P.73L"SYM3I6$P&SN@;?&"[_!M!&[[.A(V<^<.[1E\
MAM\>]')8,H'!HU(:0_=?,S>*^XB_:<*Y-O8>7;"TY '!/5SL10<]T.YX9,?B
M5GL6CX+0`_?B/;EY5O&'>6&B$6G$)VY/7W;02]^&1D"C#3$8!(@@@NG8!CU)
M(?X=^.XAO_O.O@,R,B2V^.*@%X<P$-[#N^"I_-8P>.!<["?L^B.8`>$^FMC^
MS.;^(H30_T60F' J3*(/`<M%!3U$MN\`TCB:JR*Z>T'QRY1;\CMO"O[FWGM
M/ V5,=_SH'4IY`IH#+W4X0
9-I#.2<WPL08W?"@TMO/$93-XS@OD/AM^QAC%[
M0/+L@^@XHR@1-/#==B:>GQ >A-N:N[+*W)7.W#MS[\R]\>;^EOAS;O$,,F6]
M:/$,@K6VU=-E(MIQ3E,]%+GU].KI;UH]O4Z$K5.^AM73:P2X@>C>'L,QU:)F
M"99*S2Z& ZV*X+H9K4PSW^B32PN(5
BRHEBU>H4M<DTI:4U3Z)M*"?64JI\,>8
M8M0UB9121JA%-$LMNGE*--5LV2R2?$0[#J"4^0PD+<87"C$P?7M\T9AII!JA
MM4YH4J:1JB>[$=- (TF'M,C!7YL559C%:`*,
KC-$N,.\"\RXPWY.Y%"47.S*E
M:.X,@L?.W#MS[\Q]?^92YA9/38NPHL53D["VS:7(1"0GL*\0BMRYE.KI;]I<
M2IT(6Z=\#9M+J1&@E)2-&A;32K ,IG4Q7!?#=3%<FV*XUQ;ZYNT=X[*]8]RR
MA;YOF49:@->+B_\X>+VX^$_>--*6E-4^C;2@7[-4M42_IJIU32/-*<,*WWM7
MH PKC+5L%DDZ( GAAVYATU+QTBX*!>O85+OEN%WXT84?>U8QYK/?EDH*YJZI
MIDHZ<^_,O3/ WO:L8\ZC08F6+5QEI_Q(
1^=!D+1&I#)G< )2*5D=VL)2*R8+50
MNQHQB20%4>N$4\LD4H7T-W02J1:$K5.^9DXBU0%00A4'8"GPMP1+4;N%0%U:
MUZ5U^S:)).R=&&5[)\;^3R(!> +%CI@A^FQTSU4PB;4I94
R:1@'X*$$KT4Y55
M.8FT&-T,3,GWJ:+S73N*4>Q*"?]3C&)7RH_77[[>G%WGAK>[$#@)!LEIF?G@
MA]QDC(M#SWWBODB,">!$$L.-T#U8O5#V[,Z)+;SRMV\06PR.3KZ<?:*9@\M,
M_-NIRP%_@XC@X^V?M\.I-_USO2&NGXP+X%)M)/PRA$-A".(<!HZ[84A ,ED"
MWPH3FH088('=Q$X7$G0
AP;Y,[)#<-B9(; KFCBGK)G8Z<^_,?8\F=LB\;Z)A
MD>(`KZL&P6VKXLI$M.-"6O50Y%9QJZ>_:57<.A&V3OD:5L6M$> NJ[@+6'IQ
M82&'I1<7%G8Q7!?#=3%<>ZNX"WO7X&_)WC55V^,J;AX\U<O@J5Y7%7=+RFJO
MXN;IQTJ9?JQ46<45A4K^AA]S5+&886&U0)'&#*Q^3]%)7M&!04^>PT>>>'HR
M]CB)H/.)^<]2_V8/A:]+;A!57/!/W(0G0<C]E# 8H?31(8R*SRZW<%]<DSB?
M]$L$PS\:SD((`F)P6+8
8\3WP&WUTT+N"]\0`?QKS5V9^PT[O!1L#MW('?MMV
M7#ZR(J(B<!>SV.4.<4$\=[=^D-T%[X>WS$(Q1 &9??2=*((JN^"TB"$X=P8E
M+EL(`#_98\_AX< ,T\,'QC\1PYOH\CG!AO'
$29CO)Z)W&06-X2M&U@.^\YT[=
MR%@8Y7GHB2$/I%I^4,K5@Y[C14,[=."58KC*B92/%#GE$'?D!.6D"Z[@)A[L
M/*]XB0#Q//*&(Q$FS%VINZ6/URW%+)Y20;"NF,53*O;G7(<%<KVX)H$CU[LU
M"5TTVT6S^S8!`9GK*G-GG;EWYMZ9^SY.0. BB^Q@M67RIV6!#:]P5TM
^8G3$U
M0I- 3VZX0F92=,3NPE2;LC)$
.JX7:U8@Y52F(6B><ALY)UH*P=< )KYIQD'0`E
MS$D"++HJK:-=6M>E=5U:MT]'O2PLGA0W,7"+)_5MK]B2LJ9,S.F\@R4VB_13
M$YMU]>C"\Y96S"++,]&8P*U$:UF/+NF =CD&IV ,WJ.++8_!&!O8[-J\=V-P
M-P;OS4P*SH8)%<Q=+9B[KII,[<R],_?.W/ =G)F5A\:I%RA:O$K6U,Q
$U0MMQ
M1:MZ9%)F(JHGNQ$S$=)
AM5"[ZIV)D(FH=<*1._-=/?U-FTFI$V'KE*]A,RDU
M`I10Q>&KXRRFEV I3._2NBZMZ]*Z?=G=E;=W3,KVCLD>[^Y:@"_-AG/PI=EP
M>9-(6U)6]R22^=U3T+"YZA0T:7-(9K;SB&B%HZ>!, U&QC>O?_@"8P1<< ),H
M\9G_X/FKP\B4]"VCX@4`PF?GB@!(<7;NQP`R[3CW@3*QO6@KZBE-:#=>H1T3
M4(PB& #91;9C0`NT99;\EX]'Q`
Q"4$G[M)L'.=3JL6.B6;\^:3,=N+,8V& $$G"6G
M?A^,Q\$S=TG)J!,=9@YZ.HL7F& #91;=X@)(8L'!5,);,=\
99J'>4T</WS*72!Q0,
MO?_UHXEUA>@?X)H;=SB#<? E?W&&YW'_%K#U!2J?"@\;Q:/@^ Q>> O,_\1
MG4$H,D:?O#$G,'V%2?EMV>,N;0CYO0"2L1NP>!XSBNK3$Z2<MP&(_ A=!4_N
MY [N%_P7[\8&PQ]>$2,Q98CQ/" ^DFWE(:\VQ+86YJ4A3C2
P*TVH$0XA29@A1
M:F+()HJU/0N6=W0F+"CMZ)3%@K7M\!7<D/3H;\D-EYB!5S"CT/CC*DZ]-!^)
M4R[D:/P<Q#P-R2@5X^ <=G];> 6%+T4HD8D5K@,JN]*U;#
YR N#SRPSMV-_+O
MK @A&=-N2T9Y,+3L0C!5=Q/92)'.K@%M()HU6B*D"+@7X\MJEQ$`T<5EM5U'
MA T[(FS.Z*XAPBX:(IC96C:>96GY]!M#H C_U? :T'X*97\1G%H%CDYE=^;
<K
M_W;EW_U8Q&?FU_ 5K9VOX>NLO;/VSMI;- =E#C!\E_3IO2+I\0H4P]
]()%>LF
M_=>N[;Q80G-*%581C\-3_'%@B]C/Y]$H7"\"['R1-HT@Y\58_O,\CH^&(]>9
MI4XFO2O5]>Q%0,A7U_'=R+%?#A<5/FP> )E4^$)"2E&/^.47<3A=:HPO;BE&S
M%%H2(Q#4B7$S,6XK#Y7
758OR4#>MJ^ZG/+8L%0HNT& #91;+S4JGRULK:1WOX^!
&
M,V#=N1^[X['')8%NLRBCEO6!]<.44O%-EM#I97Q$;^N&@AJ1M4UD,K835$]U
M$W832$?5/ M6J=2^!3$!M$XW4G035D
]^PC01U`FR;YC5K&T&-^':XB\#,;R(H
MUY65KJ[<U96[NO(>M6,R\\O56<G@&6,U+:3?DK"ZU]$;V3IZ1;.HL;0NQ""Z
MHE%C%X>D$)RP=(U$-R60$(L2BRT7O Q"*&&%@M?IR9?+='T0_[%PUC77\IG/
M`X_<>HAYN2KU3K.(VXL-&6-J9HN51 <]8'P<#(-Q5#$T904TI>W0^-K/8MAA
M$*QHQ;!C&VC3C)8:T.&BT7-TN'1"76O1D17HR'Z@8WHQ= 1T/#K;#W0:C$@E
M=)K*]@7=\J:U!%UQ.7)]Z-Z0@1KS`X(4OMME"136%87*WW"U;AJ6)YV0,NFD
M.VV]2\.Z-&Q_6G0M#)Y8*BX9/%%QNQJD2L>SVV)F'@[6RW"POO%0,H$OT#'?
M0Q%Y`MS[K^>R:YGUP9,D-J;PDU8+N)A"]8;O&5\"P%8`8(W9^O86IR 'S0[+
MY'DDA):1$-K%9UU\UL5G^Q>?E8X&$ 9?.AJ@\5M<90*2-,A3L[B0UN"G'BBM
M/ 6:O1F1M$YF,M6C54]V$M
6C24;5-M:0N>-J%9=2ZE$XFH+9I5L/6HM4)L&VB
M:]9:M!KQR4BRDU:$)52
EZ=(NR>Z2["[);FM#VX6Y&ZN<F%':$-GTSBVYB7BZ
M%FILEE$7NX*>CH;37)<FL% [L5 T!@-T,UN'_U"Q?2_..?,3.TSZ8N94*KD7
M8\(HO/1$96?S3D,'/<?U/; 3KE[PF-//)X-,"?+0T?O;[-N;Y-MT#."_NCH^
M^15-X!TPP&S>[W> )2_H*+NDUK5+<DK"&K%+4>;>D\A +PW-=W7X7A&&+EN8/
M" ::X]44=0$:,,C)BM+VH4
QDPJ44=3K6^@FJ]U44=6
:@DJ1;6^2;U`ASX@]M:
M%9$`J&VBJ:?>5AGY32WJU "P"LVK&>PNZR"UJNEN"UCKI'E8Y0U3BU#4[S=,
ME9GFI2E4U>>6Y,%3M0R^V%A8?AZS&6%UYS%Z0K[&#P=1EALVZ\0@FJ+6E,<L
M",- \)U*1,,R4F@_]6)MZ4F8
K;N^YL4O(5LB%*"W-PJH'MG$6ENN?C=\RBN<A
M8*,,`1<2R4'HB=9;-/L9F'T:>KP0]7D`(0J0_8L;(P4G/LB#V'AP<H&TI0YB
M0-U?AH9^Y]7/P#]B0DRVP& #91;MRP55)9=CI\^9O;F
0=P8,_?J*4_MP_O;@XS#Z=
M+7TZ[P\N3W.?/E\,^*? 3D\LO5XL+;R\9G7\Z_G2
:^\1O^W7ITR^%%^0_?5[Z
M](E_JE@<V+146A0'-E6ZH3C4ZL0QFM[=8TP?^LYX?)A]<I<^>?WIQ,E]-QI/
M^2=G. G\Q87Q! 20?;+OG> 13]8Q4E#(CBXT;UV7DQ6
N<HS_@W/7QS>EIHCKB
MQ]]2K0*1J&>7-\O?"!4>_'*1:O .V()7L 7_P_1K$V_/@VFMQ#M5U5JV+%$F
M($D#,2 ICV*@G$:- NP\WM5#%8J0$16'D'^ZX
E.(I,8(MQ9RI<URK>(>+!VUQ
MWN$-RH8-*+M+1R7+A54%IS&CR^X!M4TT-<^(R 34-M%(G1&IGOR&S8C4";!M
MFM>L9:XUXMM:<(2J/ZY? J_PXGU(HJ:MF,90\Y6OM
O+L9/^CXPO,?>1_PX2-G
M>G(26PKQR[,/<>+(FV9+"9^"\6SBHO-3$5.>68M3Y9; #<>V-^%A9-)U?G$7
M7R09)2O"OD\"/Q-P%@<< ^C!=WCBUO1#=0TR*QG!I
=,A?-^*GR=V,W#%XZ%$0
MQL-9'(D.^%\NSK++GD= &B<U"B:Y):9!E#Z(+[SDW]R%P:/K;S@CM6"^82FL
MQ'Q#87L\(Y4'3_0R>%+7RKHM"9,P([6.+U9!.GQA8(%\0K'>X@1''BHI`V:%
M<*J/HJ6J6/6!9LWJ57,24"&29D;1M0!LF^@:&477@6]KP:T3Q8G>J"586-'^
M"5$<7RZOE,$7SQN2'\5M1MA.HKAL7XZJDQ\2;O!>K7AY-;N.#:6T".'J[/;B
MR\]?KM*].5=!MG/O9''6->B4_61[8]$GDV<UZ7'8\&KDS,1.O#A_3)B%Q-:Z
MT"T<C>X'7$Y@9\EFG/Q3T\U\G!W\4<EEV>ZY@Y[8@'9I/X(:S_B1[:/%OK#%
MN6+)TI5D?]S2_C/(S>+PY:!G/P#5?72>Y)3I_K%LXQAD;=-D*]+2!K(4ZBL;
MQ>;;I5+7K)6%HB9" ,2W%Y$U8\]JD4J*8Q2:L
WSFCC0OHMWFWTG2ICC57
+V^Y
MEZGX-N/%/+&=GZR6L5MPAPL+!.OR[7U\XV-VMIOX-CN9;7[XVY!O.4TS9N%:
MW'A^EEM_3HXX5)WSTO-3'8$X&?X'$@4BO0CRZ(Q*?E#<VU5=F;?+QFJQ%XS"
M6:MTNEZQKB^F'%\)1%*
Y,(NHQ8;*"F9$+3947HQH=-6(QDL]7"=%N6?.P/GX
MYA9'MX,>%YMB$I7",P"@L]BQZP>^F]64Q$N ,4^>P^4SKRBEKQ"=?/EWH*:S
M*/FE("NV)]-D0V^V7SC9:<NM+T?6YFLO6:K7%C,LO.PM&&',P*QE<R0R`>TV
MQJX>B=0YDNK)/\F<TL<0?/Y.%_563WS#4M,Z`;;-;)J5FM:(;P/!K15<+2!I
MO.=I$9)6& #91;'G:Q5;5Q58$8U:98
-+&"_SN/S@A<ZC/:5R5\8VKUS/B_3FR[@KW
M83!9XL#[[#<'O5S;A \;-FP0TW0Y<1_TA&:B8"A$[:3B1P%P-C$"3C)D*$-W
MO.CN`&%=F$BV`&]5^L%%&-S%0A+^G"AX,H<-.8^ ?-!;[EZ27/2>(_Z0JMQK
MSD.AK[3->*OT;H=3;YKS"VG(Z;AQJJ)<@XN-5KZ=GOU^?G+V[?9D<#[X<[W&
M/H*W#I_/R+2_*/U#4/PD5\Q>]-_1_-79"1B)G.:Q=.@*4W#FQI)>SSNO)+1F
M6IA_]6'2UF8"XQ3DDLEY' *HE_2VF=CC^YDOTD9X]$
%OL,+>GES(0D.AF>GB
M0N2(-8O1QL6J)=GA%;+#-16KMB2L& #91;BE'MLCC=0LO;ZUDH
FZEM#3AD8)(3NA6
M(91:4IX*Z:\AYZF0^H8
F/;4@;)WI-#/MJ0/@KO,>LF)'.1/U>K5+?&I-?!+)
ML!62Z3*? %F0^:XNO2WV:E_HDPL,K
A%=W[K,I93N=J<\?97DW#?]VIW;D>_;C
MR%D-AL[/LU0I[P>2!T,YEF(_D&W.L[3'\9$S/ ,*DLM,ZWPZ1K8#(F@+Q#
:'>
M`I6B6Y0642DZI37W2WE
E!5*.>+5X> C$G7F4M7TB^INB8N4(AF
:GL9E)L9U&Y
M3$!5=4I[N_=@AD6T$C:#O'F?_>]7)XOVOS+20CD8-E(UNB[5Z@JJ"T-3/@L?
M!--9%LKE?S_EOQ<+F#@""Z5^CW_XKBRR]N"N(T+D[#H>,=VY63BQB. RI@UL
MWQT?BC"8Q\> ]Y9T^=X)):9CV5YRXJ#0
2&X[XX7SP(P3#;ER!U/5BPVS./QV;
MC:ZC+=.OK:!?VYC^)#*LLI/6)LZR5,)(8"D5PY+>7'(9(ET!\>U'"QW_?GTK
MWUV6>D@FY&^^+_DF.XB@`;HG"9DT86F66O9RFOIV+V<_70?VI#;1[ J'3$'H
M*P"T;I.57$@RQ:.MP*)5@.74O??\Y/3JKW8'-7HX.I!6>=86QGB/RYO3\_E
MZZ5JT;+?4ZG9LM8Y4A%)$PY;-2BQMP]*7R_/T< -!0D^K[^DI>FJNMF^,:>7
M!6NKP]_>UFPMAT[L)"NB*^TD:U>WM45+M7*& #91;M7DGMBHT'J^*D%O:
;DT^+&F.
MJ2H\-2_@DHJH=<*1N !J!]0W; %4K0A;IWK-6@!5)\!*.GNM,RE8/L46H*TX
MQ7:]UE['B*^U673F6FR[C"+OP>>E> XA03JR#WK^9AAUJWMM'F
%%VI+C4.3)=
M/#PRU7O3IO8=P:[& #91;G^P@5R]J09\OE*X%
"?GB*??)"V81O/Z9?TXN!](X%5%R
M7.NBA9E8`L+7@B4/XJM$W!<T\1Y&<;HW=B4D/DN^\9J/G 88%BDI-S5(76L^
MMJ6L[E-?2$(_M11B_7][5];;-K*EWP/D/_#A`FG/Q$YMW/3FV.Z.<1/'L-S)
M7*"!`2-1-F_+HJ#%268P_WU.D=1&5FR2*A:+<@$!XC@4=;ZS?'7.J<W>/9<:
M8\:PC5NZ]06O-A(@FC_I'V.***L\&?)Y-.(/]-/I_8O)'9]+:RY=6 $@_/2U
MW.GE& C/Z]#IY1LLS,V?&@%8F)L_->*)RG'C\9E!SN,!\ JXT.4#X+6^SJ*M
MI_>H)!^&T=TLF-ZG-2#\:QGE? OSE@0+U=8,$NBEQ^4))I
22K`\-Q6&"LC>RL
MMNS,+\K.?&FRPP@R#2?)61T)A,)!&& #91;5BBQ4NJ^)R%RZKDL
@.3?6>5&-J-M_>
MH*%^C^0'%D)]@CO6O56
*2)EQ8&@J0O$0[F(O2STL-69"/>9!>KF36_(#;#SB
M=:R7I111YXRCL)?5@/2:];):1=@YU].KE]4FP";/U\3;2_.17<#E(EO5ZO;@
M(5Q _AZ66MU.R D[(4BPN'VK[D"^@U/D]"GD-BD42838)%\D?>R?]F^^;)W#
MU@'2R@D(-:RD\[BY7B8-)RV#_&;\Z? /3>'^6WPIYO&K(_GI]?O\HO[3RSK
M*FG%W8.UUTN"L& #91;T8:9VYVMXH00'Y2H
LK(%]I-:R O/T5*\ 5*,!5I8!!-)K+
M4T"%-N:.#JC "?+'$2IK8^XKF9(V)L:-:A:&B/>7G_O6!%PC::Z?7_6M^WB^
M2'^3;-;:6H5_'SR&Z73!X#Z8W*T6^G_^>G5Q<\S.SI!WROPSWD9?RUJ^2YM[
MBP`D%H30'A=-" )JUFSWJGE=%,D2*DN77=
>=VJI\NX"NGR0FQ:1O/^O"Y?[MQ
M& C4032%)/\*+ %^U;^^FA]MML^E:?/K5_&W?_-S9B,8W2'RP3SGT0Q^$4/E
M-H+8Y<U!KH/53M3'8+R$MR5S'F_X%[Z+^64OQVPP0%[ _,&;Q W2_\KA?G.2
M;HM>& #91;YNVBMNFLWNL(]ZSF
T3)'ME?*=A7KF#NW!^X<U^MG7MKMV*JR=>O*JDR
M<:4W>1U*4-0OQQ@YNE*0:]Q<7EU(&F%V2P,Y&BB5/T/NO#KO8=]*H'7A]\_R
M8423#>0K%"A<@]DW),(G9V%D02F^:.K?<31)S\G(CK=X`QG-FY/#""#>/.>9
MVCV\YQ_R<]02\+$`/E8-GR>J_VB#/QC+G^(&&F",:+5.ZWD,V"]BP'[7.ESZ
MX93<YU(%L)7)"DW J3>9)T#5M0:E=C [:L;?`Z@X_N3\WX>QCA?2=\G0`%)]
MB\9\R#P,.Y;'V5%#2IY(W&V;E0!!!2"HJN99(_(I7PGX' K*+[+)HZ#YBVR:
M6Q!80CXFD(^U? +K1ZD!'KP0$+%(QSJOX%
U<P<?DSF=.QHK^FD<U%3#O4DMV>
ME"':=&32+DYO4[=DW[2]^.Z_KJW?_OG> 1\@E]M%3!^]1URUO0YR_
+3A50/Y
M_T5F1>[V&?(MN3[$BU'TPUI)EWC;&JI$4V&!I%AC4]DN\X^DP:=.$3YU6H)_
MMGQ8\G<]AD)-7/+ G80+Z^+'=!S/<NM(4_UXON-XGDQ7+J.A\J[,K5?>E2O+
M2@2RDGJRIIIL*NR(0*N
D+;];?>A3`!4RWS-A]6'$YCFZ=1,^Q(^0$-W&,,H<
M6Y'B_@;.%Z" )'$WY%$D+QR+\S\,Y^=_
M&(CYB)'(GR!_V*B,QG#8"&3;,HH
MH#S9<.,T1S9(X*OY*W(K$"-HLBFR0;9 4EMCMP(9W:.7"M_S?=OS9485$F2C
MJ'8VRHW3F*<B@:1(8T\E#"%YID+\>(Z\`E#^>([R&0QWI*8($&2U!;+:==V*
M:[(9MT*%/8")I&T5.9N6R!_GE_]IG2?'K?,W)SD6)P"74O?)8;5:2X'_*> )G
M2/>M*NWCVG\+>$DW]9+V6K[Q@Q@D!2UYZ1/#$Z,^/I(%&OE%T/F36K4:G!U&
MJ!S&+XV_/. %STS1!^*FH`O_,G]Y:H;
H&/<KG^U10+! 4ZYWPN4<O&/W3?%+5
M39$`/ ]HCA7(;BBC*#S#,BTIMI
[ZH58*_@D^!H$P@*-/8IZAK.T<O%KU#;>](
MHIL2`?[:;55NFH;< E!4'4\IT3B:09_L2#568
=T/%J<T*(S1X46/45Y@AXZ+2
MNJ)R/3;D4U2@4ZKS7"8F3_=D#QD]L MR'(D115T!_MI-7FZ:QB**"B**UHXH
MKL>F(@H+!,5ZEWS>T4M&3R1&%!&,T<3?HXIL;HPB@O2<.'N(2AJ**"((_?QM
MCWKE/8C)2\^[AM[C&\-E1I0@/2>UTW-NFH;<% N2">SI;"B/VA(-A07)!*Z9
M3*1>U!CU84%,85I;5-!C4SXE</& #91;6EDP\X4JNR\C108(
N$T@>QE1B( F:YK1V
MTSPQ36.!5%A\P$6UZXK*]=A0( FZ^Q3IW.3"KH>/7ASZ3_"6<,(O'$MIA;DR
MDW,D(!94.Y7@%FK$6TEQG01BQ/9U9D#0HS1#\=-W!?B]V@P(7M00`Q)1]YS8
MK#8#@AZ;\BDJ$)3JG9[*JJ(T0W\&T/E!ZT^A=[!GRXPH+,"/]\AXG8;<5-#D
M)QIOKN&KF:@OT5#,%>"O745Q+VJ,^IC IUA=GTKT6,&GO H^)>ATD;K;$6["
M8/@SO6HZ[R_SY(H%>,MD' ?\A'-^$M&,/Y\X3K3U&GX2S_8Q(?QG?K3.9,&7
M80WNP^%RG!X0DGV*.^@\7'\1OZPP'$["^3#X^=:ZBA_#![YQ`9&WZ>:%8&'1
M]$:1GO7JN/QD'3S[W-*HDJ]+NLJEGLTV/95\-MF2`,^6YM"2[TWVR)7#EF8[
M)=^;S%>5U0,K^VRVBKKDL\FL$=>9M!U897V*-T)+@D_6&I=\;U(<E75$OEK@
MF6=%9<>3H9 V/,JZ"V\/E'LV'4W*A]C6>V61I6"=)JF[3M.0I2%+0Y;2R=(0
MH(@`2RR9,V1IR-*0I2%+0Y:&+ U9&K+<GRP-`;X``BRQP4<Z60H6`9"Z.P<-
M61JR;(8L#0$:`LP18(G
%H?+)4I!9(I-9&K(T!&@(4&<"++$"QI"E(4M#EH8L
M#5FJ)TLL6HF+;5.&&[(T9&G(LG&RW(,`2VS],V1IR-*0I2%+C<E2$0'N=T2$
MX4C#D88C57*DX;WN\1X
3\)[I.FK'>X;+#)<9+C-<IBN7&7XR_&3XZ6E^$AP4
MC)FI,< 7\9,C'D(\A'T,^AGP,H1
A"T9%0; &AV(90#$D8DC DL2())" )9$A"
M*4F8P#>!;P)?<>";8#;!?"C!3 6I/K5-,)M@-L&\5S";`#4!:H*NJT$G2'&I
M27%-T'4UZ-H*),%58I@0$T@FD#H<2"8X3'"8X&@X.%#Q!@F,'!,<+RHX7J#G
M(]'%2:CNQ4G&\P_7\XTWOVAO-@Y8S@%9,9% S"02S3K@H3L5%; :-:RFA-6,
MA[Q$#^F&U7'Q@D:$L;&Z.JL;2^II2;G600+K(&P6GS:D<>H+KIZE/C,:KZ9Q
M%U&G['6_H'.,BCK'N6GH[+)?ZRR>+&;QV/H43 +(NS.U<Q6_#P9_W\WB)2B2
MMSC&XXC;Q;J=!9/Y" "OWC#/_@YY'R2[H'FVG$RX<4!_B_#D:60VOWSXUCK]
M\_;#YYO+VW_]U?]7__;BD]Y@^?7'.Q=4S_GC`0< \6X!O)=]S(LNDGF!8H5Y
^
M6'D>Y=G*Y]_/P/W@;Y'MYHMX.H6?R]BN$@0D@%#94*?3Z1B&EX0//@8_`<,?
M(.;WX*<>_J@>IG)/E(*OWS^_MLZC^0#H<W9@MGL&6S<-=A4NOL>SOZV/<>:5
MI]]AQ(51<&[]=O7Q].@P3%<:93>-^'LP7UA_<N+O?X\6@WMN&SXF@%#?HC%/
M4@["BN5A=M.,M^'L(9I B94].M_/; X(4P$#$J0B^1KJXA$D^1
C?;0F=_,H:
MQW>[RN>*#H?/B.<W*]ZG:#"+Y_%H8?UV<[1.SOG/]@E\U"(@PIK&KR%3M(CU
M:3E>1--9S%T',OK?9^%S.B& #91;O)ZY@KQ1U\WNE*N@
X2>BDN;';HZPH'F55W7BE
MZ*S&VS<=Q7[ILM3M$;>(@+CURM+^FD!Z:TP[I)+5D1F@?.FZ^= ?X6093>";
MAH_!9 ':LKX$XVB8?LMM#$I,JD6"*3HZ2$4\42)[S,%'\CR84 %LVHP'*QL_
MFX>U]WA9H7?D"A8Z`IJ7M-#QN7B 1S9C5]%J] 1+HPF)IMB;)NIC9M1UJ[!$
M"=17BRR@>&*0P=TRUH=X,8I^6"N3)1&TQG<B3U0LX''\"Q[?U=:NR)O_VY(<
M,BCZ2,K+7BG*B_? G4O=%W9^K:M1S1'F;4SU
OZT1CN"VP:BM*A[M1`26JWFY<
M+F(NP2!SQKD4X^F"0:U-& #91;)Y=V'M+;=MNQB95N
O6V1AA^;9-X6BJ1+)^]V()C
MH $,:RE[*> A$GN,53W2D=OY$1P5D\#
V8\?_BKRPI/:1:7F&J&/O$*TP54W(;
M/83\J4S:!?QS+> ]>-4D7EC?PG!B!=_&(1^DYS\G@_M9/(G^)TQ#)I$S^>#K
M5WS493ZV";P#W&XXA\\. @B6,YI,82O%XE'PD^9+I
+'Z,AN%LGGS-]E>\?I7]
M'SCP<I[^,A%K$3Q,3Y)T)/O2P3@>_,T3BN5D2RQ)O1GN`'P/\NFV%A%X`$5=
MF2F4"$'GF< )68"H<!B7BTVZF4!VV;AJL\9E"]9!TGC=KPW(R'%,+Q%K.%$K$
MU]I,88*!"# 0I,-,85WQ-)@I]-[1-0;$&_YK#,A#%#"@3<.?,-43A5O2(2CL
M25XZY""R*]WS3OQY-.(/]./E#/ZZF-SQ.;)&\]%M%&@G%#,4:!.*95'L/=NY
MJ:H(JLB=:SRL9Z,>SEN%V5 J[N*YGD5)^4M6/X.\Y[,(TI2M[GMFF/-XL'S@
M_G3YP.<LO\ZBK:>WNYH@\@_/L;Y "05V.*:)TP5#WHR%I]+Z>'AB_1Z-PWGO
MV'H81G>S8'I_,AR/W_)_+:/<CU)LG.@$"732H*<VF1HH!];XT+B%B#D][.<1
M,0?[51'=A \Q;_,D8O/G)N$@R7FR1YMM@.80>0)$7F.(5-O+$:!SJJ*[#<?A
M]#Z>_%1JF(9$5VH!QN]ER,-@FWL9Y Y@BIA-`:J]C<0(PN6-1%D1SF:Z*H5S
M.YA&TRWALZ;B,%Q J"<&"!;6)*OB@F$PY0/Q7^<77R[/+OZZ/;N^O/[O_R6^
M?4%=ZA_[GD^/F>OYQZ?4Q\?TO?W> )_2<7M#S_TO #U(*26<ZN6VS-[]]_8K/
MG=XGL'1(N*CMC7AP,=
6/ UG:>W(6QK;GUK)(\NM4<\N1B>R'>5Y66T(!$9G
M-P\!?G(['9D*4*FD3^SV6 $.=EEE.&H[ZCD$C@!!Y4C1KZ'>+DK5;F@+X%4>
M[S1II[<`K9/FTF[;3:L@.VE"_28/VD7922-*;J1#0D0J0& ""*V6!D/.LJOJ
M8#2+'P3U`?]-]D5OYNNOAH^-HKME5B2L%U+,H$8.YKS[=SG:?A>\*I/U>[:T
M8_NKW\*CT=QZ"/BJFR$?M<,4:+1(7@T5R6@Y2;H@\.K7KZZ3+TE\+!@LK)_Q
M<F8]AI!FIGW*K -I#9/6Y7R?F9!=`U)!9D*=VEWZO2="]I9.BWD0LL* 7'Y<
MX#8&?JZ':[<Z#[*1KC /PJ6K,0^BNH+808 %"+!^%81R2-KDT\JAM;$(H%VG
M5)"Y[,!#`GCH`" J(%D%VTH0Z5A!MHNRD$9
57$!L(=L_V"A!LVS,5A-85Q(X!
M;8$![38KB#VETZR"L'N$%3$0ID<%`65:4<,,V]VI(&0AT'$.8@<E$Z!D!Y*2
MRH*G8<VD")IJ< U$!)GI0%81RD)TTH=X5A
'J4G31BBQ4$XP>0%B%@4T%TI(*
M/\42D"%/CPJBEG2:51"T1]T"!DK=YBJ(*@%,1?D-Q682L<T`KC*($'Y26]Z
MA+@'D'LK@J9TS =,M@!3ARIV60CTKMC5HU
3MADP`C^E7/RB'I'55JQQDVY.Y
MZAVUDW&H>#]W#@(60,!Z5!"UI-.L@L ]N[A."- M$CSD(S*^F*TA'Z0$DH(
J@
M*64<P"1P)MJA16>R$.B=@*I'J=H-L0`>/JAL33G(3II0[SD(]2@[:<06$U#<
M(\4F,2::M+!K2:=9`HK
X$9QY#(AA#1)0VK-]?L;YKG34]G$G=TNK1*6.9P".
M4USG0VT'VUVO$M1!ZZ2
Y6JH2)"+0N$IH!66K#<$4,1,@9@>04[>!KMFVO$1$
M&E< )K:#LI%NV526D$+ `@@YMZKK2Z50E``8& #91;OQ\]O4V!Z5$EP)]B
/DWMROGT
MU9?+\\M3GJ=-QS \9J=9/I4+2+N)(P?'$<!QFH&CE&Q(L?-);5*]\ZEAJ: (
MFFIS80$FW)U2018"O4L%]2@[Z8:ZK&B1"$G?.9(V0+9=P*IWU$[&88NE`LF?
MGI] V./T?*FE0BWI-"L54(_X!0R(^'J4"JBX[IA+YVI_@NP:`O-ZK)!H,H^1
M3L^)*$"EDBH!3F%Y$<"A]*!:8RV@[*01)8]WU2 05(1 D)97)]1W0\4@%7NA
M''3R;E-0+KI^[1Y5T)1ZFIN_E81C<JO?2O*TIS62%-GY`^BYZ#9R.].IDH9
MZTY5"RB51I L>#JW==2#;+FM(PUP,Y<"Z8#L_.SSIR3R(!"OT[8"A.5R,KB7
MF35A;%<(1"(`EB\G;S)H&93T>R$/!(:?A=9#/(G@!QY37/9PPF_Y'EK@J5!9
MIIN]YY(:4UQ@)! 8:=&8JB>=FL:4S<J"@#]%$)054K;%<G4>0O+SKL]&65]A
MN ;T;1F-APF8)WT7M.66E12)PK)PG<Z'V]OK3%#P6-!CRJ+\0())\!#.IP'H
M-1J"3:)1! )_^VG]>?/1FL["4?3#NE\LIKUW[_ZC1SS'?U<,SN2.QJ=UCW%)
M0- 3IT4)3D#KT^:8@C!'O+S
_W$T 6/QSB_*IOW<?S1?J;>+0ZR($W#4+K/G@,
MTW,A!O?!Y&YUQL2GT[,/EU<75Z>?+OB]5CE9GP*Y==C&UDL2=-FULACW:')?
MZ/46/$PH18+S0J-@G('[>A^-0^LQ&$=#^"Y@F.3XB;_.0QX-?Z6/HL0JLS!(
M[,'C&WYI3>/9XBW\<Q2-XO1,C>RHCA.+:RS]=00$]2VTEO-G.< NB1 [1818
MV7GVLD63R$W_#U!+`0(
4`!0``@`(`(Y,<C/VD,WL8RT``(/G`@`0````````
M``$`( ````````!E=F5N=&QO9V1A=& $N='AT4$L%!@`````!``
$`/@```)$M
$````````
`
end
| |
|
| here's a sample of my file. errors start on line 24/25.
you can see that the last quoted field has crlf's in it and that there is a
final matching double-quote. yet it still separates.
it's killin me....it looks like i have it right? i went into access,
imported it, and set field11 as a memo field. yet it reports there were
errors during import.
HELP!
;-)
begin 666 eventlogdata.zip
M4$L#!!0``@`(`(Y,<C/VD,WL8RT``(/ G`@`0````979E;G1L;V=
D871A+G1X
M=.Q=:V_;1K/^? 3X/RSRY22 K>Z%]P'<&RG<6L[@NTVIT" @A9IB[!$ZB4I
MN^Y[WO]^9I>D1)&*(TO4DE39I*UE\3+/W'9F=G?VW<U+%+N3=X?O//\^""=V
M[ 4^?-(QT^!_\!?#OX.3CX.3\UM,X6="?B+Z3Q1C%>D6U2U%0<>7'O^&T*(
MCG6J*TH?BW^.&.;WW& #91;CADS=TT4G@QV$P1I
>V;S^X(7S#X-_;D8NNW4D0N^AX
M.'2CB%_GNT-.2G8IBM)'N'[LAJZ#8K@IG/F^YS^@*+9CM__NH/?N^VC4!,:W
MP308VW[TZ#4/VK,=H6@F+KN?C<<O\(4?(YO#"V,T3%[P`YA2A7;KCMWI*/!?
MMI:.5+)O;DX'Z-2+AL&3&[Z@[(8J-.SJ%AW_=OOYR_7Y[1_?;OZXN3V[; JL
M%FI7./%\>YPAB5HOH>\C:IUP;EXF-DAAB([]V/O="V=1NWS \70Z]H;B[>C"
M?@$O_#-0^&SOCSM8'V'KE._*C9^#\!%=!"F^XV<& #91;='T^O+Z_NCC^T'K9
K0UP
M:]$)J#_$I5F,E7!IC"WC^LKHK3=Q<SAB^#BGU8N0'SRCZ,4?CL+ ]_[FTN"2
MB01IR<7/7CP2O^2?#GI1, OA5GOBQJ'GN_WI\*X_#";HO1]/^\[_$9WV*?SM
M,XM0=O0_Z6>E3S'_Q8?7D&N 9#WLF):Q8[J,_>P)&'\1/.3 BU^A<?"P+"TN
M&=?Y`67FSBB[](9A$ 7W,7I__0%]]7PG>([$SVH?DSZ"!^"YAQC8PT=$T>5L
M''O3,.!J%H3H4^BZ/Z#_%7>@)?0#\:JEF&B0HU\C!E85<V/.!M/IZYQ]W5&E
ME#&+FI9""Y2IU%3H-CXX^7;"*9>5RT@'M.. 11,LY6DJ65%_CCI:2UJ:
=-4)K
MG="DI)W5D]V(M%,ZK)U&*&J"1K548JG&DH-3B:X2U9 5H1Q?GMU^!L:O$Z$0
MK4]PGY(5(0J$>5SP`A[1V#K(L<5P"3EF>!GYJ1\=3[GSH2GP%-*][8VYT@4H
M=!\\^%6(1D$$P0$$F:&;@@O=81 Z/$JXCCX@$,Y!ST\C5-NQIW#304^P)7+C
M&,B/K(,>_X/0<?(UNH((#EGHW]14SYC.S"/3,-F1HAOFT3$SR1'[J'XT*3ME
M9^ST/\FMGSD9Z7W U.G0BS%-OAJ$WL0&73L- )K;GHYO9_;WW5W(9YWUR
T>G5
MC1 LO'T,P)"5_!JA_\I%B8<H+Y#DBANNH+. I`Z;'^9(^PTJNY'^2R\X
'@,X!
M'D7O7>#*_/$+B2=,X,P.73L"SYM3I6$P&SN@;?&"[_!M!&[[.A(V<^<.[1E\
MAM\>]')8,H'!HU(:0_=?,S>*^XB_:<*Y-O8>7;"TY '!/5SL10<]T.YX9,?B
M5GL6CX+0`_?B/;EY5O&'>6&B$6G$)VY/7W;02]^&1D"C#3$8!(@@@NG8!CU)
M(?X=^.XAO_O.O@,R,B2V^.*@%X<P$-[#N^"I_-8P>.!<["?L^B.8`>$^FMC^
MS.;^(H30_T60F' J3*(/`<M%!3U$MN\`TCB:JR*Z>T'QRY1;\CMO"O[FWGM
M/ V5,=_SH'4IY`IH#+W4X0
9-I#.2<WPL08W?"@TMO/$93-XS@OD/AM^QAC%[
M0/+L@^@XHR@1-/#==B:>GQ >A-N:N[+*W)7.W#MS[\R]\>;^EOAS;O$,,F6]
M:/$,@K6VU=-E(MIQ3E,]%+GU].KI;UH]O4Z$K5.^AM73:P2X@>C>'L,QU:)F
M"99*S2Z& ZV*X+H9K4PSW^B32PN(5
BRHEBU>H4M<DTI:4U3Z)M*"?64JI\,>8
M8M0UB9121JA%-$LMNGE*--5LV2R2?$0[#J"4^0PD+<87"C$P?7M\T9AII!JA
MM4YH4J:1JB>[$=- (TF'M,C!7YL559C%:`*,
KC-$N,.\"\RXPWY.Y%"47.S*E
M:.X,@L?.W#MS[\Q]?^92YA9/38NPHL53D["VS:7(1"0GL*\0BMRYE.KI;]I<
M2IT(6Z=\#9M+J1&@E)2-&A;32K ,IG4Q7!?#=3%<FV*XUQ;ZYNT=X[*]8]RR
MA;YOF49:@->+B_\X>+VX^$_>--*6E-4^C;2@7[-4M42_IJIU32/-*<,*WWM7
MH PKC+5L%DDZ( GAAVYATU+QTBX*!>O85+OEN%WXT84?>U8QYK/?EDH*YJZI
MIDHZ<^_,O3/ WO:L8\ZC08F6+5QEI_Q(
1^=!D+1&I#)G< )2*5D=VL)2*R8+50
MNQHQB20%4>N$4\LD4H7T-W02J1:$K5.^9DXBU0%00A4'8"GPMP1+4;N%0%U:
MUZ5U^S:)).R=&&5[)\;^3R(!> +%CI@A^FQTSU4PB;4I94
R:1@'X*$$KT4Y55
M.8FT&-T,3,GWJ:+S73N*4>Q*"?]3C&)7RH_77[[>G%WGAK>[$#@)!LEIF?G@
MA]QDC(M#SWWBODB,">!$$L.-T#U8O5#V[,Z)+;SRMV\06PR.3KZ<?:*9@\M,
M_-NIRP%_@XC@X^V?M\.I-_USO2&NGXP+X%)M)/PRA$-A".(<!HZ[84A ,ED"
MWPH3FH088('=Q$X7$G0
AP;Y,[)#<-B9(; KFCBGK)G8Z<^_,?8\F=LB\;Z)A
MD>(`KZL&P6VKXLI$M.-"6O50Y%9QJZ>_:57<.A&V3OD:5L6M$> NJ[@+6'IQ
M82&'I1<7%G8Q7!?#=3%<>ZNX"WO7X&_)WC55V^,J;AX\U<O@J5Y7%7=+RFJO
MXN;IQTJ9?JQ46<45A4K^AA]S5+&886&U0)'&#*Q^3]%)7M&!04^>PT>>>'HR
M]CB)H/.)^<]2_V8/A:]+;A!57/!/W(0G0<C]E# 8H?31(8R*SRZW<%]<DSB?
M]$L$PS\:SD((`F)P6+8
8\3WP&WUTT+N"]\0`?QKS5V9^PT[O!1L#MW('?MMV
M7#ZR(J(B<!>SV.4.<4$\=[=^D-T%[X>WS$(Q1 &9??2=*((JN^"TB"$X=P8E
M+EL(`#_98\_AX< ,T\,'QC\1PYOH\CG!AO'
$29CO)Z)W&06-X2M&U@.^\YT[=
MR%@8Y7GHB2$/I%I^4,K5@Y[C14,[=."58KC*B92/%#GE$'?D!.6D"Z[@)A[L
M/*]XB0#Q//*&(Q$FS%VINZ6/URW%+)Y20;"NF,53*O;G7(<%<KVX)H$CU[LU
M"5TTVT6S^S8!`9GK*G-GG;EWYMZ9^SY.0. BB^Q@M67RIV6!#:]P5TM
^8G3$U
M0I- 3VZX0F92=,3NPE2;LC)$
.JX7:U8@Y52F(6B><ALY)UH*P=< )KYIQD'0`E
MS$D"++HJK:-=6M>E=5U:MT]'O2PLGA0W,7"+)_5MK]B2LJ9,S.F\@R4VB_13
M$YMU]>C"\Y96S"++,]&8P*U$:UF/+NF =CD&IV ,WJ.++8_!&!O8[-J\=V-P
M-P;OS4P*SH8)%<Q=+9B[KII,[<R],_?.W/ =G)F5A\:I%RA:O$K6U,Q
$U0MMQ
M1:MZ9%)F(JHGNQ$S$=)
AM5"[ZIV)D(FH=<*1._-=/?U-FTFI$V'KE*]A,RDU
M`I10Q>&KXRRFEV I3._2NBZMZ]*Z?=G=E;=W3,KVCLD>[^Y:@"_-AG/PI=EP
M>9-(6U)6]R22^=U3T+"YZA0T:7-(9K;SB&B%HZ>!, U&QC>O?_@"8P1<< ),H
M\9G_X/FKP\B4]"VCX@4`PF?GB@!(<7;NQP`R[3CW@3*QO6@KZBE-:#=>H1T3
M4(PB& #91;9C0`NT99;\EX]'Q`
Q"4$G[M)L'.=3JL6.B6;\^:3,=N+,8V& $$G"6G
M?A^,Q\$S=TG)J!,=9@YZ.HL7F& #91;=X@)(8L'!5,);,=\
99J'>4T</WS*72!Q0,
MO?_UHXEUA>@?X)H;=SB#<? E?W&&YW'_%K#U!2J?"@\;Q:/@^ Q>> O,_\1
MG4$H,D:?O#$G,'V%2?EMV>,N;0CYO0"2L1NP>!XSBNK3$Z2<MP&(_ A=!4_N
MY [N%_P7[\8&PQ]>$2,Q98CQ/" ^DFWE(:\VQ+86YJ4A3C2
P*TVH$0XA29@A1
M:F+()HJU/0N6=W0F+"CMZ)3%@K7M\!7<D/3H;\D-EYB!5S"CT/CC*DZ]-!^)
M4R[D:/P<Q#P-R2@5X^ <=G];> 6%+T4HD8D5K@,JN]*U;#
YR N#SRPSMV-_+O
MK @A&=-N2T9Y,+3L0C!5=Q/92)'.K@%M()HU6B*D"+@7X\MJEQ$`T<5EM5U'
MA T[(FS.Z*XAPBX:(IC96C:>96GY]!M#H C_U? :T'X*97\1G%H%CDYE=^;
<K
M_W;EW_U8Q&?FU_ 5K9VOX>NLO;/VSMI;- =E#C!\E_3IO2+I\0H4P]
]()%>LF
M_=>N[;Q80G-*%581C\-3_'%@B]C/Y]$H7"\"['R1-HT@Y\58_O,\CH^&(]>9
MI4XFO2O5]>Q%0,A7U_'=R+%?#A<5/FP> )E4^$)"2E&/^.47<3A=:HPO;BE&S
M%%H2(Q#4B7$S,6XK#Y7
758OR4#>MJ^ZG/+8L%0HNT& #91;+S4JGRULK:1WOX^!
&
M,V#=N1^[X['')8%NLRBCEO6!]<.44O%-EM#I97Q$;^N&@AJ1M4UD,K835$]U
M$W832$?5/ M6J=2^!3$!M$XW4G035D
]^PC01U`FR;YC5K&T&-^':XB\#,;R(H
MUY65KJ[<U96[NO(>M6,R\\O56<G@&6,U+:3?DK"ZU]$;V3IZ1;.HL;0NQ""Z
MHE%C%X>D$)RP=(U$-R60$(L2BRT7O Q"*&&%@M?IR9?+='T0_[%PUC77\IG/
M`X_<>HAYN2KU3K.(VXL-&6-J9HN51 <]8'P<#(-Q5#$T904TI>W0^-K/8MAA
M$*QHQ;!C&VC3C)8:T.&BT7-TN'1"76O1D17HR'Z@8WHQ= 1T/#K;#W0:C$@E
M=)K*]@7=\J:U!%UQ.7)]Z-Z0@1KS`X(4OMME"136%87*WW"U;AJ6)YV0,NFD
M.VV]2\.Z-&Q_6G0M#)Y8*BX9/%%QNQJD2L>SVV)F'@[6RW"POO%0,H$OT#'?
M0Q%Y`MS[K^>R:YGUP9,D-J;PDU8+N)A"]8;O&5\"P%8`8(W9^O86IR 'S0[+
MY'DDA):1$-K%9UU\UL5G^Q>?E8X&$ 9?.AJ@\5M<90*2-,A3L[B0UN"G'BBM
M/ 6:O1F1M$YF,M6C54]V$M
6C24;5-M:0N>-J%9=2ZE$XFH+9I5L/6HM4)L&VB
M:]9:M!KQR4BRDU:$)52
EZ=(NR>Z2["[);FM#VX6Y&ZN<F%':$-GTSBVYB7BZ
M%FILEE$7NX*>CH;37)<FL% [L5 T!@-T,UN'_U"Q?2_..?,3.TSZ8N94*KD7
M8\(HO/1$96?S3D,'/<?U/; 3KE[PF-//)X-,"?+0T?O;[-N;Y-MT#."_NCH^
M^15-X!TPP&S>[W> )2_H*+NDUK5+<DK"&K%+4>;>D\A +PW-=W7X7A&&+EN8/
M" ::X]44=0$:,,C)BM+VH4
QDPJ44=3K6^@FJ]U44=6
:@DJ1;6^2;U`ASX@]M:
M%9$`J&VBJ:?>5AGY32WJU "P"LVK&>PNZR"UJNEN"UCKI'E8Y0U3BU#4[S=,
ME9GFI2E4U>>6Y,%3M0R^V%A8?AZS&6%UYS%Z0K[&#P=1EALVZ\0@FJ+6E,<L
M",- \)U*1,,R4F@_]6)MZ4F8
K;N^YL4O(5LB%*"W-PJH'MG$6ENN?C=\RBN<A
M8*,,`1<2R4'HB=9;-/L9F'T:>KP0]7D`(0J0_8L;(P4G/LB#V'AP<H&TI0YB
M0-U?AH9^Y]7/P#]B0DRVP& #91;MRP55)9=CI\^9O;F
0=P8,_?J*4_MP_O;@XS#Z=
M+7TZ[P\N3W.?/E\,^*? 3D\LO5XL+;R\9G7\Z_G2
:^\1O^W7ITR^%%^0_?5[Z
M](E_JE@<V+146A0'-E6ZH3C4ZL0QFM[=8TP?^LYX?)A]<I<^>?WIQ,E]-QI/
M^2=G. G\Q87Q! 20?;+OG> 13]8Q4E#(CBXT;UV7DQ6
N<HS_@W/7QS>EIHCKB
MQ]]2K0*1J&>7-\O?"!4>_'*1:O .V()7L 7_P_1K$V_/@VFMQ#M5U5JV+%$F
M($D#,2 ICV*@G$:- NP\WM5#%8J0$16'D'^ZX
E.(I,8(MQ9RI<URK>(>+!VUQ
MWN$-RH8-*+M+1R7+A54%IS&CR^X!M4TT-<^(R 34-M%(G1&IGOR&S8C4";!M
MFM>L9:XUXMM:<(2J/ZY? J_PXGU(HJ:MF,90\Y6OM
O+L9/^CXPO,?>1_PX2-G
M>G(26PKQR[,/<>+(FV9+"9^"\6SBHO-3$5.>68M3Y9; #<>V-^%A9-)U?G$7
M7R09)2O"OD\"/Q-P%@<< ^C!=WCBUO1#=0TR*QG!I
=,A?-^*GR=V,W#%XZ%$0
MQL-9'(D.^%\NSK++GD= &B<U"B:Y):9!E#Z(+[SDW]R%P:/K;S@CM6"^82FL
MQ'Q#87L\(Y4'3_0R>%+7RKHM"9,P([6.+U9!.GQA8(%\0K'>X@1''BHI`V:%
M<*J/HJ6J6/6!9LWJ57,24"&29D;1M0!LF^@:&477@6]KP:T3Q8G>J"586-'^
M"5$<7RZOE,$7SQN2'\5M1MA.HKAL7XZJDQ\2;O!>K7AY-;N.#:6T".'J[/;B
MR\]?KM*].5=!MG/O9''6->B4_61[8]$GDV<UZ7'8\&KDS,1.O#A_3)B%Q-:Z
MT"T<C>X'7$Y@9\EFG/Q3T\U\G!W\4<EEV>ZY@Y[8@'9I/X(:S_B1[:/%OK#%
MN6+)TI5D?]S2_C/(S>+PY:!G/P#5?72>Y)3I_K%LXQAD;=-D*]+2!K(4ZBL;
MQ>;;I5+7K)6%HB9" ,2W%Y$U8\]JD4J*8Q2:L
WSFCC0OHMWFWTG2ICC57
+V^Y
MEZGX-N/%/+&=GZR6L5MPAPL+!.OR[7U\XV-VMIOX-CN9;7[XVY!O.4TS9N%:
MW'A^EEM_3HXX5)WSTO-3'8$X&?X'$@4BO0CRZ(Q*?E#<VU5=F;?+QFJQ%XS"
M6:MTNEZQKB^F'%\)1%*
Y,(NHQ8;*"F9$+3947HQH=-6(QDL]7"=%N6?.P/GX
MYA9'MX,>%YMB$I7",P"@L]BQZP>^F]64Q$N ,4^>P^4SKRBEKQ"=?/EWH*:S
M*/FE("NV)]-D0V^V7SC9:<NM+T?6YFLO6:K7%C,LO.PM&&',P*QE<R0R`>TV
MQJX>B=0YDNK)/\F<TL<0?/Y.%_563WS#4M,Z`;;-;)J5FM:(;P/!K15<+2!I
MO.=I$9)6& #91;'G:Q5;5Q58$8U:98
-+&"_SN/S@A<ZC/:5R5\8VKUS/B_3FR[@KW
M83!9XL#[[#<'O5S;A \;-FP0TW0Y<1_TA&:B8"A$[:3B1P%P-C$"3C)D*$-W
MO.CN`&%=F$BV`&]5^L%%&-S%0A+^G"AX,H<-.8^ ?-!;[EZ27/2>(_Z0JMQK
MSD.AK[3->*OT;H=3;YKS"VG(Z;AQJJ)<@XN-5KZ=GOU^?G+V[?9D<#[X<[W&
M/H*W#I_/R+2_*/U#4/PD5\Q>]-_1_-79"1B)G.:Q=.@*4W#FQI)>SSNO)+1F
M6IA_]6'2UF8"XQ3DDLEY' *HE_2VF=CC^YDOTD9X]$
%OL,+>GES(0D.AF>GB
M0N2(-8O1QL6J)=GA%;+#-16KMB2L& #91;BE'MLCC=0LO;ZUDH
FZEM#3AD8)(3NA6
M(91:4IX*Z:\AYZF0^H8
F/;4@;)WI-#/MJ0/@KO,>LF)'.1/U>K5+?&I-?!+)
ML!62Z3*? %F0^:XNO2WV:E_HDPL,K
A%=W[K,I93N=J<\?97DW#?]VIW;D>_;C
MR%D-AL[/LU0I[P>2!T,YEF(_D&W.L[3'\9$S/ ,*DLM,ZWPZ1K8#(F@+Q#
:'>
M`I6B6Y0642DZI37W2WE
E!5*.>+5X> C$G7F4M7TB^INB8N4(AF
:GL9E)L9U&Y
M3$!5=4I[N_=@AD6T$C:#O'F?_>]7)XOVOS+20CD8-E(UNB[5Z@JJ"T-3/@L?
M!--9%LKE?S_EOQ<+F#@""Z5^CW_XKBRR]N"N(T+D[#H>,=VY63BQB. RI@UL
MWQT?BC"8Q\> ]Y9T^=X)):9CV5YRXJ#0
2&X[XX7SP(P3#;ER!U/5BPVS./QV;
MC:ZC+=.OK:!?VYC^)#*LLI/6)LZR5,)(8"D5PY+>7'(9(ET!\>U'"QW_?GTK
MWUV6>D@FY&^^+_DF.XB@`;HG"9DT86F66O9RFOIV+V<_70?VI#;1[ J'3$'H
M*P"T;I.57$@RQ:.MP*)5@.74O??\Y/3JKW8'-7HX.I!6>=86QGB/RYO3\_E
MZZ5JT;+?4ZG9LM8Y4A%)$PY;-2BQMP]*7R_/T< -!0D^K[^DI>FJNMF^,:>7
M!6NKP]_>UFPMAT[L)"NB*^TD:U>WM45+M7*& #91;M7DGMBHT'J^*D%O:
;DT^+&F.
MJ2H\-2_@DHJH=<*1N !J!]0W; %4K0A;IWK-6@!5)\!*.GNM,RE8/L46H*TX
MQ7:]UE['B*^U673F6FR[C"+OP>>E> XA03JR#WK^9AAUJWMM'F
%%VI+C4.3)=
M/#PRU7O3IO8=P:[& #91;G^P@5R]J09\OE*X%
"?GB*??)"V81O/Z9?TXN!](X%5%R
M7.NBA9E8`L+7@B4/XJM$W!<T\1Y&<;HW=B4D/DN^\9J/G 88%BDI-S5(76L^
MMJ6L[E-?2$(_M11B_7][5];;-K*EWP/D/_#A`FG/Q$YMW/3FV.Z.<1/'L-S)
M7*"!`2-1-F_+HJ#%268P_WU.D=1&5FR2*A:+<@$!XC@4=;ZS?'7.J<W>/9<:
M8\:PC5NZ]06O-A(@FC_I'V.***L\&?)Y-.(/]-/I_8O)'9]+:RY=6 $@_/2U
MW.GE& C/Z]#IY1LLS,V?&@%8F)L_->*)RG'C\9E!SN,!\ JXT.4#X+6^SJ*M
MI_>H)!^&T=TLF-ZG-2#\:QGE? OSE@0+U=8,$NBEQ^4))I
22K`\-Q6&"LC>RL
MMNS,+\K.?&FRPP@R#2?)61T)A,)!&& #91;5BBQ4NJ^)R%RZKDL
@.3?6>5&-J-M_>
MH*%^C^0'%D)]@CO6O56
*2)EQ8&@J0O$0[F(O2STL-69"/>9!>KF36_(#;#SB
M=:R7I111YXRCL)?5@/2:];):1=@YU].KE]4FP";/U\3;2_.17<#E(EO5ZO;@
M(5Q _AZ66MU.R D[(4BPN'VK[D"^@U/D]"GD-BD42838)%\D?>R?]F^^;)W#
MU@'2R@D(-:RD\[BY7B8-)RV#_&;\Z? /3>'^6WPIYO&K(_GI]?O\HO[3RSK
M*FG%W8.UUTN"L& #91;T8:9VYVMXH00'Y2H
LK(%]I-:R O/T5*\ 5*,!5I8!!-)K+
M4T"%-N:.#JC "?+'$2IK8^XKF9(V)L:-:A:&B/>7G_O6!%PC::Z?7_6M^WB^
M2'^3;-;:6H5_'SR&Z73!X#Z8W*T6^G_^>G5Q<\S.SI!WROPSWD9?RUJ^2YM[
MBP`D%H30'A=-" )JUFSWJGE=%,D2*DN77=
>=VJI\NX"NGR0FQ:1O/^O"Y?[MQ
M& C4032%)/\*+ %^U;^^FA]MML^E:?/K5_&W?_-S9B,8W2'RP3SGT0Q^$4/E
M-H+8Y<U!KH/53M3'8+R$MR5S'F_X%[Z+^64OQVPP0%[ _,&;Q W2_\KA?G.2
M;HM>& #91;YNVBMNFLWNL(]ZSF
T3)'ME?*=A7KF#NW!^X<U^MG7MKMV*JR=>O*JDR
M<:4W>1U*4-0OQQ@YNE*0:]Q<7EU(&F%V2P,Y&BB5/T/NO#KO8=]*H'7A]\_R
M8423#>0K%"A<@]DW),(G9V%D02F^:.K?<31)S\G(CK=X`QG-FY/#""#>/.>9
MVCV\YQ_R<]02\+$`/E8-GR>J_VB#/QC+G^(&&F",:+5.ZWD,V"]BP'[7.ESZ
MX93<YU(%L)7)"DW J3>9)T#5M0:E=C [:L;?`Z@X_N3\WX>QCA?2=\G0`%)]
MB\9\R#P,.Y;'V5%#2IY(W&V;E0!!!2"HJN99(_(I7PGX' K*+[+)HZ#YBVR:
M6Q!80CXFD(^U? +K1ZD!'KP0$+%(QSJOX%
U<P<?DSF=.QHK^FD<U%3#O4DMV>
ME"':=&32+DYO4[=DW[2]^.Z_KJW?_OG> 1\@E]M%3!^]1URUO0YR_
+3A50/Y
M_T5F1>[V&?(MN3[$BU'TPUI)EWC;&JI$4V&!I%AC4]DN\X^DP:=.$3YU6H)_
MMGQ8\G<]AD)-7/+ G80+Z^+'=!S/<NM(4_UXON-XGDQ7+J.A\J[,K5?>E2O+
M2@2RDGJRIIIL*NR(0*N
D+;];?>A3`!4RWS-A]6'$YCFZ=1,^Q(^0$-W&,,H<
M6Y'B_@;.%Z" )'$WY%$D+QR+\S\,Y^=_
M&(CYB)'(GR!_V*B,QG#8"&3;,HH
MH#S9<.,T1S9(X*OY*W(K$"-HLBFR0;9 4EMCMP(9W:.7"M_S?=OS9485$F2C
MJ'8VRHW3F*<B@:1(8T\E#"%YID+\>(Z\`E#^>([R&0QWI*8($&2U!;+:==V*
M:[(9MT*%/8")I&T5.9N6R!_GE_]IG2?'K?,W)SD6)P"74O?)8;5:2X'_*> )G
M2/>M*NWCVG\+>$DW]9+V6K[Q@Q@D!2UYZ1/#$Z,^/I(%&OE%T/F36K4:G!U&
MJ!S&+XV_/. %STS1!^*FH`O_,G]Y:H;
H&/<KG^U10+! 4ZYWPN4<O&/W3?%+5
M39$`/ ]HCA7(;BBC*#S#,BTIMI
[ZH58*_@D^!H$P@*-/8IZAK.T<O%KU#;>](
MHIL2`?[:;55NFH;< E!4'4\IT3B:09_L2#568
=T/%J<T*(S1X46/45Y@AXZ+2
MNJ)R/3;D4U2@4ZKS7"8F3_=D#QD]L MR'(D115T!_MI-7FZ:QB**"B**UHXH
MKL>F(@H+!,5ZEWS>T4M&3R1&%!&,T<3?HXIL;HPB@O2<.'N(2AJ**"((_?QM
MCWKE/8C)2\^[AM[C&\-E1I0@/2>UTW-NFH;<% N2">SI;"B/VA(-A07)!*Z9
M3*1>U!CU84%,85I;5-!C4SXE</& #91;6EDP\X4JNR\C108(
N$T@>QE1B( F:YK1V
MTSPQ36.!5%A\P$6UZXK*]=A0( FZ^Q3IW.3"KH>/7ASZ3_"6<,(O'$MIA;DR
MDW,D(!94.Y7@%FK$6TEQG01BQ/9U9D#0HS1#\=-W!?B]V@P(7M00`Q)1]YS8
MK#8#@AZ;\BDJ$)3JG9[*JJ(T0W\&T/E!ZT^A=[!GRXPH+,"/]\AXG8;<5-#D
M)QIOKN&KF:@OT5#,%>"O745Q+VJ,^IC IUA=GTKT6,&GO H^)>ATD;K;$6["
M8/@SO6HZ[R_SY(H%>,MD' ?\A'-^$M&,/Y\X3K3U&GX2S_8Q(?QG?K3.9,&7
M80WNP^%RG!X0DGV*.^@\7'\1OZPP'$["^3#X^=:ZBA_#![YQ`9&WZ>:%8&'1
M]$:1GO7JN/QD'3S[W-*HDJ]+NLJEGLTV/95\-MF2`,^6YM"2[TWVR)7#EF8[
M)=^;S%>5U0,K^VRVBKKDL\FL$=>9M!U897V*-T)+@D_6&I=\;U(<E75$OEK@
MF6=%9<>3H9 V/,JZ"V\/E'LV'4W*A]C6>V61I6"=)JF[3M.0I2%+0Y;2R=(0
MH(@`2RR9,V1IR-*0I2%+0Y:&+ U9&K+<GRP-`;X``BRQP4<Z60H6`9"Z.P<-
M61JR;(8L#0$:`LP18(G
%H?+)4I!9(I-9&K(T!&@(4&<"++$"QI"E(4M#EH8L
M#5FJ)TLL6HF+;5.&&[(T9&G(LG&RW(,`2VS],V1IR-*0I2%+C<E2$0'N=T2$
MX4C#D88C57*DX;WN\1X
3\)[I.FK'>X;+#)<9+C-<IBN7&7XR_&3XZ6E^$AP4
MC)FI,< 7\9,C'D(\A'T,^AGP,H1
A"T9%0; &AV(90#$D8DC DL2())" )9$A"
M*4F8P#>!;P)?<>";8#;!?"C!3 6I/K5-,)M@-L&\5S";`#4!:H*NJT$G2'&I
M27%-T'4UZ-H*),%58I@0$T@FD#H<2"8X3'"8X&@X.%#Q!@F,'!,<+RHX7J#G
M(]'%2:CNQ4G&\P_7\XTWOVAO-@Y8S@%9,9% S"02S3K@H3L5%; :-:RFA-6,
MA[Q$#^F&U7'Q@D:$L;&Z.JL;2^II2;G600+K(&P6GS:D<>H+KIZE/C,:KZ9Q
M%U&G['6_H'.,BCK'N6GH[+)?ZRR>+&;QV/H43 +(NS.U<Q6_#P9_W\WB)2B2
MMSC&XXC;Q;J=!9/Y" "OWC#/_@YY'R2[H'FVG$RX<4!_B_#D:60VOWSXUCK]
M\_;#YYO+VW_]U?]7__;BD]Y@^?7'.Q=4S_GC`0< \6X!O)=]S(LNDGF!8H5Y
^
M6'D>Y=G*Y]_/P/W@;Y'MYHMX.H6?R]BN$@0D@%#94*?3Z1B&EX0//@8_`<,?
M(.;WX*<>_J@>IG)/E(*OWS^_MLZC^0#H<W9@MGL&6S<-=A4NOL>SOZV/<>:5
MI]]AQ(51<&[]=O7Q].@P3%<:93>-^'LP7UA_<N+O?X\6@WMN&SXF@%#?HC%/
M4@["BN5A=M.,M^'L(9I B94].M_/; X(4P$#$J0B^1KJXA$D^1
C?;0F=_,H:
MQW>[RN>*#H?/B.<W*]ZG:#"+Y_%H8?UV<[1.SOG/]@E\U"(@PIK&KR%3M(CU
M:3E>1--9S%T',OK?9^%S.B& #91;O)ZY@KQ1U\WNE*N@
X2>BDN;';HZPH'F55W7BE
MZ*S&VS<=Q7[ILM3M$;>(@+CURM+^FD!Z:TP[I)+5D1F@?.FZ^= ?X6093>";
MAH_!9 ':LKX$XVB8?LMM#$I,JD6"*3HZ2$4\42)[S,%'\CR84 %LVHP'*QL_
MFX>U]WA9H7?D"A8Z`IJ7M-#QN7B 1S9C5]%J] 1+HPF)IMB;)NIC9M1UJ[!$
M"=17BRR@>&*0P=TRUH=X,8I^6"N3)1&TQG<B3U0LX''\"Q[?U=:NR)O_VY(<
M,BCZ2,K+7BG*B_? G4O=%W9^K:M1S1'F;4SU
OZT1CN"VP:BM*A[M1`26JWFY<
M+F(NP2!SQKD4X^F"0:U-& #91;)Y=V'M+;=MNQB95N
O6V1AA^;9-X6BJ1+)^]V()C
MH $,:RE[*> A$GN,53W2D=OY$1P5D\#
V8\?_BKRPI/:1:7F&J&/O$*TP54W(;
M/83\J4S:!?QS+> ]>-4D7EC?PG!B!=_&(1^DYS\G@_M9/(G^)TQ#)I$S^>#K
M5WS493ZV";P#W&XXA\\. @B6,YI,82O%XE'PD^9+I
+'Z,AN%LGGS-]E>\?I7]
M'SCP<I[^,A%K$3Q,3Y)T)/O2P3@>_,T3BN5D2RQ)O1GN`'P/\NFV%A%X`$5=
MF2F4"$'GF< )68"H<!B7BTVZF4!VV;AJL\9E"]9!TGC=KPW(R'%,+Q%K.%$K$
MU]I,88*!"# 0I,-,85WQ-)@I]-[1-0;$&_YK#,A#%#"@3<.?,-43A5O2(2CL
M25XZY""R*]WS3OQY-.(/]./E#/ZZF-SQ.;)&\]%M%&@G%#,4:!.*95'L/=NY
MJ:H(JLB=:SRL9Z,>SEN%V5 J[N*YGD5)^4M6/X.\Y[,(TI2M[GMFF/-XL'S@
M_G3YP.<LO\ZBK:>WNYH@\@_/L;Y "05V.*:)TP5#WHR%I]+Z>'AB_1Z-PWGO
MV'H81G>S8'I_,AR/W_)_+:/<CU)LG.@$"732H*<VF1HH!];XT+B%B#D][.<1
M,0?[51'=A \Q;_,D8O/G)N$@R7FR1YMM@.80>0)$7F.(5-O+$:!SJJ*[#<?A
M]#Z>_%1JF(9$5VH!QN]ER,-@FWL9Y Y@BIA-`:J]C<0(PN6-1%D1SF:Z*H5S
M.YA&TRWALZ;B,%Q J"<&"!;6)*OB@F$PY0/Q7^<77R[/+OZZ/;N^O/[O_R6^
M?4%=ZA_[GD^/F>OYQZ?4Q\?TO?W> )_2<7M#S_TO #U(*26<ZN6VS-[]]_8K/
MG=XGL'1(N*CMC7AP,=
6/ UG:>W(6QK;GUK)(\NM4<\N1B>R'>5Y66T(!$9G
M-P\!?G(['9D*4*FD3^SV6 $.=EEE.&H[ZCD$C@!!Y4C1KZ'>+DK5;F@+X%4>
M[S1II[<`K9/FTF[;3:L@.VE"_28/VD7922-*;J1#0D0J0& ""*V6!D/.LJOJ
M8#2+'P3U`?]-]D5OYNNOAH^-HKME5B2L%U+,H$8.YKS[=SG:?A>\*I/U>[:T
M8_NKW\*CT=QZ"/BJFR$?M<,4:+1(7@T5R6@Y2;H@\.K7KZZ3+TE\+!@LK)_Q
M<F8]AI!FIGW*K -I#9/6Y7R?F9!=`U)!9D*=VEWZO2="]I9.BWD0LL* 7'Y<
MX#8&?JZ':[<Z#[*1KC /PJ6K,0^BNH+808 %"+!^%81R2-KDT\JAM;$(H%VG
M5)"Y[,!#`GCH`" J(%D%VTH0Z5A!MHNRD$9
57$!L(=L_V"A!LVS,5A-85Q(X!
M;8$![38KB#VETZR"L'N$%3$0ID<%`65:4<,,V]VI(&0AT'$.8@<E$Z!D!Y*2
MRH*G8<VD")IJ< U$!)GI0%81RD)TTH=X5A
'J4G31BBQ4$XP>0%B%@4T%TI(*
M/\42D"%/CPJBEG2:51"T1]T"!DK=YBJ(*@%,1?D-Q682L<T`KC*($'Y26]Z
MA+@'D'LK@J9TS =,M@!3ARIV60CTKMC5HU
3MADP`C^E7/RB'I'55JQQDVY.Y
MZAVUDW&H>#]W#@(60,!Z5!"UI-.L@L ]N[A."- M$CSD(S*^F*TA'Z0$DH(
J@
M*64<P"1P)MJA16>R$.B=@*I'J=H-L0`>/JAL33G(3II0[SD(]2@[:<06$U#<
M(\4F,2::M+!K2:=9`HK
X$9QY#(AA#1)0VK-]?L;YKG34]G$G=TNK1*6.9P".
M4USG0VT'VUVO$M1!ZZ2
Y6JH2)"+0N$IH!66K#<$4,1,@9@>04[>!KMFVO$1$
M&E< )K:#LI%NV526D$+ `@@YMZKK2Z50E``8& #91;OQ\]O4V!Z5$EP)]B
/DWMROGT
MU9?+\\M3GJ=-QS \9J=9/I4+2+N)(P?'$<!QFH&CE&Q(L?-);5*]\ZEAJ: (
MFFIS80$FW)U2018"O4L%]2@[Z8:ZK&B1"$G?.9(V0+9=P*IWU$[&88NE`LF?
MGI] V./T?*FE0BWI-"L54(_X!0R(^'J4"JBX[IA+YVI_@NP:`O-ZK)!H,H^1
M3L^)*$"EDBH!3F%Y$<"A]*!:8RV@[*01)8]WU2 05(1 D)97)]1W0\4@%7NA
M''3R;E-0+KI^[1Y5T)1ZFIN_E81C<JO?2O*TIS62%-GY`^BYZ#9R.].IDH9
MZTY5"RB51I L>#JW==2#;+FM(PUP,Y<"Z8#L_.SSIR3R(!"OT[8"A.5R,KB7
MF35A;%<(1"(`EB\G;S)H&93T>R$/!(:?A=9#/(G@!QY37/9PPF_Y'EK@J5!9
MIIN]YY(:4UQ@)! 8:=&8JB>=FL:4S<J"@#]%$)054K;%<G4>0O+SKL]&65]A
MN ;T;1F-APF8)WT7M.66E12)PK)PG<Z'V]OK3%#P6-!CRJ+\0())\!#.IP'H
M-1J"3:)1! )_^VG]>?/1FL["4?3#NE\LIKUW[_ZC1SS'?U<,SN2.QJ=UCW%)
M0- 3IT4)3D#KT^:8@C!'O+S
_W$T 6/QSB_*IOW<?S1?J;>+0ZR($W#4+K/G@,
MTW,A!O?!Y&YUQL2GT[,/EU<75Z>?+OB]5CE9GP*Y==C&UDL2=-FULACW:')?
MZ/46/$PH18+S0J-@G('[>A^-0^LQ&$=#^"Y@F.3XB;_.0QX-?Z6/HL0JLS!(
M[,'C&WYI3>/9XBW\<Q2-XO1,C>RHCA.+:RS]=00$]2VTEO-G.< NB1 [1818
MV7GVLD63R$W_#U!+`0(
4`!0``@`(`(Y,<C/VD,WL8RT``(/G`@`0````````
M``$`( ````````!E=F5N=&QO9V1A=& $N='AT4$L%!@`````!``
$`/@```)$M
$````````
`
end
| |
|
| here's a sample of my file. errors start on line 24/25.
you can see that the last quoted field has crlf's in it and that there is a
final matching double-quote. yet it still separates.
i looked at the file in a hex file editor. it is using 0d 0a as the CRLF
which looks purely legit and contains no other extra characters.
it's killin me....it looks like i have it right? i went into access,
imported it, and set field11 as a memo field. yet it reports there were
errors during import.
HELP!
;-)
begin 666 eventlogdatasample.zip
M4$L#!!0``@`(`+I8<C,4WL]LH00``& ,;```6````979E;G1L;V
=D871A<V%M
M<&QE+G1X=. U76T_C1A1^;J3\AZ,\@4
2,KPGV0Z5 :$$B-")I5TC[,MB39(0]
MX\Z,2;UM_WO/V Z;++N RI*2BER4>&;.S/=]Y^+CSJ14FF:=@P[C,R$SHIG@
M>-6WO1[^X,?&[_CD>'QR/K5=_.\XAT[_T+7M`/J1VX]'P8C'#<CCN/T[;[;
M]WW+KEY=SS;V$RKO6$S
A1' M10HCPLF<2ISQ\#M=4+BBF= 4!G%,E3+K.(T-
ME-524,T6E&LJ:0(:C63!.>-S4)IH:G7:K< ZWV00UC8_C7*2$JUOV]J
@MB0)5
M5,MF19J6.,$U$$-/ :HCK`YZ@N56G36E*\X7@
Y8N]LU78D\EP#$.F8G%'90DK
M@^\189=3&/PZ/?OEZGQZ_7%R/9F>CMX*K1V,+IDQ3M(5$[7S'OHVHYUSSJ3,
M"'HAA@'7[#<F"[5;-6"0YRF+J]/A@I18A7]&A$OR_RD'SV>X<\%W2?52R%NX
M$ V_P9)(RLWM=>_R8K"_\[Y[-L$7NZZB^B2O7N1Y#WCU/&^3UP?/G;*,KO'0
M>'F/E2G@8@FJY/%""LX^&6\8SZ@*6KUXR?2B&C17[982A413DE$M&:=6'M]8
ML<A@C^O<2OYR^J[EXL?R(L?UNC\VU[[EVF9@_S'F/63R/.ZV^Y"[[6YR/[U#
MX2_$?(U\-02IF&]ZRWB&)D\@"U\-V8C%4B@QT[!WM0\?&$_$4E7_`\MV+, -
M[/L*,2;Q+;@P*E+-<BE,F D)/TE*G\#_2#GHU?@1?!#Y(8S7\/><(SOPPW^M
MK,CSQY5]O% UR+S(#2/? _0)9X(:^^Y(:7,]F!OFV
GF6V3NB5[R2]M4+K.ANA
MWS.%UG5V]K'S/Z2V<T[;RF/G]X?])AX[MT[K53N4H&831($3!4<;!2YP^H$3
M'&VK0QF,3J=G*/QS.A2G9SFVY3I?:5&PS3..K^@Y/>\YS.W(LQ\PMSU[D_F0
MJT%NBH_;$&\HS0A+3= )D'3.<$C"0BAL#K#)E+0A)VDL9&*ZA"NU#^B<=HLW
M'2I)2(Y&& #91;58EBZ):(WP5M5OF#
3"HI^$2.SB(X$\W#$Z]OA=VPZ/0Z_K]H[ [
M\$*GZQT'QZ'K#;U3;_A
W;7IF8#1V*&H>,VV[]=18LHQ@K U%1AB'23&;L3_J
M94;[>M'P<E(Y%D]/D1A$]3# #VM=X@&L.Z1>,3$!6N0)II[1I=DCJE>:=[WL
M?(SL$M1([5%4Y7[& #91;SQZO13!B2TH45MZU
4(I%D288;?JS[CBKL&Q?J2IG;FA,
M"KS&T79KC<O*8;A5@U'2WPNJM 7FI,RHEK);BIE6;R!FN)
BI=@NC6R^(KDQ)
MH1=",BPO[(ZN2V4V8[*.B*;CJ\R;P]JMYC18($:"/1@VB.B"/"48)PW%3X+3
M`V- ]0VX0QHH)J2;:+2WQ1CC
#LW!78RK%W*AHU7)=BP*
!<\@(+XBI%Q);_[*"
M6"LEZ^ZCHD7ABS@$PA-DJM5]*,)-";K,329W6([U9L;F<+@2/>&J`XTF&#EX
M:&(`9;E&..>SBD1*,]-< LC2%G$J%=@=5W2*QAA(3
9%T^[(Y7B&I'H^XDR1BO
M@0OYTG3WOY;N_GNZOZ?[>& #91;J_T73_!U!+`0(4`!
0``@`(`+I8<C,4WL]LH00`
M`&,;```6``````````$`( ````````!E=F5N=&QO9V1A=&%S86UP;&4N='AT
64$L%!@`````!``$`1 ```-4$````````
`
end
| |
|
| here's a sample of my file. errors start on line 24/25.
you can see that the last quoted field has crlf's in it and that there is a
final matching double-quote. yet it still separates.
i looked at the file in a hex file editor. it is using 0d 0a as the CRLF
which looks purely legit and contains no other extra characters.
it's killin me....it looks like i have it right? i went into access,
imported it, and set field11 as a memo field. yet it reports there were
errors during import.
HELP!
;-)
begin 666 eventlogdatasample.zip
M4$L#!!0``@`(``59<C,M?GX\MP(``. H$```6````979E;G1L;V
=D871A<V%M
M<& QE+G1X=(U476_:,!1]7J
3\ARN>J 1I'#>%Y&$2+97:AU6H($U]-(D#5A,[
MLYTRNNV_[SI.*=M>E@\47]^/<\Z]9K0^&LN;T60D9*5TPZQ0$E<TQ1]\8GQ7
MMS>KVX=-G. W(9<DO4SB.(4T3TF>SF'U!>W.0@A)R2PEZ3R*^VM*8Q?_E28;
MT7"7%=_-GH/ %)1BN7T7!01B0Z@#F*(N
]5E*\";D#BUZFA^:=#\+N>Z-;A8%1
MG<;0Q9>[S?WS>A.UQ38J5 -C:=NH_$EF293@$]&< )'3ZV:W)=43B*"'.<A&-
MPF!THGY@6F+1GAZYIO_
#/,YI_ _SF,9_,E]*LVB%<QJ(#Y0J)FI>@E6@^4Z@
M2<->&0OCQ05:!G*:%TJ7!L9/3^8"L#EA(+D]*/T"K&0M!H5!+XOAUB)\DX>!
MNP$6?AL>&2J7PX\D2^_HC&;3;)[1Z=5LGDT7-"-3>I/>9 E=TCNZ_.5#[QV,
M(0Y%;0MAX\1OK;1HF#["4C5,2%AW526^>S>GO7=:/J[[QF+U&HE![LT`GX:>
M7$5)/('SAGB/-9< 6NK9DECM=AARY]W2W=WM
8(;L2-3)CCJJ<TG]TW(O@Q-:<
M&27/1ZE075WBM-D/W7'7<$")X< ,;'G!.ERC-0S.N+PW#%,-_UG%C(W"5
M&J=:+5YX?02?0%7H+$P8X'3;/;-]*.OL7FEA\9"]\G.I7#*A_42T6A5(KP\?
MBH7!4 WVB)%!K8H7P!:T-<,Y&2B^*<DG+GK+M@CCG0GK-\+ :B9-A;4PJPO5
M:N=4C+Q<SZI#X!(:)CM68[CFUK4:(7JE=/_'X&EQ^&L.@<D2F5IS&D78'L$>
M6W>21Z(ME*S$#B[?12^E&<&@"4X.%BT=H*:U".> AZDG4O,%T5M0UM%P;C)N
@
MK& #91;2LL'#$`W(NG](G1+
[1J#LK&R$]<*7=<?\-4$L!`A0`% `"``@`!5ER,RU^
M? CRW`@``Z@0``!8``````
````0`@`````````&5V96YT;&]G9&%T87-A;7!L
;92YT>'102P4& ``````$``0!$````ZP(`
````
`
end
| |
| John Nurick 2005-11-18, 8:25 pm |
| You have double quotes in the data. As I explained in my previous post,
these must be escaped by doubling them, or they will be interpreted as
ending a field and cause the sorts of problem you are experiencing.
For example, at several places, starting at line 57 of the sample file
(i.e. within a multiline memo field) you have
:its settings by typing "ipconfig /registerdns" at the command prompt.
I suggest you overcome this by munging the log file before trying to
import it. Here's a Perl one-liner that does the job on the sample file,
though it's far from being a generalised solution:
perl -pe"s/((?<= )\042)|(\042(?= .+$))/\042\042/g" eventlogdata.txt
>munged.txt
On Fri, 18 Nov 2005 11:03:41 -0500, "bob" <rb@somewhere.com> wrote:
>
>here's a sample of my file. errors start on line 24/25.
>
>you can see that the last quoted field has crlf's in it and that there is a
>final matching double-quote. yet it still separates.
>
>i looked at the file in a hex file editor. it is using 0d 0a as the CRLF
>which looks purely legit and contains no other extra characters.
>
>it's killin me....it looks like i have it right? i went into access,
>imported it, and set field11 as a memo field. yet it reports there were
>errors during import.
>
>HELP!
>
>;-)
>
>
>"bob" <rb@somewhere.com> wrote in message
>news:evx3PX86FHA.3684@TK2MSFTNGP12.phx.gbl...
>
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
| |
|
| sorry dood! i got so wrapped up into thinking it was the CRLF problem that i
really didn't look at whether it was a " issue.
thanks for you help, John!
"John Nurick" <j.mapSoN.nurick@dial.pipex.com> wrote in message
news:kmvqn1t5ej30q26
c3j86ri23udjnq70sk1@
4ax.com...
> Hi Bob,
>
> Access usually has no problems importing CSV files that include line
> breaks (CRLF pairs) within records. I've just tested this with Access
> 2003.
>
> It's essential that the text and memo fields be "qualified" with double
> quotes: the import routine relies on counting the double quotes to tell
> whether a CRLF is part of the data (i.e. between double quotes) or the
> end of the record.
>
> Consequently there are problems if the data contains double quotes, e.g.
> a field whose contents are
> "Legs" O'Reilly
>
> If this is surrounded by double quotes it appears in the text file as
> ""Legs" O'Reilly"
> there's obvious room for confusion. To avoid this, any double quotes in
> the data have to be doubled, so this in the text file
> """Legs"" O'Reilly"
> will import as
> "Legs" O'Reilly
>
> One thing that will cause the problem you're having is if your import
> settings don't specicy " as the text qualifier. Otherwise, the problem
> is much more likely to be in the text file than in Access.
>
> Access's built-in text import routine doesn't allow anything except CRLF
> at the end of a record.
>
> On Thu, 17 Nov 2005 17:25:25 -0500, "bob" <rb@somewhere.com> wrote:
>
>
> --
> John Nurick [Microsoft Access MVP]
>
> Please respond in the newgroup and not by email.
>
|
|
|
|
|