RE: Unix : How to cut a file into pieces?

From: Swapna_P <Swapna_P_at_satyam.com>
Date: Thu, 10 Aug 2000 05:51:40 +0530
Message-Id: <10584.114226@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C00260.F5C465F0
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

awk 'BEGIN {count=3D0}{ if($0 ~ /^9999/) count++; = if(count=3D=3D9000){print NR;
count=3D0;}}' <originalfilename>
count is the number of lines at which u want to split=20 ^9999 is the pattern at the beginning of the file by which u r going to identify each line/record
result
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
170672.....first place to split
341250.......second place to split

sed '1,170672 w <newfilename1>' <originalfilename> > /dev/null=20
sed '170673,341250 w <newfilename2>' <originalfilename> > /dev/null=20
sed '341251,$ w <newfilename3>'<originalfilename> > /dev/null=20

hope this is useful.It works fine for me. Regards
Swapna

> ----------
> From: Cotham, Pam[SMTP:pam.cotham_at_eds.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Thursday, August 10, 2000 4:45 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Unix : How to cut a file into pieces?

>=20

> Why don't you compress it?

>=20

> Pamela A. Cotham
> Senior System Engineer/Oracle DBA
> EDS CA-XIX Senior Consultant
> 916.636.1964
> pamcotham_at_eds.com

>=20


> > -----Original Message-----

> > From:	Deepender_Gupta_at_escorts.co.in

> [SMTP:Deepender_Gupta_at_escorts.co.in]

> > Sent:	Friday, July 28, 2000 12:45 AM

> > To:	Multiple recipients of list ORACLE-L

> > Subject:	Re: Unix : How to cut a file into pieces?

> >=20

> >=20

> >=20

> > Dear all,
> > can we split a dmp file by using the split command if the file size =
is
> too
> > big to be used by ftp.
> > as it is taking too much time to get transfer from Unix server to =
NT
> > server.
> > Regds
> >=20
> >=20
> >=20
> >=20
> >=20
> >=20
> >=20
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>@SMTP_at_AMG1
> > cc:
> >=20
> > use combinations of head and tail and re-direct the output
> >=20
> > head -10000 filename>filename2 puts 1st 10000 lines into
> > filename2
> > tail +10001 filename|head -10000>filename3 puts next 10000 lines =
into
> > filename3
> >=20
> > etc....see man pages for more info
> >=20
> > At 09:44 AM 7/27/00 -0800, Veronica Levin wrote:
> > >I was wondering if there is a way to cut a 63MB text file into =
small
> > pieces
> > >without opening it with vi.
> > >
> > >Ver=F3nica Levin Enr=EDquez
> > >Administrador AIX
> > >Compa=F1=EDa Cervecera de Nicaragua
> > >Tel=E9fono: 505-2493779
> > >Fax: 505-2443979
> > >Email: vlevin_at_victoria.com.ni
> > >http://www.victoria.com.ni
> >=20
> > =

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D


> > Kenneth Komoto           Email: kgkomoto_at_ucdavis.edu

> > Office of the Registrar  Phone: (530)752-7197

> > University of California Fax  : (530)752-0329

> > Davis, Ca 95616

> >=20

> > --

> > Author: Ken Komoto

> >   INET: kgkomoto_at_ucdavis.edu

> >=20

> > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> > San Diego, California        -- Public Internet access / Mailing =

Lists
> > =

> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like =
subscribing).
> >=20
> >=20
> >=20
> >=20
> >=20
> >=20
> > --=20
> > Author:=20
> > INET: Deepender_Gupta_at_escorts.co.in
> >=20
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing =
Lists
> > =

>=20


> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing =

Lists


> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>=20

------_=_NextPart_001_01C00260.F5C465F0
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: Unix : How to cut a file into pieces?</TITLE>
</HEAD>
<BODY>

awk 'BEGIN {count=3D0}{ if($0 = ~ /^9999/) count++; if(count=3D=3D9000){print NR; count=3D0;}}' = <originalfilename>
 count is the number of lines = at which u want to split 
 ^9999 is the pattern at the = beginning of the file by which u r going to identify each = line/record

<BR><FONT COLOR=3D"#800080" FACE=3D"Arial">result</FONT>
<BR><FONT COLOR=3D"#800080" =
FACE=3D"Arial">=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D</FONT>
<BR><FONT COLOR=3D"#800080" FACE=3D"Arial">170672.....first place to =

