RE: converting sequential to line sequential

Either use HPL or a program such as the recsplit in the attached shell archive. No rocket science in this - it simply slaps a newline character into the output every N characters, where you get to specify N. recsplit -l 48 inputfile > outputfile If you don't want a newline, you can specify -s "sep" on the command line. See the manual page. Build with 'make -f recsplit.mk'. It should only cause problems if you don't have a C compiler which accepts prototypes - in which case, you should go and get one (GCC, for example). Yours, Jonathan Leffler (jleffler@visa.com) #include <bother.ms-exchange.h> ---------- From: Sunil Thakkar[SMTP:sunil0@hotmail.com] Sent: Monday, March 16, 1998 9:18 AM To: informix-list@iiug.org Subject: converting sequential to line sequential Hi All, I am receving a file from multiple locations that needs to be loaded to informix table. The file that i am receving is a sequential file without any end of line marker. Can somebody tell me how to convert this sequential file to line sequential file OR is there any way I can load this file to informix database. the sample file is as follows : 0083980109ZEDAF11 16 3 0 0083980109ZEDAM11 0 1 0 0083980112AAAAA31 1 3 3 0083980112AAAAF11 1 3 3 0083980112AAAAF31 2 10 10 0083980112AAAAF41 3 13 13 0083980112AAAAF43 1 1 1 0083980112ABAAA31 1 5 5 0083980112ABAAA43 1 3 3 0083980112ABAAA47 1 1 1 0083980112ABAAF11 4 9 9 0083980112ABAAF31 1 9 9 0083980112ABAAF43 2 3 3 0083980112ABAAN32 1 6 6 0083980112ABAAN43 1 1 1 0083980112ABGAF11 8 8 8 0083980112ABGAF43 1 1 1 0083980112ACAOF41 2 4 4 0083980112ACAOF43 3 6 6 0083980112ACAON41 1 3 3 0083980112ADAAF41 2 2 2 0083980112ADAAM43 1 2 2 0083980112ADAAN41 1 1 1 0083980112AEAAA43 2 15 15 0083980112AEAAF11 6 9 9 0083980112AEAAF43 1 1 1 0083980112AEAAM11 1 1 1 0083980112AEAAN31 1 1 1 0083980112AGAAA11 1 7 7 0083980112AGAAA41 2 3 3 0083980112AGAAF11 1 1 1 0083980112AGAAF31 2 13 13 0083980112AGAAF41 6 62 62 0083980112AGAAF43 1 11 11 ------------------------------ each record is of 48 charecters 0083980109ZEDAF11 16 3 0 0083980109ZEDAM11 0 1 0 -------------------------------------------------- Thanking you in advance. Sunil Thakkar. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com begin 600 recsplit.sa M.@DB0"@C*3H@<VAA<BYS:"QV(#$N,3$@,3DY."\\P,R\\Q-B R,#HS-CHQ-B!J M;&5F9FQE<B!%>' @)"(-"B,A("]B:6XO<V@-"B,-"B,)5&AI<R!I<R!A('-H M96QL(&%R8VAI=F4N#0HC"5)E;6]V92!E=F5R>71H:6YG(&%B;W9E('1H:7,@ M;&EN92!A;F0@<G5N('-H(&]N('1H92!R97-U;'1I;F<@9FEL92X-"B,)268@ M=&AI<R!A<F-H:79E(&ES(&-O;7!L971E+"!Y;W4@=VEL;"!S964@=&AI<R!M M97-S86=E(&%T('1H92!E;F0Z#0HC"2)!;&P@9FEL97,@97AT<F%C=&5D(@T* M(PT*(PE#<F5A=&5D.B!-;VX@36%R(#$V(#$R.C,V.C(Q(%!35" Q.3DX(&)Y M(&IL969F;&5R(&%T(%9I<V$@26YT97)N871I;VYA;"!);F,N#0HC"49I;&5S M(&%R8VAI=F5D(&EN('1H:7,@87)C:&EV93H-"B,)9FEL=&5R+F,-"B,)9FEL M=&5R+F@-"B,)9V5T;W!T+F@-"B,)<F5C<W!L:70N,0T*(PER96-S<&QI="YC M#0HC"7)E8W-P;&ET+FUK#0HC"7-T9&5R<BYC#0HC"7-T9&5R<BYH#0HC#0HC M+2TM+2TM+2TM+2TM+2TM+2TM+2T-"FEF(%L@+68@9FEL=&5R+F,@+6$@(B0Q M(B A/2 B+6,B(%T-"G1H96X@96-H;R!S:&%R.B!F:6QT97(N8R!A;')E861Y M(&5X:7-T<PT*96QS90T*96-H;R G>" M(&9I;'1E<BYC("@S,#0T(&-H87)A M8W1E<G,I)PT*<V5D("UE("=S+UY8+R\\G(#YF:6QT97(N8R \\/"=32$%2+45/ M1B<-"E@O*@T*6$ H(RE&:6QE.B @(" @(" @(" @("120U-F:6QE.B!F:6QT M97(N8RQV("0-"EA *",I5F5R<VEO;CH@(" @(" @(" D4F5V:7-I;VXZ(#,N M-B D#0I80"@C*4QA<W0@8VAA;F=E9#H@(" @)$1A=&4Z(#$Y.3<O,#8O,#(@ M,38Z-#$Z-3<@) T*6$ H(RE0=7)P;W-E.B @(" @(" @(%-T86YD87)D($9I M;&4@1FEL=&5R#0I80"@C*4%U=&AO<CH@(" @(" @(" @2B!,969F;&5R#0I8 M0"@C*4-O<'ER:6=H=#H@(" @(" @*$,I($I,4U,@,3DX-RTX.2PQ.3DQ+#$Y M.3,L,3DY-@T*6$ H(RE0<F]D=6-T.B @(" @(" @(#I04D]$54-4.@T*6"HO M#0I8#0I8+RI404)35$]0/30J+PT*6"\\J3$E.5$Q)0E)!4EDJ+PT*6 T*6"-I M;F-L=61E(#QS=&1I;RYH/@T*6"-I;F-L=61E(#QS=')I;F<N:#X-"E@C:6YC M;'5D92 B<W1D97)R+F@B#0I8(VEN8VQU9&4@(F9I;'1E<BYH(@T*6 T*6"-I M9FYD968@;&EN= T*6'-T871I8R!C;VYS="!C:&%R(')C<UM=(#T@(D H(RDD M260Z(&9I;'1E<BYC+'8@,RXV(#$Y.3<O,#8O,#(@,38Z-#$Z-3<@:F]H;FP@ M17AP("0B.PT*6"-E;F1I9@T*6 T*6"\\J#0I8(" @(%!U<G!O<V4Z(" @(%-T M86YD87)D($9I;&4@1FEL=&5R#0I8#0I8(" @($UA:6YT96YA;F-E($QO9PT* M6" @(" M+2TM+2TM+2TM+2TM+2T-"E@@(" @,#DO,#,O.#<@($I,(" @($]R M:6=I;F%L('9E<G-I;VX@<W1A8FEL:7-E9 T*6" @(" Q."\\P-"\\X." @2DP@ M(" @3F]W('!A<W,@9G @86YD(&9I;&4@;F%M92!T;R!F=6YC=&EO;@T*6" @ M(" Q-2\\Q,B\\Y,2 @2DP@(" @57!G<F%D92!F;W(@04Y322!##0I8(" @(#(Y M+S V+SDS("!*3" @("!296YA;64@=&\\@9FEL=&5R(&%N9"!A8V-E<'0@;W!T M:6YD(&%R9W5M96YT#0I8(" @(#$U+S$P+SDV("!*3" @("!296UO=F4@;F]N M+4%.4TD@<W5P<&]R="!A;F0@9F9I;'1E<B@I.R!R96YA;64@9FEL90T*6 T* M6" @("!!<F=U;65N=',-"E@@(" @+2TM+2TM+2TM#0I8(" @(&%R9V,@(" @ M(" @(" @("!);CH@3G5M8F5R(&]F(&%R9W5M96YT<PT*6" @("!A<F=V(" @ M(" @(" @(" @26XZ($%R9W5M96YT(&QI<W0@;V8@<')O9W)A;0T*6" @("!O M<'1I;F0@(" @(" @(" @26XZ($]F9G-E="!I;B!L:7-T('1O('-T87)T(&%T M#0I8(" @(&9U;F-T:6]N(" @(" @("!);CH@1G5N8W1I;VX@=&\\@<')O8V5S M<R!F:6QE#0I8#0I8(" @($-O;6UE;G1S#0I8(" @("TM+2TM+2TM#0I8(" @ M(#$N("!&;W(@979E<GD@;F]N+69L86<@;W!T:6]N(&EN('1H92!A<F=U;65N M="!L:7-T+"!O<B!S=&%N9&%R9"!I;G!U= T*6" @(" @(" @:68@=&AE<F4@ M87)E(&YO(&YO;BUF;&%G(&%R9W5M96YT<RP@<G5N("=F=6YC=&EO;B<@;VX@ M9FEL92X-"E@@(" @,BX@($EF(&$@9FEL92!N86UE(&ES("<M)RP@=7-E('-T M86YD87)D(&EN<'5T+@T*6" @(" S+B @5&AE(&]P=&YU;2!A<F=U;65N="!S M:&]U;&0@;F]R;6%L;'D@8F4@=&AE('9A;'5E(&]F(&]P=&EN9"!A<PT*6" @ M(" @(" @<W5P<&QI960@8GD@9V5T;W!T*#,I+B @0G5T(&ET('-H;W5L9"!B M92!T:&4@:6YD97@@;V8@=&AE(&9I<G-T#0I8(" @(" @("!N;VXM9FQA9R!A M<F=U;65N="X-"E@-"E@J+PT*6'9O:60@(" @(" @(" @("!F:6QT97(H:6YT M(&%R9V,L(&-H87(@*BIA<F=V+"!I;G0@;W!T;G5M+"!&:6QT97(@9G5N8W1I M;VXI#0I8>PT*6 EI;G0@(" @(" @(" @(" @:3L-"E@)1DE,12 @(" @(" @ M(" @*F9P.PT*6 EC:&%R(" @(" @(" @(" J9FEL93L-"E@-"E@):68@*&%R M9V,@/#T@;W!T;G5M*0T*6 E[#0I8"0DO*B!!<W-U;65S(&%R9W9;87)G8UT@ M/3T@3DE,*&-H87(@*BD@86YD(&-A;B!B92!A<W-I9VYE9"!T;R J+PT*6 D) M87)G=EMA<F=C72 ]("