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 REDHAT

variable

variable(n)						       Tcl Built-In Commands						       variable(n)

__________________________________________________________________________________________________________________________________________________

NAME

       variable - create and initialize a namespace variable

SYNOPSIS

       variable ?name value...? name ?value?
_________________________________________________________________

DESCRIPTION

       This  command  is  normally used within a namespace eval command to create one or more variables within a namespace.  Each variable name is
       initialized with value.	The value for the last variable is optional.

       If a variable name does not exist, it is created.  In this case, if value is specified, it is assigned to the newly created  variable.	If
       no  value  is  specified,  the new variable is left undefined.  If the variable already exists, it is set to value if value is specified or
       left unchanged if no value is given.  Normally, name is unqualified (does not include the names of  any	containing  namespaces),  and  the
       variable  is  created in the current namespace.	If name includes any namespace qualifiers, the variable is created in the specified names-
       pace.  If the variable is not defined, it will be visible to the namespace which command, but not to the info exists command.

       If the variable command is executed inside a Tcl procedure, it creates local variables linked to the corresponding namespace variables (and
       therefore  these  variables are listed by info locals.)	In this way the variable command resembles the global command, although the global
       command only links to variables in the global namespace.  If any values are given, they are used to modify the  values  of  the	associated
       namespace variables.  If a namespace variable does not exist, it is created and optionally initialized.

       A name argument cannot reference an element within an array.  Instead, name should reference the entire array, and the initialization value
       should be left off.  After the variable has been declared, elements within the array can be set using ordinary set or array commands.

SEE ALSO

       global(n), namespace(n), upvar(n)

KEYWORDS

       global, namespace, procedure, variable

Tcl									8.0							       variable(n)

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