Split File based on different conditions

Shell Programming and Scripting
1

I need to split the file

Conditions:

  • Ignore any record that either starts with 1 or 9
  • Split the file at position 404 , if position 404 is abc or def then write all the records in a file > File 1 , the remaining records should go in to a file > File 2
  • Further I want to split the File 1 by number of records , each file should have ~ 5+ records, while we are splitting the File 1 by number of records we need to make sure that the first record in the each individual split files should always start with 2
  • All the individual splits of File 1 should have a unique name e.g. test001.txt , test002.txt e.t.c

Input File :

100000035900015300007538 xxxxxxxxxxxxxx                      xxxxxxxxxxxx                  xxxxxxxxxxxxxxxxxxxxx         20140206xxxxxxx ONLY2014020720140207                                                                                                                                                                                                                                                                                                                                                                                          ,
200000035900015300007538 xxxxxT00106006900000000000DD000000000N000000000N00NxxxxxxxxD      N Nxxxxxxxxxxx                   N0954106        N19830312N20100609NMN          N             00000000N                 xxxx xxxxxxxxxxxxx, xxxx      N                              N                              NxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxNabc            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,
300000035900015300007538 xxxxxT00106006901047119889D 000000000N000000000N01NxxxI           N Nxxxxxxxxxxxxx                 N               N19830411N00000000NFN          N             00000000N                 xxxx xxxxxxxxxxxxx, xxxx      N                              N                              NxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxNabc            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,
300000035900015300007538 xxxxxx00106006902000000000D 000000000N000000000N03NxxxxV          N xxxxxxxxxx                     N               N20130204N00000000NMN          N             00000000N                 xxxx xxxxxxxxxxxxx, xxxx      N                              N                              NxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxNabc            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,        
200000035900015300007538 xxxxxx00106795800000000000DD000000000N000000000N00NxxxL           NQxxxxxxx                        N1106919        N19750730N20130116NMN          N             00000000N                 5xx xxxxxxxxxxxxx             N                              N                              NxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxNabc            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,
300000035900015300007538 xxxxxx00106795801001025245D 000000000N000000000N01Nxxxxxxx        N xxxxxxx                        N               N19810520N00000000NFN          N             00000000N                 xxx xxxxxxxxxxxxx             N                              N                              NxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxNabc            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,
300000035900015300007538 xxxxxx00106795802002089044D 000000000N000000000N03Nxxxxxxx        NAxxxxxxx                        N               N20091011N00000000NMN          N             00000000N                 xxxxxxxxxxxxxxxxx             N                              N                              NxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxNabc            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx,
200000035900015300007538 xxxxxx00108663200000000000DD000000000N000000000N00Nxxxxx          NAxxxxxxx                        N0932180        N19780804N20091222NMN          N             00000000N                 xxxxx xxxxxxxxxxx             N                              N                              NxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxNabc            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx,
300000035900015300007538 xxxxxxx0108663201489622096D 000000000N000000000N01Nxxxxxx         N xxxxxxx                        N               N19540403N00000000NFN          N             00000000N                 1xxxxxxxxxxxxxxxx             N                              N                              NxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxNabc            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,
200000035900015300007538 xxxxxx00138593700000000000DD000000000N000000000N00Nxxxx           N NMxxxx                         N0880971        N19620604N19910528NMN          N             00000000N                 Pxxxxxxxxxxxxx                N                              N                              NxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxNdef            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,
200000035900015300007538 xxxxxx00140226500000000000DD000000000N000000000N00Nxxxx           NFNxxxxxxxxx                     N0918118        N19500906N20090930NMN          N             00000000N                 xxxxxxxxxxxxxxxxxxxxxxxx      N                              N                              NxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxNCVS            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,
900000035900015300007538 xxxxxxxxxxxxxx                      xxxxxxxxxxxx                  xxxxxxxxxxxxxxxxxxxxx         2014020600729850074150                                                                                                                                                                                                                                                                                                                                                                                                        ,
100000035900015300107538 xxxxxxxxxxxxxx                      xxxxxxxxxxxx                  xxxxxxxxxxxxxxxxxxxxx         20140206CHANGES ONLY2014020720140207                                                                                                                                                                                                                                                                                                                                                                                          ,
200000035900015300107538 xxxxxxxxxxxxxxxxxxxxxxxxxx                                                                                                                                                                                                                                                             xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxYabc            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,
300000035900015300107538 xxxxxx00106006901047119889A 000000000Y000000000Y01xxxxx           Y Yxxxxxxxxxxxxx                 Y               Y19830411Y00000000YFY          Y             00000000Y                 xxxxxxxxxxxxxxxxxxxxxxxx      Y                              Y                              YxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxYabc            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,        
300000035900015300107538 xxxxxx00106006902000000000A 000000000Y000000000Y03YxxxxV          Y Yxxxxxxxxx                     Y               Y20130204Y00000000YMY          Y             00000000Y                 xxxxxxxxxxxxxxxxxxxxxxx5      Y                              Y                              YxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxYabc            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,
200000035900015300107538 xxxxxx00106795800000000000AA000000000Y000000000Y00Yxxxx           YQxxxxxxx                        Y1106919        Y19750730Y20130116YMY          Y             00000000Y                 xxxxxxxxxxxxxxxxx             Y                              Y                              YxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxYabc            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,
300000035900015300107538 xxxxxx00106795801001025245A 000000000Y000000000Y01Yxxxxxxx        Y xxxxxxx                        Y               Y19810520Y00000000YFY          Y             00000000Y                 xxxxxxxxxxxxxxxxx             Y                              Y                              YxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxYabc            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,
300000035900015300107538 xxxxxx00106795802002089044A 000000000Y000000000Y03Yxxxxxxx        YAxxxxxxx                        Y               Y20091011Y00000000YMY          Y             00000000Y                 xxxxxxxxxxxxxxxxx             Y                              Y                              YxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxYabc            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,
200000035900015300107538 xxxxxx00108663200000000000AA000000000Y000000000Y00Yxxxxx          YAxxxxxxx                        Y0932180        Y19780804Y20091222YMY          Y             00000000Y                 xxxxxxxxxxxxxxxxx             Y                              Y                              YxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxYabc            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx,
300000035900015300107538 xxxxxx00108663201489622096A 000000000Y000000000Y01Yxxxxxx         Y xxxxxxx                        Y               Y19540403Y00000000YFY          Y             00000000Y                 xxxxxxxxxxxxxxxxx             Y                              Y                              YxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxYabc            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx,
200000035900015300107538 xxxxxx00138593700000000000AA000000000Y000000000Y00Yxxxx           Y Yxxxxx                         Y0880971        Y19620604Y19910528YMY          Y             00000000Y                 xxxxxxxxxxxxxx                Y                              Y                              YxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxYdef            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx,
900000035900015300107538 xxxxxxxxxxxxxx                      xxxxxxxxxxxx                  xxxxxxxxxxxxxxxxxxxxx         2014020600765120075547                                                                                                                                                                                                                                                                                                                                                                                                        ,
100000035900015300107538 xxxxxxxxxxxxxx                      xxxxxxxxxxxx                  xxxxxxxxxxxxxxxxxxxxx         20140206CHANGES ONLY2014020720140207                                                                                                                                                                                                                                                                                                                                                                                          ,
200000035900015300107538 xxxxxxxxxxxxxxxxxxxxxxxxxx                                                                                                                                                                                                                                                             xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxYMVE            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,
300000035900015300107538 xxxxxx00106006901047119889A 000000000Y000000000Y01xxxxx           Y Yxxxxxxxxxxxxx                 Y               Y19830411Y00000000YFY          Y             00000000Y                 xxxxxxxxxxxxxxxxxxxxxxxx      Y                              Y                              YxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxYMVE            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,        
300000035900015300107538 xxxxxx00106006902000000000A 000000000Y000000000Y03YxxxxV          Y Yxxxxxxxxx                     Y               Y20130204Y00000000YMY          Y             00000000Y                 xxxxxxxxxxxxxxxxxxxxxxx5      Y                              Y                              YxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxYXYZ            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,
200000035900015300107538 xxxxxx00106795800000000000AA000000000Y000000000Y00Yxxxx           YQxxxxxxx                        Y1106919        Y19750730Y20130116YMY          Y             00000000Y                 xxxxxxxxxxxxxxxxx             Y                              Y                              YxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxYMVE            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,
300000035900015300107538 xxxxxx00106795801001025245A 000000000Y000000000Y01Yxxxxxxx        Y xxxxxxx                        Y               Y19810520Y00000000YFY          Y             00000000Y                 xxxxxxxxxxxxxxxxx             Y                              Y                              YxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxYMVE            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,
300000035900015300107538 xxxxxx00106795802002089044A 000000000Y000000000Y03Yxxxxxxx        YAxxxxxxx                        Y               Y20091011Y00000000YMY          Y             00000000Y                 xxxxxxxxxxxxxxxxx             Y                              Y                              YxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxYabc            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx0,
200000035900015300107538 xxxxxx00108663200000000000AA000000000Y000000000Y00Yxxxxx          YAxxxxxxx                        Y0932180        Y19780804Y20091222YMY          Y             00000000Y                 xxxxxxxxxxxxxxxxx             Y                              Y                              YxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxYdef            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx,
300000035900015300107538 xxxxxx00108663201489622096A 000000000Y000000000Y01Yxxxxxx         Y xxxxxxx                        Y               Y19540403Y00000000YFY          Y             00000000Y                 xxxxxxxxxxxxxxxxx             Y                              Y                              YxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxYabc            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx,
200000035900015300107538 xxxxxx00138593700000000000AA000000000Y000000000Y00Yxxxx           Y Yxxxxx                         Y0880971        Y19620604Y19910528YMY          Y             00000000Y                 xxxxxxxxxxxxxx                Y                              Y                              YxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxYdef            xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx,
900000035900015300107538 xxxxxxxxxxxxxx                      xxxxxxxxxxxx                  xxxxxxxxxxxxxxxxxxxxx         2014020600765120075547                                                                                                                                                                                                                                                                                                                                                                                                        ,

