RE: Quick Way to Delete Large amount data in Word

MessageLets see.  I can't think or a quicker way.  Here are some other thoughts
though.

- Put it on the IFS and write an RPGIV program to break it up.

- If on Windows 2000+, open in Notepad and use that to break it apart.

- Use CODE/400 to break it apart.

- Import it onto a REAL PC database product and break it apart there.

- Import it into a database file on iSeries and break it apart there.

-- Scott Johnson
  -----Original Message-----
  From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx]On
Behalf Of Mark Allen
  Sent: Friday, August 22, 2003 9:55 AM
  To: pctech@xxxxxxxxxxxx
  Subject: [PcTech] Quick Way to Delete Large amount data in Word


  I've got a HUGE CSV file (too many rows to open in Excel) that I need to break
up into Excel-able (hey I invented a new word!!) sizes.

  My thoughts were to open it in Word, select a chunk of data, copy/paste it
into another doc and save.

  Problem is even using the fast scroll trick while selecting it is taking
FOREVER to select the chunk.  Is there a quicker way?

  Mark Allen
  IS Manager
  Wilkes Telephone & Electric
  11 W. Court Street
  Washington, GA 30673
  Phone: (706) 678-9565
  Fax: (706) 678-1000


begin 666 ATT00030.htm
M/"%$3T-465!%($A434P@x%5"3$E#("(M+R]7,T,O+T141"!(5$U,(#0N,"!4
M<F%N<VET:6]N86PO+T5.(CX-"CQ(5$U,/CQ(14%$/@T*/$U%5$$@2%144"U%
M455)5CTB0V]N=&5N="U4>7!E(B!#3TY414Y4/2)T97AT+VAT;6P[(&-H87)S
M970]=7,M87-C:6DB/@T*/%1)5$Q%/DUE<W-A9V4\+U1)5$Q%/@T*#0H\3454
M02!C;VYT96YT/2)-4TA434P@xxxx,"XR.# P+C$Q,#8B(&YA;64]1T5.15)!
M5$]2/CPO2$5!1#X-"CQ"3T19/@T*/$1)5CX\4U!!3B!C;&%S<STY,S<U.3 S
M,34M,C(P.#(P,#,^/$9/3E0@xx%C93TB0V]U<FEE<B!.97<B('-I>F4],CY,
M971S( T*<V5E+B9N8G-P.R!)(&-A;B=T('1H:6YK(&]R(&$@<75I8VME<B!W
M87DN)FYB<W [($AE<F4@xx)E('-O;64@;W1H97(@=&AO=6=H=',@#0IT:&]U
M9V@x/"]&3TY4/CPO4U!!3CX\+T1)5CX-"CQ$258^/%-004X@xxxx<W,].3,W
M-3DP,S$U+3(R,#@R,# S/CQ&3TY4(&9A8V4](D-O=7)I97(@3F5W(B -"G-I
M>F4],CX\+T9/3E0^/"]34$%./B9N8G-P.SPO1$E6/@T*/$1)5CX\4U!!3B!C
M;&%S<STY,S<U.3 S,34M,C(P.#(P,#,^/$9/3E0@xx%C93TB0V]U<FEE<B!.
M97<B('-I>F4],CXM(%!U="!I="!O;B -"G1H92!)1E,@86YD('=R:71E(&%N
M(%)01TE6('!R;V=R86T@=&\@8G)E86L@:70@=7 N/"]&3TY4/CPO4U!!3CX\
M+T1)5CX-"CQ$258^/%-004X@xxxx<W,].3,W-3DP,S$U+3(R,#@R,# S/CQ&
M3TY4(&9A8V4](D-O=7)I97(@3F5W(B -"G-I>F4],CX\+T9/3E0^/"]34$%.
M/B9N8G-P.SPO1$E6/@T*/$1)5CX\4U!!3B!C;&%S<STY,S<U.3 S,34M,C(P
M.#(P,#,^/$9/3E0@xx%C93TB0V]U<FEE<B!.97<B('-I>F4],CXM($EF(&]N
M( T*5VEN9&]W<R R,# P*RP@;W!E;B!I;B!.;W1E<&%D(&%N9"!U<V4@=&AA
M="!T;R!B<F5A:R!I=" -"F%P87)T+CPO1D].5#X\+U-004X^/"]$258^#0H\
M1$E6/CQ34$%.(&-L87-S/3DS-S4Y,#,Q-2TR,C X,C P,SX\1D].5"!F86-E
M/2)#;W5R:65R($YE=R(@#0IS:7IE/3(^/"]&3TY4/CPO4U!!3CXF;F)S<#L\
M+T1)5CX-"CQ$258^/%-004X@xxxx<W,].3,W-3DP,S$U+3(R,#@R,# S/CQ&
M3TY4(&9A8V4](D-O=7)I97(@3F5W(B!S:7IE/3(^+2!5<V4@#0I#3T1%+S0P
M,"!T;R!B<F5A:R!I="!A<&%R="X\+T9/3E0^/"]34$%./CPO1$E6/@T*/$1)
M5CX\4U!!3B!C;&%S<STY,S<U.3 S,34M,C(P.#(P,#,^/$9/3E0@xx%C93TB
M0V]U<FEE<B!.97<B( T*<VEZ93TR/CPO1D].5#X\+U-004X^)FYB<W [/"]$
M258^#0H\1$E6/CQ34$%.(&-L87-S/3DS-S4Y,#,Q-2TR,C X,C P,SX\1D].
M5"!F86-E/2)#;W5R:65R($YE=R(@<VEZ93TR/BT@xxxx;W)T(&ET( T*;VYT
M;R!A(%)%04P@x$,@9&%T86)A<V4@<')O9'5C="!A;F0@xx)E86L@:70@xx!A
M<G0@=&AE<F4N/"]&3TY4/CPO4U!!3CX\+T1)5CX-"CQ$258^/%-004X@xxxx
M<W,].3,W-3DP,S$U+3(R,#@R,# S/CQ&3TY4(&9A8V4](D-O=7)I97(@3F5W
M(B -"G-I>F4],CX\+T9/3E0^/"]34$%./B9N8G-P.SPO1$E6/@T*/$1)5CX\
M4U!!3B!C;&%S<STY,S<U.3 S,34M,C(P.#(P,#,^/$9/3E0@xx%C93TB0V]U
M<FEE<B!.97<B('-I>F4],CXM($EM<&]R="!I=" -"FEN=&\@82!D871A8F%S
M92!F:6QE(&]N(&E397)I97,@86YD(&)R96%K(&ET(&%P87)T('1H97)E+CPO
M1D].5#X\+U-004X^/"]$258^#0H\1$E6/CQ34$%.(&-L87-S/3DS-S4Y,#,Q
M-2TR,C X,C P,SX\1D].5"!F86-E/2)#;W5R:65R($YE=R(@#0IS:7IE/3(^
M/"]&3TY4/CPO4U!!3CXF;F)S<#L\+T1)5CX-"CQ$258^/%-004X@xxxx<W,]
M.3,W-3DP,S$U+3(R,#@R,# S/CQ&3TY4(&9A8V4](D-O=7)I97(@3F5W(B!S
M:7IE/3(^+2T@xxxx='0@#0I*;VAN<V]N/"]&3TY4/CPO4U!!3CX\+T1)5CX-
M"CQ"3$]#2U%53U1%(&1I<CUL='(@#0IS='EL93TB4$%$1$E.1RU,1494.B U
M<'@[($U!4D=)3BU,1494.B U<'@[($)/4D1%4BU,1494.B C,# P,# P(#)P
M>"!S;VQI9#L@xx%21TE.+5))1TA4.B P<'@B/@T*(" \1$E6(&-L87-S/4]U
M=&QO;VM-97-S86=E2&5A9&5R(&1I<CUL='(@86QI9VX];&5F=#X\1D].5"!F
M86-E/51A:&]M82 -"B @<VEZ93TR/BTM+2TM3W)I9VEN86P@xxxx<V%G92TM
M+2TM/$)2/CQ"/D9R;VTZ/"]"/B!P8W1E8V@xxx]U;F-E<T!M:61R86YG92YC
M;VT@#0H@(%MM86EL=&\Z<&-T96-H+6)O=6YC97- ;6ED<F%N9V4N8V]M73Q"
M/D]N($)E:&%L9B!/9B \+T(^36%R:R -"B @06QL96X\0E(^/$(^4V5N=#H\
M+T(^($9R:61A>2P@xxxx=7-T(#(R+" R,# S(#DZ-34@xxx\0E(^/$(^5&\Z
M/"]"/B -"B @<&-T96-H0&UI9')A;F=E+F-O;3Q"4CX\0CY3=6)J96-T.CPO
M0CX@xx!C5&5C:%T@xxxxxxx@5V%Y('1O($1E;&5T92!,87)G92 -"B @86UO
M=6YT(&1A=&$@:6X@xx]R9#Q"4CX\0E(^/"]&3TY4/CPO1$E6/@T*(" \1$E6
M/CQ&3TY4(&9A8V4]07)I86P@<VEZ93TR/CQ34$%.(&-L87-S/34Q-34W-3$Q
M-"TR,C X,C P,SY))W9E(&=O="!A($A51T4@#0H@($-35B!F:6QE("AT;V\@
M;6%N>2!R;W=S('1O(&]P96X@:6X@xxxxxxxx('1H870@xx!N965D('1O(&)R
M96%K('5P(&EN=&\@#0H@($5X8V5L+6%B;&4@*&AE>2!)(&EN=F5N=&5D(&$@
M;F5W('=O<F0A(2D@<VEZ97,N/"]34$%./CPO1D].5#X\+T1)5CX-"B @/$1)
M5CX\1D].5"!F86-E/4%R:6%L('-I>F4],CX\4U!!3B -"B @8VQA<W,]-3$U
M-3<U,3$T+3(R,#@R,# S/CPO4U!!3CX\+T9/3E0^)FYB<W [/"]$258^#0H@
M(#Q$258^/$9/3E0@xx%C93U!<FEA;"!S:7IE/3(^/%-004X@xxxx<W,]-3$U
M-3<U,3$T+3(R,#@R,# S/DUY('1H;W5G:'1S('=E<F4@#0H@('1O(&]P96X@
M:70@:6X@xx]R9"P@<V5L96-T(&$@8VAU;FL@;V8@x&%T82P@xx]P>2]P87-T
M92!I="!I;G1O(&%N;W1H97(@9&]C(&%N9" -"B @<V%V92X\+U-004X^/"]&
M3TY4/CPO1$E6/@T*(" \1$E6/CQ&3TY4(&9A8V4]07)I86P@<VEZ93TR/CQ3
M4$%.( T*("!C;&%S<STU,34U-S4Q,30M,C(P.#(P,#,^/"]34$%./CPO1D].
M5#XF;F)S<#L\+T1)5CX-"B @/$1)5CX\1D].5"!F86-E/4%R:6%L('-I>F4]
M,CX\4U!!3B!C;&%S<STU,34U-S4Q,30M,C(P.#(P,#,^4')O8FQE;2!I<R!E
M=F5N( T*("!U<VEN9R!T:&4@xx%S="!S8W)O;&P@=')I8VL@=VAI;&4@<V5L
M96-T:6YG(&ET(&ES('1A:VEN9R!&3U)%5D52('1O('-E;&5C="!T:&4@#0H@
M(&-H=6YK+B9N8G-P.R!)<R!T:&5R92!A('%U:6-K97(@=V%Y/SPO4U!!3CX\
M+T9/3E0^/"]$258^#0H@(#Q$258^)FYB<W [/"]$258^#0H@(#Q$258@xxxx
M9VX];&5F=#X\1D].5"!F86-E/4%R:6%L('-I>F4],CY-87)K($%L;&5N/"]&
M3TY4/CPO1$E6/@T*(" \1$E6(&%L:6=N/6QE9G0^/$9/3E0@xx%C93U!<FEA
M;"!S:7IE/3(^25,@36%N86=E<CPO1D].5#X\+T1)5CX-"B @/$1)5B!A;&EG
M;CUL969T/CQ&3TY4(&9A8V4]07)I86P@<VEZ93TR/E=I;&ME<R!496QE<&AO
M;F4@)F%M<#L@#0H@($5L96-T<FEC/"]&3TY4/CPO1$E6/@T*(" \1$E6(&%L
M:6=N/6QE9G0^/$9/3E0@xx%C93U!<FEA;"!S:7IE/3(^,3$@5RX@0V]U<G0@
M4W1R965T/"]&3TY4/CPO1$E6/@T*(" \1$E6(&%L:6=N/6QE9G0^/$9/3E0@
M9F%C93U!<FEA;"!S:7IE/3(^5V%S:&EN9W1O;BP@xx$@,S V-S,\+T9/3E0^
M/"]$258^#0H@(#Q$258@xxxxxxx];&5F=#X\1D].5"!F86-E/4%R:6%L('-I
M>F4],CY0:&]N93H@*#<P-BD@xx<X+3DU-C4\+T9/3E0^/"]$258^#0H@(#Q$
M258@xxxxxxx];&5F=#X\1D].5"!F86-E/4%R:6%L('-I>F4],CY&87@x("@W
M,#8I(#8W."TQ,# P/"]&3TY4/CPO1$E6/@T*(" \1$E6/B9N8G-P.SPO1$E6
>/CPO0DQ/0TM154]413X\+T)/1%D^/"](5$U,/@T*
`
end