split
 341250.......second place to = split

sed '1,170672 w = <newfilename1>' <originalfilename> > /dev/null sed '170673,341250 w = <newfilename2>' <originalfilename> > /dev/null sed '341251,$ w = <newfilename3>'<originalfilename> > /dev/null

hope this is useful.It works = fine for me.

<BR><FONT COLOR=3D"#800080" FACE=3D"Arial">Regards</FONT>
<BR><FONT COLOR=3D"#800080" FACE=3D"Arial">Swapna</FONT>
</P>

<P><FONT SIZE=3D1 FACE=3D"MS Sans Serif">----------</FONT>

From:   = Cotham, = Pam[SMTP:pam.cotham_at_eds.com]
 Reply To: =       ORACLE-L_at_fatcity.com
 Sent:   = Thursday, August 10, 2000 4:45 = AM
 To: =     Multiple = recipients of list ORACLE-L
 Subject: =        RE: Unix : How to cut a file into pieces?

Why don't you compress it?

Pamela A. Cotham Senior System Engineer/Oracle = DBA

<BR><FONT SIZE=3D2 FACE=3D"Arial">EDS CA-XIX Senior Consultant</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">916.636.1964</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">pamcotham_at_eds.com</FONT>
</P>

> -----Original Message----- > From: = Deepender_Gupta_at_escorts.co.in =
[SMTP:Deepender_Gupta_at_escorts.co.in] > Sent: Friday, July 28, 2000 = 12:45 AM

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; To:&nbsp;&nbsp; Multiple =
recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; =

Subject:      Re: Unix : How to cut a file = into pieces?

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Dear all,</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; can we split a dmp file by using =

the split command if the file size is too > big to be used by ftp. > as it is taking too much time to = get transfer from Unix server to NT

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; server.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Regds</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; To:&nbsp;&nbsp; Multiple =

recipients of list ORACLE-L
 > = <ORACLE-L_at_fatcity.com>@SMTP_at_AMG1

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; cc:</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; use combinations of head and =

tail and re-direct the output
 > > head -10000 = filename>filename2        &nb= sp; puts 1st 10000 lines into
 > filename2 > tail +10001 filename|head = -10000>filename3 puts next 10000 lines into

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; filename3</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; etc....see man pages for more =
info</FONT>

> > At 09:44 AM 7/27/00 -0800, = Veronica Levin wrote:
 > >I was wondering if there is = a way to cut a 63MB text file into small > pieces > >without opening it with = vi.
 > > > >Ver=F3nica Levin = Enr=EDquez
 > >Administrador AIX > >Compa=F1=EDa Cervecera de = Nicaragua
 > >Tel=E9fono: = 505-2493779
 > >Fax: 505-2443979 > >Email: = vlevin_at_victoria.com.ni
 > ><A = HREF=3D"http://www.victoria.com.ni" =
TARGET=3D"_blank">http://www.victoria.com.ni</A> >

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; =
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > Kenneth = Komoto           = Email: kgkomoto_at_ucdavis.edu
 > Office of the Registrar  = Phone: (530)752-7197
 > University of California = Fax  : (530)752-0329

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Davis, Ca 95616</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; --</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Author: Ken Komoto</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;&nbsp;&nbsp; INET: =

kgkomoto_at_ucdavis.edu
 > > Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 > San Diego, = California        -- Public Internet = access / Mailing Lists
 > =

--------------------------------------------------------------------</FO=

NT>
 > To REMOVE yourself from this = mailing list, send an E-Mail message > to: ListGuru_at_fatcity.com (note = EXACT spelling of 'ListGuru') and in > the message BODY, include a line = containing: UNSUB ORACLE-L
 > (or the name of mailing list you = want to be removed from).  You may > also send the HELP command for = other information (like subscribing).

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; -- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Author: </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;&nbsp;&nbsp; INET: =

Deepender_Gupta_at_escorts.co.in
 > > Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 > San Diego, = California        -- Public Internet = access / Mailing Lists
 > =

--------------------------------------------------------------------</FO=

<BR><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Cotham, Pam</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =

pam.cotham_at_eds.com

Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 San Diego, = California        -- Public Internet = access / Mailing Lists
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

-----------
 To REMOVE yourself from this mailing = list, send an E-Mail message
 to: ListGuru_at_fatcity.com (note EXACT = spelling of 'ListGuru') and in
 the message BODY, include a line = Received on Wed Aug 09 2000 - 19:21:40 CDT