Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Get output of multiple pattern match from first field to a file
Top Forums Shell Programming and Scripting Get output of multiple pattern match from first field to a file Post 302990453 by rveri on Thursday 26th of January 2017 12:27:04 PM
Old 01-26-2017
Get output of multiple pattern match from first field to a file
Hi All,
Greetings!

I have a file of 40000+ lines with different entries, I need matching entries filterd out to their files based on first filed pattern for the matching :

For example:
All server1 entries (in field1) to come together with its path in 2nd field.

The best output I want to have it should generate filename for each:
Say server1.out file: which would be having "first field" and "second filed" of server1.
And so on for all the serverX .


Code:
datafile.txt  : 

server1	/usr/file1
server1 /usr/fileA
server2 /usr1/fileB
server2	/usr2/fileca
server3 /usr/DB/fileA
server3 /usr1/fileA
serverA /usr1/data1
server1 /usr3/data2
server2 /usr2/data2
server2 /path1/data2
serverA /pathb/data3

Code:
Desired output to be with each filename :


server1.out
server1	/usr/file1
server1 /usr/fileA
server1 /usr3/data2


Code:
File: server2.out 

server2 /usr1/fileB
server2 /usr2/filec
server2 /usr2/data2

Code:
File: server3.out 
server3 /usr/DB/fileA
server3 /usr1/fileA


Code:
File: serverA.out
serverA /usr1/data1
serverA /pathb/data3


Thanks ..
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Output Multiple Field from dataBase file

I am fairly new in unix I was wondering if anybody can help me out with this: I am trying to output to a file the following fields; Field1 Field2 Field4 From a database file dataBase1. this is how the file looks: dataBase1 TABLE DATA Example ================== Table ... (3 Replies)
Discussion started by: Dennz
3 Replies

2. Shell Programming and Scripting

how do i pattern match a field with awk?

hi, let's say $numbers = "324 350 587" an so on... what i'm trying to do is this: awk -v numbers="$numbers" '{if (numbers ~ /$2/) print $0, "bla bla"}' file # file looks like this: 214 ..... 215 ... 216 .... 250 ... 324 325 ... 350 something ... ... 587 ... (4 Replies)
Discussion started by: someone123
4 Replies

3. Shell Programming and Scripting

AWK: Pattern match between 2 files, then compare a field in file1 as > or < field in file2

First, thanks for the help in previous posts... couldn't have gotten where I am now without it! So here is what I have, I use AWK to match $1 and $2 as 1 string in file1 to $1 and $2 as 1 string in file2. Now I'm wondering if I can extend this AWK command to incorporate the following: If $1... (4 Replies)
Discussion started by: right_coaster
4 Replies

4. UNIX for Dummies Questions & Answers

Match pattern in a field, print pattern only instead of the entire field

Hi ! I have a tab-delimited file, file.tab: Column1 Column2 Column3 aaaaaaaaaa bbtomatoesbbbbbb cccccccccc ddddddddd eeeeappleseeeeeeeee ffffffffffffff ggggggggg hhhhhhtomatoeshhh iiiiiiiiiiiiiiii ... (18 Replies)
Discussion started by: lucasvs
18 Replies

5. Shell Programming and Scripting

Multiple pattern match and print the output in a single line

I need to match two patterns in a log file and need to get the next line of the one of the pattern (out of two patterns) that is matched, finally need to print these three values in a single line. Sample Log: 2013/06/11 14:29:04 <0999> (725102) Processing batch 02_1231324 2013/06/11... (4 Replies)
Discussion started by: rpm120
4 Replies

6. Shell Programming and Scripting

Match Pattern and print pattern and multiple lines into one line

Hello Experts , require help . See below output: File inputs ------------------------------------------ Server Host = mike id rl images allocated last updated density vimages expiration last read <------- STATUS ------->... (4 Replies)
Discussion started by: tigerhills
4 Replies

7. Shell Programming and Scripting

Remove multiple lines that match pattern

Not sure how I can accomplish this. I would like to remove all interfaces that have the commands I would like to see: switchport port-security, spanning-tree portfast. One line is no problem. interface FastEthernet0/8 spanning-tree portfast interface FastEthernet0/9 spanning-tree... (4 Replies)
Discussion started by: mrlayance
4 Replies

8. Shell Programming and Scripting

Command/script to match a field and print the next field of each line in a file.

Hello, I have a text file in the below format: Source Destination State Lag Status CQA02W2K12pl:D:\CAQA ... (10 Replies)
Discussion started by: pocodot
10 Replies

9. Shell Programming and Scripting

Removing multiple lines from input file, if multiple lines match a pattern.

GM, I have an issue at work, which requires a simple solution. But, after multiple attempts, I have not been able to hit on the code needed. I am assuming that sed, awk or even perl could do what I need. I have an application that adds extra blank page feeds, for multiple reports, when... (7 Replies)
Discussion started by: jxfish2
7 Replies

10. UNIX for Beginners Questions & Answers

Modify text file if found multiple pattern match for every line.

Looking for help, i have input file like below and want to modify to expected output, if can without create additional file, hope can direct modify it. have 2 thing need do. 1st is adding a word (testplan generation off) after ! ! IPG: Tue Aug 07 14:31:17 2018 2nd is adding... (16 Replies)
Discussion started by: kttan
16 Replies

LEARN ABOUT SUNOS

asadmin-delete-http-qos

asadmin-delete-http-qos(1AS)					   User Commands				      asadmin-delete-http-qos(1AS)

NAME

       delete-http-qos	- removes the quality of service parameter

SYNOPSIS

       delete-http-qos	--user admin_user[--password admin_password] [--host localhost][--port 4848][--passwordfile filename][--secure|-s] [--vir-
       tualserver virtual_server_ID]instance_name

       Removes the quality of service pamameter associated with the named server instance.

OPTIONS

       --user		       administrative user associated for the instance.

       --password	       administrative password corresponding to the administrative user.

       --host		       host name of the machine hosting the administrative instance.

       --port		       administrative port number associated with the administrative host.

       --passwordfile	       file containing passwords appropriate for the command (e.g., administrative instance).

       --secure 	       if true, uses SSL/TLS to communicate with the administrative instance.

       --virtualserver	       virtual server ID. It can also be referred to as the variable $id in an obj.conf file. A virtual server	ID  cannot
			       begin with a number.

OPERANDS

       instance_name	       name of the instance.

       Example 1: Using delete-http-qos

       asadmin> delete-http-qos --user admin --password adminadmin --host fuyako --port 7070 --virtualserver server1 server1
       Deleted HTTP QOS with id = server1

       Where: HTTP QOS is deleted for virtual server server1 and instance name server1.

EXIT STATUS

       0		       command executed successfully

       1		       error in executing the command

INTERFACE EQUIVALENT

       Server instance, HTTP Server Virtual Servers, Instance QOS page for the server instance

       asadmin-create-http-qos(1AS)

J2EE 1.4 SDK							    March 2004					      asadmin-delete-http-qos(1AS)
All times are GMT -4. The time now is 01:25 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy