Split file using awk Post: 303022127

Sponsored Content

Top Forums UNIX for Beginners Questions & Answers Split file using awk Post 303022127 by rosebud123 on Saturday 25th of August 2018 10:00:59 PM

08-25-2018

Registered User

Split file using awk

I need to split the incoming source file in to multiple files using awk.

Split position is (6,13) : 8 positions

All the records that are greater than 20170101 and less than or equal to 20181231 should go in a split file with file name as source filename_greaterthan_20170101_lessthan_20181231 + yyyymmddhhmmss

All records that are less than 20170101 should go in a file with file name as source filename_lessthan_20170101 + yyyymmddhhmmss

All records that are greater than 20190101 should go in a file with file name as source filename_20190101 + yyyymmddhhmmss

Additionally instead of hard coding the condition in the script/command, can we pass it as a variable to the script , so the script remains dynamic.

Source File:

Code:

001  20991231
002  20190101
003  20231231
004  20231231
005  20261231
006  20271231
007  20281231
008  20301231
009  20161231
010  20161230
011  20161010
012  19880101
013  20000101
014  20110121
015  20130121
016  20170121
017  19870121

rosebud123

View Public Profile for rosebud123

Find all posts by rosebud123

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

iscntrl

ISCNTRL(3)						   BSD Library Functions Manual 						ISCNTRL(3)

NAME

     iscntrl -- control character test

LIBRARY

     Standard C Library (libc, -lc)

SYNOPSIS

     #include <ctype.h>

     int
     iscntrl(int c);

DESCRIPTION

     The iscntrl() function tests for any control character.  The value of the argument must be representable as an unsigned char or the value of
     EOF.

     In the ASCII character set, this includes the following characters (preceded by their numeric values, in octal):

     000 NUL	   001 SOH	 002 STX       003 ETX	     004 EOT
     005 ENQ	   006 ACK	 007 BEL       010 BS	     011 HT
     012 NL	   013 VT	 014 NP        015 CR	     016 SO
     017 SI	   020 DLE	 021 DC1       022 DC2	     023 DC3
     024 DC4	   025 NAK	 026 SYN       027 ETB	     030 CAN
     031 EM	   032 SUB	 033 ESC       034 FS	     035 GS
     036 RS	   037 US	 177 DEL

RETURN VALUES

     The iscntrl() function returns zero if the character tests false and returns non-zero if the character tests true.

COMPATIBILITY

     The 4.4BSD extension of accepting arguments outside of the range of the unsigned char type in locales with large character sets is considered
     obsolete and may not be supported in future releases.  The iswcntrl() function should be used instead.

SEE ALSO

     ctype(3), isalnum_l(3), iswcntrl(3), ascii(7)

STANDARDS

     The iscntrl() function conforms to ISO/IEC 9899:1990 (``ISO C90'').

BSD
								   July 17, 2005							       BSD

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