SPLIT a file based on String

[Nat Gross]

On 12/25/05, Richard England <rengland at europa.com> wrote:
> Nat Gross wrote:
>
> >On 12/25/05, Richard England <rengland at europa.com> wrote:
> >
> >
> >>Nat Gross wrote:
> >>
> >>
> >>
> >>>Hi;
> >>>I need something like SPLIT, but instead of splitting based on bytes
> >>>or lines, I want it to start a new file every time it encounters a
> >>>"CREATE TABLE" string.
> >>>I am a newbie with command line tools.
> >>>
> >>>Thank you all;
> >>>-nat
> >>>
> >>>
> >>>
> >>>
> >>>
> >> csplit -k -f section testfile  '/CREATE TABLE/' {*}
> >>
> >>This should help.   -f section   makes the split data show up in files
> >>called  'section01', 'section02', etc. -k keeps it from deleting output
> >>files created if an error occurs.  'testfile' is the input file,
> >>'/CREATE TABLE/' is the regular expression used to match and {*}  uses
> >>the previous reg. exp.  as many times as necessary.
> >>
> >>
> >>
> >Thank you much! Not only for the solution, but the  explanation! I
> >wish all answers were so concise and to the point.
> >-nat
> >
> >
> >
> You're welcome.  I guess too many years in SW support shows.  :-)
Have been there; have done that. My sympathies!
-nat