Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to split file into multiple files using awk based on 1 field in the file?
Top Forums Shell Programming and Scripting How to split file into multiple files using awk based on 1 field in the file? Post 302674119 by Chirel on Thursday 19th of July 2012 04:10:36 AM
Old 07-19-2012
Hi alexyyw,

clx was faster, but here you have other way to have the result :

Option 1 :
Code:
awk '$1 ~ /.*\/.*\/..../ { split($1,a,"/"); print >a[1]"_"a[2]"_"a[3]; }' alexyyw.inputfile

Option 2 :
Code:
awk '$1 ~ /.*\/.*\/..../ { split($1,a,"/"); print >strftime("%B%Y",mktime(sprintf("%04d %02d %02d 00 00 00",a[3],a[2],a[1]))); }' alexyyw.inputfile

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Split single file into multiple files based on the number in the column

Dear All, I would like to split a file of the following format into multiple files based on the number in the 6th column (numbers 1, 2, 3...): ATOM 1 N GLY A 1 -3.198 27.537 -5.958 1.00 0.00 N ATOM 2 CA GLY A 1 -2.199 28.399 -6.617 1.00 0.00 ... (3 Replies)
Discussion started by: tomasl
3 Replies

2. Shell Programming and Scripting

Split a file into multiple files based on the input pattern

I have a file with lines something like. ...... 123_start ...... ....... 123_end .... ..... 456_start ...... ..... 456_end .... ..... 789_start .... .... 789_end (6 Replies)
Discussion started by: abinash
6 Replies

3. Shell Programming and Scripting

split XML file into multiple files based on pattern

Hello, I am using awk to split a file into multiple files using command: nawk '{ if ( $1 == "<process" ) { n=split($2, arr, "\""); file=arr } print > file }' processes.xml <process name="Process1.process"> ... (3 Replies)
Discussion started by: chiru_h
3 Replies

4. Shell Programming and Scripting

Split a file into multiple files based on first two digits of file.

Hi , I do have a fixedwidth flatfile that has data for 10 different datasets each identified by the first two digits in the flatfile. 01 in the first two digit position refers to Set A 02 in the first two digit position refers to Set B and so on I want to genrate 10 different files from my... (6 Replies)
Discussion started by: okkadu
6 Replies

5. Shell Programming and Scripting

Split a file into multiple files based on line numbers and first column value

Hi All I have one query,say i have a requirement like the below code should be move to diffent files whose maximum lines can be of 10 lines.Say in the below example,it consist of 14 lines. This should be moved logically using the data in the fisrt coloumn to file1 and file 2.The data of first... (2 Replies)
Discussion started by: sarav.shan
2 Replies

6. Shell Programming and Scripting

Split a file into multiple files based on field value

Hi, I've one requirement. I have to split one comma delimited file into multiple files based on one of the column values. How can I achieve this Unix Here is the sample data. In this case I have split the files based on date column(c4) Input file c1,c2,c3,c4,c5... (1 Reply)
Discussion started by: manasvi24
1 Replies

7. Shell Programming and Scripting

awk script to split file into multiple files based on many columns

So I have a space delimited file that I'd like to split into multiple files based on multiple column values. This is what my data looks like 1bc9A02 1 10 1000 FTDLNLVQALRQFLWSFRLPGEAQKIDRMMEAFAQRYCQCNNGVFQSTDTCYVLSFAIIMLNTSLHNPNVKDKPTVERFIAMNRGINDGGDLPEELLRNLYESIKNEPFKIPELEHHHHHH 1ku1A02 1 10... (9 Replies)
Discussion started by: viored
9 Replies

8. Shell Programming and Scripting

Split a big file into multiple files based on first four characters

I have a requirement to split a huge file to smaller text files based on first four characters which look like ABCD 1234 DFGH RREX : : : : : 0000 Each of these records are OF EQUAL bytes with a different internal layout based on the above first digit identifier.. Any help to start... (5 Replies)
Discussion started by: etldev
5 Replies

9. Shell Programming and Scripting

Split a single file into multiple files based on a value.

Hi All, I have the sales_data.csv file in the directory as below. SDDCCR; SOM ; MD6546474777 ;05-JAN-16 ABC ; KIRAN ; CB789 ;04-JAN-16 ABC ; RAMANA; KS566767477747 ;06-JAN-16 ABC ; KAMESH; A33535335 ;04-JAN-16 SDDCCR; DINESH; GD6674474747 ;08-JAN-16... (4 Replies)
Discussion started by: ROCK_PLSQL
4 Replies

10. UNIX for Beginners Questions & Answers

Split file into multiple files based on empty lines

I am using below code to split files based on blank lines but it does not work. awk 'BEGIN{i=0}{RS="";}{x="F"++i;}{print > x;}' Your help would be highly appreciated find attachment of sample.txt file (2 Replies)
Discussion started by: imranrasheedamu
2 Replies

LEARN ABOUT DEBIAN

kuipc

KUIPC(1)						      General Commands Manual							  KUIPC(1)

NAME

       kuipc - the CERN KUIP compiler

SYNOPSIS

       kuipc  [ options ] [ inputfile [ outputfile ] ]

DESCRIPTION

       kuipc,  the  Kit  for a User Interface Package Compiler, is a tool to simplify the writing of a program's user interface code.  It takes as
       input a Command Definition File (CDF) that describes the commands to be understood by the program, and outputs C or FORTRAN code that makes
       the  appropriate  function  calls  to  set  up the user interface.  This code can then be compiled and linked with the rest of the program.
       Since the generated code uses KUIP routines, the program must also be linked against the Packlib library that contains them.

       If no output file is specified, kuipc will output generated code to a file whose name is the same as the  input	file's,  with  the  ending
       '.cdf'  replaced  by  '.f'  or  '.c'  as  appropriate.  If neither input nor output file are given, kuipc will prompt for them.	Be careful
       because kuipc overwrites existing files with no warning.

OPTIONS

       -c     Generate C code.

       -f     Generate FORTRAN code (the default).

       -split Output several files, one for each time the >Name control line is used in the CDF input.	The names of the output files will  corre-
	      spond to the arguments given on the >Name control lines.

SEE ALSO

       The KUIP manual: http://wwwasdoc.web.cern.ch/wwwasdoc/psdir/kuip.ps.gz

BUGS

       When  the -split option is used, kuipc will still create an output file that it would have made if -split was not used; the file will be of
       zero size.

AUTHOR

       This manual page was written by Kevin McCarty <kmccarty@debian.org> for the Debian GNU/Linux system (but may be used by others).

								   April 2, 2004							  KUIPC(1)
All times are GMT -4. The time now is 06:38 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy