Split file using awk Post: 303022162

Sponsored Content

Top Forums UNIX for Beginners Questions & Answers Split file using awk Post 303022162 by Scrutinizer on Sunday 26th of August 2018 02:26:01 PM

08-26-2018

Moderator

Sure:

Code:

awk '                                            
  {                                            
    y=substr($2,1,4)                              # Set the variable y to first 4 characters of 
                                                  # the second field of the input file                        
    f=b                                           # set the output to the name in variable b
  }                                            
  y<lt {                                          # if the year is less than the min treshold  
    f=a                                           # set the variable f to the name in variable a
  }                                             
  y>gt {                                          # if the year is more than the max treshold 
    f=c                                           # set the variable f to the name in variable c
  }                                            
  {                                            
    print>f                                       # print the line to the appropriate file          
  }                                            
' lt=2017 gt=2018 a=y1 b=y2 c=y3 infile           # set variables lt, gt, a, b, and c and specify file name.

Scrutinizer

View Public Profile for Scrutinizer

Find all posts by Scrutinizer

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Split file using awk

I am trying to read a file and split the file into multiple files. I need to create new files with different set of lines from the original file. ie, the first output file may contain 10 lines and the second 100 lines and so on. The criteria is to get the lines between two lines starting with some...

2. UNIX for Dummies Questions & Answers

Split a file with no pattern -- Split, Csplit, Awk

I have gone through all the threads in the forum and tested out different things. I am trying to split a 3GB file into multiple files. Some files are even larger than this. For example: split -l 3000000 filename.txt This is very slow and it splits the file with 3 million records in each...

3. Shell Programming and Scripting

split file with awk

I did a lot of search on this forum on spiting file; found a lot, but my requirement is a bit different, please guide. Master file: x:start:5 line1:23 line2:12 2:90 x:end:5 x:start:2 45:56 22:90 x:end:2 x:start:3 line1:23 line2:12 x:end:3 x:start:2 line5:23

4. Shell Programming and Scripting

awk - split file

How can I split a text file (in awk) in n others with number of record given in input? Thanks

5. Shell Programming and Scripting

split a file using awk

6. Shell Programming and Scripting

How to split a file using AWK?

Hello, I have a file like the following: david,a,b,c,20,r thomas,a,b,c,30,r willaiam,a,b,c,80,r barbara,a,b,c,100,r I would like to split the file into other files using a condition for the contents of column 5. The condition should be a if the contents of column 5 is in a range...

7. Shell Programming and Scripting

AWK File Split

Hi All, Input.txt XYZONEABC　　　　　　　　　　　　　　　　　 CZXTWOJJJ KKKSIXOOO asdfhajlsdhfajs asdfasfasdf Output Files: ONE.txt XYZONEABC　　　　　　　　　　　　　　　　 TWO.txt CZXTWOJJJ SIX.txt KKKSIXOOO I had a script

8. Shell Programming and Scripting

Split a file with awk

Hi! I have a file like this: a,b,c,12,d,e a,b,c,13,d,e a,b,c,14,d,e a,b,c,15,d,e a,b,c,16,d,e a,b,c,17,d,e I need to split that file in two: If field 4 is equal or higher than 14 that row goes to one file and if it is equal or higher than 15 to another. Can anyone point me in the...

9. Shell Programming and Scripting

Split File by Pattern with File Names in Source File... Awk?

Hi all, I'm pretty new to Shell scripting and I need some help to split a source text file into multiple files. The source has a row with pattern where the file needs to be split, and the pattern row also contains the file name of the destination for that specific piece. Here is an example: ...

10. Shell Programming and Scripting

awk file split

Hi all, First of all I' like to mention that I'm pretty new to unix scripting. :( I'm trying to split an large xml with awk and rename it based on the values of two attributes. Example XML <RECORD> <element1>11</element1> <element2>22</element2> <element3>33</element3>...

LEARN ABOUT MOJAVE

nvram

nvram(8)						      System Manager's Manual							  nvram(8)

NAME

       nvram - manipulate firmware NVRAM variables

SYNOPSIS

       nvram [ -p ] [ -f filename ] [ -d name ] [ -c ] [ name [= value ]] ...

DESCRIPTION

       The  nvram command allows manipulation of firmware NVRAM variables.  It can be used to get or set a variable.  It can also be used to print
       all of the variables or set a list of variables from a file.  Changes to NVRAM variables are only saved by clean restart or shutdown.

       In principle, name can be any string.  In practice, not all strings will be accepted.  New World  machines  can	create	new  variables	as
       desired.  Some variables require administrator privilege to get or set.

       The  given  value  must match the data type required for name.  Binary data can be set using the %xx notation, where xx is the hex value of
       the byte.  The type for new variables is always binary data.

OPTIONS

       -d name
	      Deletes the named firmware variable.

       -f filename
	      Set firmware variables from a text file.	The file must be a list of "name value" statements.  The first space on each line is taken
	      to be the separator between "name" and "value".  If the last character of a line is , the value extends to the next line.

       -x     Use  XML	format	for reading and writing variables.  This option must be used before the -p or -f options, since arguments are pro-
	      cessed in order.

       -c     Delete all of the firmware variables.

       -p     Print all of the firmware variables.

EXAMPLES

	      example% nvram boot-args="-s rd=*hd:10"

       Set the boot-args variable to "-s rd=*hd:10".  This would specify single user mode with the root device in hard drive partition 10.

	      example% nvram my-variable="String One%00String Two%00%00"

       Create a new variable, my-variable, containing a list of two C-strings that is terminated by a NUL.

	      example% nvram -d my-variable

       Deletes the variable named my-variable.

								 October 28, 2003							  nvram(8)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Split file using awk

Discussion started by: pvar

2. UNIX for Dummies Questions & Answers

Split a file with no pattern -- Split, Csplit, Awk

Discussion started by: madhunk

3. Shell Programming and Scripting

split file with awk

Discussion started by: uwork72

4. Shell Programming and Scripting

awk - split file

Discussion started by: pinguc