Thank you

2

Hello.

What have you tried? Where are you stuck?

1 Like
3

Sorry for not using code tags , moving forward I will make sure that I use them

I havent had any luck with it , any help is greatly appreciated

Thanks in advance

---------- Post updated at 11:39 PM ---------- Previous update was at 03:57 PM ----------

Hello,

Can anyone please provide me some help and direction ?

Thanks in advance

4

Same question again
What have u tried?

5

Here is what I have so far !

I have marked the areas where I need help

#!/usr/bin/ksh

# Get all the records except for the ones that start with 1 or 9

grep "^[^1|9]" Input.txt > Output.txt

# Get all the records that have abc at position 404

cat Output.txt |awk 'substr($0,404,3)=="abc" {print}' > File1.txt

# Get all the records that have def at position 404

cat Output.txt |awk 'substr($0,404,3)=="def" {print}' >> File1.txt

# Get all the records that have do NOT have abc or def  at position 404 -- Need Help !

# Get all the records that have spaces at position 404  -- Need Help !

# Split the File1.txt -- Need Help !

   # ~ 5 Records in each individual split files with uniqe name on each file
   
   # while we are splitting the File 1 by number of records we need to make sure that the first record in the each individual split files should always start with 2 
   
   # Include the header ( first record of the input file) and trailer record( last record in the input file)in each individual file

Any help is greatly appreciated !

Thank you

6

Here's something to start with for items 1 and 2:

awk '/^[19]/{next} {ss=substr($0,404,3); out=(ss=="abc" || ss=="def")? "file1":"file2"; print >out}' myFile
7

Thanks vgersh99!

Can you please explain the code

Appreciate it!

---------- Post updated at 02:22 PM ---------- Previous update was at 11:21 AM ----------

Scripting gurus need help on this !

Split the File1.txt

# ~ 5 Records in each individual split files with uniqe name on each file

# while we are splitting the File 1 by number of records we need to make sure that the first record in the each individual split files should always start with 2

# Include the header ( first record of the input file) and trailer record( last record in the input file)in each individual file

8

Still you show no effort, and increasingly it sounds like a homework assignment. Thread closed.