Search and Substitute from 2 files


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Search and Substitute from 2 files
# 8  
Old 04-09-2009
To print only the lines that don't match:

Code:
awk 'NR==FNR{a[substr($0,1,4)]=substr($0,5);next}
!(substr($0,5,4) in a)
' fileb filea

Or in 2 files "match" and "nomatch":

Code:
awk 'NR==FNR{a[substr($0,1,4)]=substr($0,5);next}
substr($0,5,4) in a {print substr($0,1,4) a[substr($0,5,4)] substr($0,9);next}
{print $0 > "nomatch"}
' fileb filea > "match"

Regards
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Substitute one line of multiple files according to another file

I need to make ~96 configure files from a template config file which has hundreds of rows that looks like: template.config: #average insert size avg_ins=1000 ...... other information omitted Those config files are named in sequence from S01.config, S02.config, ... etc with different... (11 Replies)
Discussion started by: yifangt
11 Replies

2. UNIX for Dummies Questions & Answers

Partial match in two files then substitute

Hi, I was trying to figure this out but failed so I hope someone here can help me, thank you in advance. I have two files. file1: aa M bb N cc O dd P ee Q file2: aa A_87_P254063 cc A_87_P016532 bb A_87_P104793 dd A_87_P055331 ee A_87_P059706 aa A_87_P071636 ee A_87_P028302... (2 Replies)
Discussion started by: yuejian
2 Replies

3. Shell Programming and Scripting

search information in multiple files and save in new files

hi everyone, im stuck in here with shell :) can you help me?? i have a directory with alot files (genbank files ... all ended in .gbk ) more than 1000 for sure ... and i want to read each one of them and search for some information and if i found the right one i save in new file with new... (6 Replies)
Discussion started by: andreia
6 Replies

4. Shell Programming and Scripting

search for content in files. Name of files is in another file. Format as report.

Hi I have multiple files in a folder and one file which contains a list of files (one on each line). I was to search for a string only within these files and not the whole folder. I need the output to be in the form File1<tab>string instance 2<tab> string instance 2<tab>string instance 3... (6 Replies)
Discussion started by: pkabali
6 Replies

5. Shell Programming and Scripting

HELP WITH SEARCH AND SUBSTITUTE IN "|" DELIMITED FILE

Hi I have a "|" delimited file as shown below. 55987|2011-04-07|09:30: 8.0|09:30:27.4|9194 55988|2011-04 07|09:30:21.0|09:30:27.4|9199 55989|2011-04-07|09:30:25.0|09:30:27.5|9176 55990|2011-04-07|09:29:33.0|09:30:27.5|9196 55991|2011-04-07|09:30:21.0|09:30:27.5|9199... (3 Replies)
Discussion started by: alok3141
3 Replies

6. Shell Programming and Scripting

How to access files from different directories and to perform search action in those files?

Hi, I want to access files from different directories (for example: /home/dir1/file1 , /home/dir2/file2 ...) Like this i have to access these files(file1, file2...). (3 Replies)
Discussion started by: bangarukannan
3 Replies

7. SuSE

Search all files based on first and in all listed files search the second patterns

Hello Linux Masters, I am not a linux expert therefore i need help from linux gurus. Well i have a requirement where i need to search all files based on first patterns and after seraching all files then serach second pattern in all files which i have extracted based on first pattern.... (1 Reply)
Discussion started by: Black-Linux
1 Replies

8. Shell Programming and Scripting

sed doubt - search and substitute string from variable.

hi, trying to learn more abt sed :( i want to substitute a variable(a) with other variable(b) appended. Read.txt contains: home/test2/abc home/test/root1 input.txt contains: make test "home/test1/none"version="1.3" wt's wrong test "home/test2/abc"version="1.0" make save... (9 Replies)
Discussion started by: dragon.1431
9 Replies

9. UNIX for Dummies Questions & Answers

Trouble with search and substitute

Hi there, I have a file with 1800+ lines and all are something like this: drwx--x--x 12960 4096 Oct 6 2006 palfvoet drwx--x--x 67205 4096 May 9 05:21 pallsopp drwx--x--x palmgren 4096 Oct 6 2006 palmgren now, as you... (3 Replies)
Discussion started by: besgal
3 Replies

10. UNIX for Advanced & Expert Users

Search files with specfic extention and later search content

Hi, I would appriciate if somebody can help me figure out how to search for all the *.xml file under a specific directory and subdirectroies (/home/username) and later search of content "<start>" inside the xml file returned by search. -Lovin.V (2 Replies)
Discussion started by: lovi_v
2 Replies
Login or Register to Ask a Question
tracker-search(1)						   User Commands						 tracker-search(1)

NAME
tracker-search - Search all content for keywords SYNOPSIS
tracker-search [OPTION...] EXPRESSION [EXPRESSION...] DESCRIPTION
tracker-search searches all indexed content for EXPRESSION. The resource in which EXPRESSION matches must exist (see --all for more infor- mation). All results are returned in ascending order. In all cases, if no EXPRESSION is given for an argument (like --folders for example) then ALL items in that category are returned instead. EXPRESSION One or more terms to search. The default operation is a logical AND. For logical OR operations, see -r. OPTIONS
-?, --help Give a short help message. -l, --limit=N Limit search to N results. The default is 512. -o, --offset=N Offset the search results by N. For example, start at item number 10 in the results. The default is 0. -r, --or-operator Use OR for search terms instead of AND (the default) -d, --detailed Show the unique URN associated with each search result. This does not apply to --music-albums and --music-artists. -a, --all Show results which might not be available. This might bebecause a removable media is not mounted for example. Without this option, resources are only shown if they exist. This option applies to all command line switches except --music-albums and --music-artists. -f, --files=EXPRESSION Search for files of any type matching EXPRESSION (optional). -e, --folders=EXPRESSION Search for folders matching EXPRESSION (optional). -m, --music=EXPRESSION Search for music files matching EXPRESSION (optional). --music-albums=ALBUM Search for music albums matching ALBUM (optional). --music-artists=ARTIST Search for music artists matching ARTIST (optional). -l, --images=EXPRESSION Search for images matching EXPRESSION (optional). -v, --videos=EXPRESSION Search for videos matching EXPRESSION (optional). -t, --documents=EXPRESSION Search for documents matching EXPRESSION (optional). -e, --emails=EXPRESSION Search for emails matching EXPRESSION (optional). Returns a list of subjects for emails found. -c, --contacts=EXPRESSION Search for contacts matching EXPRESSION (optional). Returns a list of names and email addresses found. -V, --version Print version. SEE ALSO
tracker-store(1), tracker-stats(1), tracker-tag(1), tracker-info(1). GNU
July 2009 tracker-search(1)