awk pattern search and put in a file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting awk pattern search and put in a file
# 8  
Old 12-17-2009
its like

1 ab gbh bnh bnhg hjh ghyh uio OTF gjgk jhkj
2 cv hjkj nlkl nknkn knk kkp kpkp SPI jhlk jl;kj


Please serch in the 9 th column OTF or SPI if persent then redirect the complete row to a new file
# 9  
Old 12-17-2009
Quote:
Originally Posted by pranabrana
its like

1 ab gbh bnh bnhg hjh ghyh uio OTF gjgk jhkj
2 cv hjkj nlkl nknkn knk kkp kpkp SPI jhlk jl;kj


Please serch in the 9 th column OTF or SPI if persent then redirect the complete row to a new file
https://www.unix.com/302381070-post2.html
# 10  
Old 12-17-2009
its like

1 ab gbh bnh bnhg hjh ghyh uio OTF gjgk jhkj
2 cv hjkj nlkl nknkn knk kkp kpkp SPI jhlk jl;kj


Please serch in the 9 th column OTF or SPI if persent then redirect the complete row to a new file
# 11  
Old 12-17-2009
Hi Pranabrana,

cat file | awk ' { if ($9 == "OTF" || $9 == "SPI" ) print $0 }' > file1

Hope this will help you.

-Vijay.
# 12  
Old 12-17-2009
Quote:
Originally Posted by ichigo
Code:
gawk  '$9~/^(OTF|SPI)$/'  file


Hey it Works !!!!Smilie Thak you very very very much


Pranba RanaSmilieSmilieSmilie

---------- Post updated at 07:35 PM ---------- Previous update was at 07:33 PM ----------

Quote:
Originally Posted by vijay_vasanth
Hi Pranabrana,

cat file | awk ' { if ($9 == "OTF" || $9 == "SPI" ) print $0 }' > file1

Hope this will help you.

-Vijay.

Thanks it works.

SmilieSmilieSmilieSmilieSmilieSmilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Grep/awk using a begin search pattern and end search pattern

I have this fileA TEST FILE ABC this file contains ABC; TEST FILE DGHT this file contains DGHT; TEST FILE 123 this file contains ABC, this file contains DEF, this file contains XYZ, this file contains KLM ; I want to have a fileZ that has only (begin search pattern for will be... (2 Replies)
Discussion started by: vbabz
2 Replies

2. Shell Programming and Scripting

Search for a pattern in a String file and count the occurance of each pattern

I am trying to search a file for a patterns ERR- in a file and return a count for each of the error reported Input file is a free flowing file without any format example of output ERR-00001=5 .... ERR-01010=10 ..... ERR-99999=10 (4 Replies)
Discussion started by: swayam123
4 Replies

3. Shell Programming and Scripting

Awk to match a pattern and perform a search after the first pattern

Hello Guyz I have been following this forum for a while and the solutions provided are super useful. I currently have a scenario where i need to search for a pattern and start searching by keeping the first pattern as a baseline ABC DEF LMN EFG HIJ LMN OPQ In the above text i need to... (8 Replies)
Discussion started by: RickCharles
8 Replies

4. Shell Programming and Scripting

awk get search pattern from a file.

Here Is a problem I am facing with awk. Query --> I want to search for a string in a file and print next 15 lines below the matched string. 1.We do not have GNU grep so cannot use grep -A or grep -B commands. 2. Instead of passing the search pattern as a string to awk. I want the awk to... (4 Replies)
Discussion started by: togotutor
4 Replies

5. Programming

search file and put into struct

hi everybody, I need some help with some programming. I need to write a file that can search in a text file and read the whole line into a struct. the struct = struct Transistor { char chType; char chFabrikant; float fPrijs; enum Transistor_Behuizing { empty,TO18, TO39,... (8 Replies)
Discussion started by: metal005
8 Replies

6. UNIX for Advanced & Expert Users

use of variables in awk to search for pattern from a file

Hi, I need to extract all the content between two strings stored in two variables "startstring" and "endstring" startstring=hello enstring=world #notworking awk '/$startstring/, $NF ~ /$endstring/ ' file > file2 The above code is not working with variables. It works when actual string... (2 Replies)
Discussion started by: jeanjkj
2 Replies

7. Shell Programming and Scripting

Help to search multiple pattern in file with grep/sed/awk

Hello All, I have a file which is having below type of data, Jul 19 2011 | 123456 Jul 19 2011 | 123456 Jul 20 2011 | 123456 Jul 20 2011 | 123456 Here I wanted to grep for date pattern as below, so that it should only grep "Jul 20" OR "Jul ... (9 Replies)
Discussion started by: gr8_usk
9 Replies

8. Shell Programming and Scripting

Awk/Sed: Search Pattern from file and Print

Hi, I want to search for patterns (from a file) in a file and print the line matching the patterns and the line before it. I have to search for 100s of patterns from a file. Any help with AWK or Sed. Thanks! (2 Replies)
Discussion started by: saint2006
2 Replies

9. Shell Programming and Scripting

Awk search for string pattern in delimited file

I've got a semicolon delimited file. I would like to search for fields that match a pattern, and not hardcoded eg "mth". *th=something If the delimited field fulfills this condition, eg. mth=value I would like to print out both key and value for some number comparison. eg. if value > "12"... (5 Replies)
Discussion started by: alienated
5 Replies

10. Shell Programming and Scripting

search a word in a xml file and print the out put

hi , i m having a html file and this file looks like this <ssl> <name>PIA</name> <enabled>true</enabled> <listen-port>39370</listen-port> </ssl> <log> <name>PIA</name> </log> <execute-queue> <name>weblogic.kernel.Default</name> ... (7 Replies)
Discussion started by: becksram123
7 Replies
Login or Register to Ask a Question