Issue in grep


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Issue in grep
# 1  
Old 06-28-2012
Issue in grep

i have following pattern in file
Code:
s6:s2
s2:s4
s1:s2:s3:s4:s5:s6
s1
.
.

Now i want to find occurence of each record in file like s6:s2 occurs twice {once in first record and both occur in 3 record as well}

so output should be
Code:
s6:s2   2
s2:s4   2
s1:s2:s3:s4:s5:s6  :1
s1 : 2
                        ........

How to achive this.Also there are millions of records.so looking for best approach



Moderator's Comments:
Mod Comment Please view this code tag video for how to use code tags when posting code and data.

Last edited by vbe; 06-28-2012 at 01:14 PM..
# 2  
Old 06-28-2012
Try:
Code:
sort file | uniq -c

# 3  
Old 06-28-2012
With the above command we will get count as 1 for each record as each is unique in my example.

I want the occurence of the combination(one to many) in all records in file irrespective of the order.
# 4  
Old 06-28-2012
I dont think there is a simple way... you will have to start by creating a file or patterns (unique) then using a loop reading the pattern file count the occurences...
# 5  
Old 06-28-2012
OK... we'll talk about this record :

Code:
s6:s2

.

What if s6 occurs 2 times and s2 occurs 6 times? What would be the expected output for such a record?
# 6  
Old 06-28-2012
Quote:
Originally Posted by elixir_sinari
OK... we'll talk about this record :

Code:
s6:s2

.

What if s6 occurs 2 times and s2 occurs 6 times? What would be the expected output for such a record?
If i understood the original post, the goal is to count, for each record in the file, how many times all of the fields in that record occur together in a record (including itself), irrespective of order. If that's correct, then the answer to your question is, "it depends on how many times s2 and s6 are part of the same record."

Regards,
Alister
# 7  
Old 06-28-2012
Ok so your records (your lines) are made of a combination of 'simple' elements sX (no matter the order)

1. Is the number of simple elements numerous or limited ? (do these elements can be represented by letters ? prime numbers ? processors on which you parallelize tasks ?

2. Do these simple elements have a relation ship between them ?

3. Does it happen that a simple element occur more than once in a record ?
This User Gave Thanks to ctsgnb For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Issue with Grep

Hi guys, Hope someone can help me with this - I'm sure it's fairly simple but it's driving me mad! (forgive the coding - still new on scripting - come from Windows) I have the following coding for checking whether I want to include a line in a file:- EXTRACT_Date=$(date --date="${PERIOD}"... (6 Replies)
Discussion started by: NickF
6 Replies

2. Shell Programming and Scripting

Issue with grep

Hello, I have an input file that looks like so: LDLR LDLRAD4 VLDLR when I grep "LDLR" I get an output of: LDLR LDLRAD4 VLDLR Since all names have "LDLR" included within them, but all I want the output to be is LDLR I know it can work if I surround the words with pipes for... (5 Replies)
Discussion started by: Rabu
5 Replies

3. UNIX for Dummies Questions & Answers

Grep issue

HI, I have a command to check a license file. License_print. In that file you get the headlines and all different licenses. Now i want to have things extracted from it. so i do like following: license_print | grep -iw -e "user" -e "admin" But i donīt want all lines where user is... (11 Replies)
Discussion started by: Tzwaj
11 Replies

4. Shell Programming and Scripting

Grep issue

Hi Guys, I am new to shell scripting. Need help on grep command. I had a file called file.log which contain below statements. 12 Nov 2013 14:12:17,756 INFO security - Userid: raja, Saved File Instance, Name: , Registry: 23 Nov 2013 14:14:11,777 INFO security - Userid: raja, Saved... (7 Replies)
Discussion started by: Vinoth Kumar G
7 Replies

5. Shell Programming and Scripting

Grep issue

Hi All I have a file containing following records: $HEW_TGT_DB2_USER=hbme_bi2 $prmAttunityUser=ais $DS_USER=hbme_bi2 $prmStgUser=hbme_bi2 $prmuser=hbme_bi2 $prmStgPass=hbme_bi2 $prmpwd=hbme_bi2 $prmAttunityUser=ais Say suppose the name of the file is test4.txt When i fire this... (2 Replies)
Discussion started by: vee_789
2 Replies

6. UNIX for Dummies Questions & Answers

Grep issue

more Hello.txt it was a sunny way and i was about to go home. I need to grep and redirect to a new file all the text between 'sunny' and 'go' string above. Note: There may be multiple lines in between the string i need to grep between. If there are multiple 'go' strings it should grep till... (9 Replies)
Discussion started by: mohtashims
9 Replies

7. Shell Programming and Scripting

grep issue

The below command is not working stackmem="$(pmap $1 | grep -i '' | awk '{print $2}'| tr -d ' K')" I need to grep strictly for ----> Regards, Mohtashim (2 Replies)
Discussion started by: mohtashims
2 Replies

8. Shell Programming and Scripting

Grep Issue

<record> <set> <termId>1234</termId> <termType>First</termType> </set> <set> <termId>5678</termId> <termType>Second</termType> </set> </record> This is saved in record.xml Hi I have this sample XML that i am grepping using a shell program. The objective of the task is - based... (7 Replies)
Discussion started by: revertback
7 Replies

9. UNIX for Dummies Questions & Answers

Issue with grep

I have a file that has the following: 591066 100.0 591066 100.0 591066 100.0 591066 100.0 591066 100.0 591066 100.0 591066 100.0 591066 100.0 591066 100.0 591066 100.0 591066 100.0 ... (5 Replies)
Discussion started by: Pablo_beezo
5 Replies

10. UNIX for Dummies Questions & Answers

issue with grep

using grep, i have a file emp.lst, and i want all those records where "S" or "s" (capital or small) is not there i used this grep emp.lst when i use grep emp.lst i am getting rows with S..but why negate (^) is not working? (3 Replies)
Discussion started by: soujanya_srk
3 Replies
Login or Register to Ask a Question