Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Search in file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Search in file
# 8  
Old 09-27-2010
I have dedected a problem concerning the command:

If I have the following:

myAddress1 name1_2.3.3.4_test.txt myAddress1 name1_7.3.4_test.txt
myAddress1 name1_12.3.4_test.txt

and I set up the command

Code:
MYNAME=`grep -i myAddress1 ${FILENAME} | awk -F_ '{if($2>a){a=$2;b=$1}} END{split(b,s," ");print s[2]}'`

then I get

myAddress1 name1_7.3.4_test.txt
instead of

myAddress1 name1_12.3.4_test.txt
I actually don't know what I should change in order to get the right result.
Does anyone know how I can change this?
Thanks a lot!!
# 9  
Old 09-27-2010
Code:
# sed 's/\(name.*txt\) /\1\n/' file | sort -t'_' -k2,2 -n | tail -1
myAddress1 name1_12.3.4_test.txt

# 10  
Old 09-27-2010
The problem with the command is that I don't know "name1" or any other name.
The file also can have this content:

Code:
myAddress1	 name1_2.3.3.4_test.txt  
myAddress1	 name1_7.3.4_test.txt
myAddress1       otherName_12.3.4_test.txt

and then I should get "otherName" because this one has the higher version.
Is there any possibility to do this? Or do I have I misunderstood something?
Thanks!!!
# 11  
Old 09-27-2010
Quote:
Originally Posted by e9926044
The problem with the command is that I don't know "name1" or any other name.
The file also can have this content:

Code:
myAddress1     name1_2.3.3.4_test.txt  
myAddress1     name1_7.3.4_test.txt
myAddress1       otherName_12.3.4_test.txt

and then I should get "otherName" because this one has the higher version.
Is there any possibility to do this? Or do I have I misunderstood something?
Thanks!!!
This code sort to name or Othername column in string for sorting numeric

Code:
# sort -t'_' -k2,2 -n file| tail -1
myAddress1       otherName_12.3.4_test.txt

# 12  
Old 09-27-2010
Ok, I see.
Now I have the following command:
Code:
echo `grep -i ${name} ${FILENAME} | sort -t'_' -k2,2 -n | tail -1`

So as I understood until now I get all names from the file FILENAME with grep and then I sort it concerning the Versions with tail -1 I take the first one.
Then I get:
Code:
myAddress1       otherName_12.3.4_test.txt

From the result I now need in this case "otherName". In an older version I got it with this command:
Code:
grep -i ${Name} ${FILENAME} | awk -F_ '{if($2>a){a=$2;b=$1}} END{split(b,s," ");print s[2]}'

I guess, this is my last question in this direction.

How can I do it to get only the name, in this case "otherName"

Thanks for your great help!!
Last edited by Scott; 09-27-2010 at 04:44 PM.. Reason: Code tags
# 13  
Old 09-27-2010
Extend the working version of your command of

Code:
echo `grep -i ${name} ${FILENAME} | sort -t'_' -k2,2 -n | tail -1`

Code:
echo `grep -i ${name} ${FILENAME} | sort -t'_' -k2,2 -n | tail -1 | awk '{ split ($2,a,"_"); print a[1];`

It would help. Thx.
Last edited by Scott; 09-27-2010 at 04:45 PM.. Reason: Code tags
This User Gave Thanks to kmuthu_gct For This Post:
e9926044
# 14  
Old 09-28-2010
I would have one last question.
My Problem now is, that only the first Version number is considered.
If I have a file with the following content:

myAddress1 otherName1_12.3.4_test.txt
myAddress1 otherName2_12.4.4_test.txt

Then I get "otherName1" because only the version number 12 is considered with the command:

sort -t'_' -k2,2 -n

My question would be now can I consider all version numbers, so that e.g. the version 12.4.1.2 is higher than the version 12.3.1.

Thanks a lot!!!


[EDIT]
I solved it, I changed k2,2 to k2,30

Thanks a lot for all your great help!!!
All the best!
Last edited by e9926044; 09-28-2010 at 06:06 AM..
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Run a loop that will search for a file to thousand machine and know who owns the file

Run a loop that will search for a file to thousand machine and know who owns the file $ for i in abc{01..02} > do > echo -n $i > ssh $i "sudo find / -name .ssh -exec ls -l {} \;|grep id" > done abc01-rw-------. 1 root root 1675 Nov 10 2018 id_rsa abc01-rw-------. 1 root root 1675 Nov 14... (6 Replies)
Discussion started by: invinzin21
6 Replies

2. Shell Programming and Scripting

Read in search strings from text file, search for string in second text file and output to CSV

Hi guys, I have a text file named file1.txt that is formatted like this: 001 , ID , 20000 002 , Name , Brandon 003 , Phone_Number , 616-234-1999 004 , SSNumber , 234-23-234 005 , Model , Toyota 007 , Engine ,V8 008 , GPS , OFF and I have file2.txt formatted like this: ... (2 Replies)
Discussion started by: An0mander
2 Replies

3. UNIX for Dummies Questions & Answers

Search file and print everything except multiple search terms

I'm trying to find a way to search a range of similar words in a file. I tried using sed but can't get it right:sed 's/\(ca01\)*//'It only removes "ca01" but leaves the rest of the word. I still want the rest of the information on the lines just not these specific words listed below. Any... (3 Replies)
Discussion started by: seekryts15
3 Replies

4. Shell Programming and Scripting

Retrieving the relevant search from search file in the main file

I have two files: file 1: hello.com neo.com,japan.com,example.com news.net xyz.com, telecom.net, highlands.net, software.com example2.com earth.net, abc.gov.uk file 2: neo.com example.com abc.gov.uk file 2 are the search keys to search in file 1 if any of the search... (7 Replies)
Discussion started by: csim_mohan
7 Replies

5. Shell Programming and Scripting

Nested search in a file and replace the inner search

Hi Team, I am new to unix, please help me in this. I have a file named properties. The content of the file is : ##Mobile props east.url=https://qa.east.corp.com/prop/end west.url=https://qa.west.corp.com/prop/end south.url=https://qa.south.corp.com/prop/end... (2 Replies)
Discussion started by: tolearn
2 Replies

6. Shell Programming and Scripting

Search string within a file and list common words from the line having the search string

Hi, Need your help for this scripting issue I have. I am not really good at this, so seeking your help. I have a file looking similar to this: Hello, i am human and name=ABCD. How are you? Hello, i am human and name=PQRS. I am good. Hello, i am human and name=ABCD. Good bye. Hello, i... (12 Replies)
Discussion started by: royzlife
12 Replies

7. Shell Programming and Scripting

Perl - use search keywords from array and search a file and print 3rd field when matched

Hi , I have been trying to write a perl script to do this job. But i am not able to achieve the desired result. Below is my code. my $current_value=12345; my @users=("bob","ben","tom","harry"); open DBLIST,"<","/var/tmp/DBinfo"; my @input = <DBLIST>; foreach (@users) { my... (11 Replies)
Discussion started by: chidori
11 Replies

8. Shell Programming and Scripting

Optimised way for search & replace a value on one line in a very huge file (File Size is 24 GB).

Hi Experts, I had to edit (a particular value) in header line of a very huge file so for that i wanted to search & replace a particular value on a file which was of 24 GB in Size. I managed to do it but it took long time to complete. Can anyone please tell me how can we do it in a optimised... (7 Replies)
Discussion started by: manishkomar007
7 Replies

9. Shell Programming and Scripting

sed help - search/copy from one file and search/paste to another

I am a newbie and would like some help with the following - Trying to search fileA for a string similar to - AS11000022010 30.4 31.7 43.7 53.8 60.5 71.1 75.2 74.7 66.9 56.6 42.7 32.5 53.3 I then want to replace that string with a string from fileB - ... (5 Replies)
Discussion started by: ncwxpanther
5 Replies

10. Shell Programming and Scripting

Read a file and search a value in another file create third file using AWK

Hi, I have two files with the format shown below. I need to read first field(value before comma) from file 1 and search for a record in file 2 that has the same value in the field "KEY=" and write the complete record of file 2 with corresponding field 2 of the first file in to result file. ... (11 Replies)
Discussion started by: King Kalyan
11 Replies
Login or Register to Ask a Question