Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: redirect to a file based on a value in a field
Top Forums UNIX for Dummies Questions & Answers redirect to a file based on a value in a field Post 302661933 by lucasvs on Tuesday 26th of June 2012 01:52:14 AM
Old 06-26-2012
redirect to a file based on a value in a field
Hi all!

Is it possible with awk to redirect all the records of a file that match a string in a field to a specific file.

input.tab:
Code:
aaaaa|bbbbbb|KKKKK
cccccc|dddddd|SSSSS
eeeeee|ffffffff|SSSSS
ggggg|hhhhhh|KKKKK

redirected to 2 separate files depending on the value in $3:

output_1.tab (only lines with "KKKKK" in $3):
Code:
aaaaa|bbbbbb|KKKKK
ggggg|hhhhhh|KKKKK

output_2.tab (only lines with "SSSSS" in $3):
Code:
cccccc|dddddd|SSSSS
eeeeee|ffffffff|SSSSS

If someone could give me a clue, it would be great !
Thx !
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Append a field to the end of each line of a file based on searching another file.

Hi All, I have two comma separated value(CSV) files, say FileA and FileB. The contents looks like that shown below. FileA EmpNo,Name,Age,Sex, 1000,ABC,23,M, 1001,DES,24,F, ... (2 Replies)
Discussion started by: ultimate
2 Replies

2. Shell Programming and Scripting

Split file based on field

Hi I have a large file 2.6 million records and I am trying to split the file based on last column. I am doing awk -F"|" '{ print > $NF }' filename1 After around 1000 splits it gives me a error awk: can't open file 3332332423 input record number 1068, file filename1 source... (6 Replies)
Discussion started by: s_adu
6 Replies

3. Shell Programming and Scripting

Spliting file based field pattern

Hi all, i have file that looks like as below 2263881188,24570896,439,SOLO,SOLO_UNBEATABLE,E,+3.13,+0.00 2263881964,24339077,439,SOLO,SOLO_UNBEATABLE,F,-0.67,+0.00 2263883220,22619162,228,Bell,Bell_MONTHLY,E,-2.04,+0.00 2263883220,22619162,228,Bell,Bell_MONTHLY,F,-2.04,+0.00... (3 Replies)
Discussion started by: raghavendra.cse
3 Replies

4. Shell Programming and Scripting

Update a field in a file based on condition

Hi i am new to scripting. i have a file file.dat with content as : CONTENT_STORAGE PERCENTAGE FLAG: /storage_01 64% 0 /storage_02 17% 1 I need to update the value of FLAG for a particular CONTENT_STORAGE value I have written the following code #!/bin/sh threshold=20... (1 Reply)
Discussion started by: kichu
1 Replies

5. UNIX for Dummies Questions & Answers

Sorting data in file based on field in another file

Hi, I have two files, one of which I would like to sort based on the order of the data in the second. I would like to do this using a simple unix statement. My two files as follows: File 1: 12345 1 2 2 2 0 0 12349 0 0 2 2 1 2 12350 1 2 1 2 2 2 . . . File2: 12350... (3 Replies)
Discussion started by: kasan0
3 Replies

6. Shell Programming and Scripting

How to split file into multiple files using awk based on 1 field in the file?

Good day all I need some helps, say that I have data like below, each field separated by a tab DATE NAME ADDRESS 15/7/2012 LX a.b.c 15/7/2012 LX1 a.b.c 16/7/2012 AB a.b.c 16/7/2012 AB2 a.b.c 15/7/2012 LX2 a.b.c... (2 Replies)
Discussion started by: alexyyw
2 Replies

7. Shell Programming and Scripting

Redirect the output of the file based on String

Hi, I need to redirect the output of the file until the first instance of a string is found. So in the filename output.txt i was to redirect everything from the start to where i find this string "BEA-000377" is found to a new file called output_new.txt Sample output.txt the controller... (1 Reply)
Discussion started by: mohtashims
1 Replies

8. Shell Programming and Scripting

Split file based on a column/field value

Hi All, I have a requirement to split file into 2 sets of file. Below is a sample data of the file AU;PTN;24EX;25-AUG-14;AU;123;SE;123;Test NN;;;;ASD; AU;PTN;24EX;25-AUG-14;AU;456;SE;456;Test NN;;;;ASD; AU;PTN;24EX;25-AUG-14;AU;147;SE;147;Test NN;;;;ASD;... (6 Replies)
Discussion started by: galaxy_rocky
6 Replies

9. Shell Programming and Scripting

Perl to update field in file based of match to another file

In the perl below I am trying to set/update the value of $14 (last field) in file2, using the matching NM_ in $12 or $9 in file2 with the NM_ in $2 of file1. The lengths of $9 and $12 can be variable but what is consistent is the start pattern will always be NM_ and the end pattern is always ;... (4 Replies)
Discussion started by: cmccabe
4 Replies

10. Shell Programming and Scripting

awk to look up values in File 2 from File 1, & printingNth field of File1 based value of File2 $2

I have two files which are the output of a multiple choice vocab test (60 separate questions) from 104 people (there are some missing responses) and the question list. I have the item list in one file (File1) Item,Stimulus,Choice1,Choice2,Choice3,Choice4,Correct... (5 Replies)
Discussion started by: samonl
5 Replies

LEARN ABOUT DEBIAN

viewperl

VIEWPERL(1)							   User Commands						       VIEWPERL(1)

NAME

       viewperl - quickly view syntax highlighted Perl code

SYNOPSIS

       viewperl [OPTION]... FILE...

DESCRIPTION

       View a Perl source code file, syntax highlighted.

       -c, --code=CODE
	      view CODE, syntax highlighted

       -l, --lines
	      display line numbers

       -L, --no-lines
	      supress display of line numbers (default)

       -m, --module=FILE
	      consider FILE the name of a module, not a file name

       -n, --name
	      display the name of each file (default)

       -N, --no-name
	      supress display of file names (implied by --no-reset)

       -p, --pod
	      display inline POD documentation (default)

       -P, --no-pod
	      hide POD documentation (line numbers still increment)

       -r, --reset
	      reset formatting and line numbers each file (default)

       -R, --no-reset
	      supress resetting of formatting and line numbers

       -s, --shift=WIDTH
	      set tab width (default is 4)

       -t, --tabs
	      translate tabs into spaces (default)

       -T, --no-tabs
	      supress translating of tabs into spaces

       --help display this help and exit

       Note that module names should be given as they would appear after a Perl `use' or `require' statement.  `Getopt::Long', for example.

       Each string given using -c is considered a different file, so line number and formatting resets will apply.

       View a Perl source code file, syntax highlighted.

       -c, --code=CODE
	      view CODE, syntax highlighted

       -l, --lines
	      display line numbers

       -L, --no-lines
	      supress display of line numbers (default)

       -m, --module=FILE
	      consider FILE the name of a module, not a file name

       -n, --name
	      display the name of each file (default)

       -N, --no-name
	      supress display of file names (implied by --no-reset)

       -p, --pod
	      display inline POD documentation (default)

       -P, --no-pod
	      hide POD documentation (line numbers still increment)

       -r, --reset
	      reset formatting and line numbers each file (default)

       -R, --no-reset
	      supress resetting of formatting and line numbers

       -s, --shift=WIDTH
	      set tab width (default is 4)

       -t, --tabs
	      translate tabs into spaces (default)

       -T, --no-tabs
	      supress translating of tabs into spaces

       --help display this help and exit

       Note that module names should be given as they would appear after a Perl `use' or `require' statement.  `Getopt::Long', for example.

       Each string given using -c is considered a different file, so line number and formatting resets will apply.

viewperl							    August 2007 						       VIEWPERL(1)
All times are GMT -4. The time now is 02:05 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy