In awk, I want to print the 4th column values if 2nd and 3rd column matches? [on hold]












0














i have 4 columns 25000 rows, i want values printed of 4th column if my 2nd and 3rd columns are matching ?



e.g 



ssss thisis cool 5

pppp thisis hot  4

tttt thisis nice 7

rrrr thisis bad  9

cccc thisis cool 3


output should be:



             ssss   cccc

thisis cool   5      3





awk







share|improve this question









New contributor




Dimple is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











put on hold as unclear what you're asking by G-Man, Sparhawk, Kusalananda, andcoz, RalfFriedl 17 hours ago


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.















  • Your question is not clear, I see 5 columns. You want the 5th column to be printed, if the 2nd, 3rd and 4th match?
    – chaos
    21 hours ago










  • consider thisis as 1 column total 4 column if 2nd and 3rd matches i want 4th column values to be printed as output
    – Dimple
    19 hours ago








  • 1




    Sorry @dimple, what do 2nd and 3rd column have to match? Do you mean "If 2nd and 3rd column are equal"? In your example, "thisis" is clearly not equal to "cool".
    – andcoz
    19 hours ago










  • Hey sorry, i mean second and third column of 1st row is matching to 2nd and 3rd column of 5th row then print the values........
    – Dimple
    19 hours ago










  • thisis cool matches to thisis cool in two different rows then print the values as above mentioned output :
    – Dimple
    19 hours ago


















0














i have 4 columns 25000 rows, i want values printed of 4th column if my 2nd and 3rd columns are matching ?



e.g 



ssss thisis cool 5

pppp thisis hot  4

tttt thisis nice 7

rrrr thisis bad  9

cccc thisis cool 3


output should be:



             ssss   cccc

thisis cool   5      3





awk







share|improve this question









New contributor




Dimple is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











put on hold as unclear what you're asking by G-Man, Sparhawk, Kusalananda, andcoz, RalfFriedl 17 hours ago


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.















  • Your question is not clear, I see 5 columns. You want the 5th column to be printed, if the 2nd, 3rd and 4th match?
    – chaos
    21 hours ago










  • consider thisis as 1 column total 4 column if 2nd and 3rd matches i want 4th column values to be printed as output
    – Dimple
    19 hours ago








  • 1




    Sorry @dimple, what do 2nd and 3rd column have to match? Do you mean "If 2nd and 3rd column are equal"? In your example, "thisis" is clearly not equal to "cool".
    – andcoz
    19 hours ago










  • Hey sorry, i mean second and third column of 1st row is matching to 2nd and 3rd column of 5th row then print the values........
    – Dimple
    19 hours ago










  • thisis cool matches to thisis cool in two different rows then print the values as above mentioned output :
    – Dimple
    19 hours ago
















0












0








0







i have 4 columns 25000 rows, i want values printed of 4th column if my 2nd and 3rd columns are matching ?



e.g 



ssss thisis cool 5

pppp thisis hot  4

tttt thisis nice 7

rrrr thisis bad  9

cccc thisis cool 3


output should be:



             ssss   cccc

thisis cool   5      3





awk







share|improve this question









New contributor




Dimple is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











i have 4 columns 25000 rows, i want values printed of 4th column if my 2nd and 3rd columns are matching ?



e.g 



ssss thisis cool 5

pppp thisis hot  4

tttt thisis nice 7

rrrr thisis bad  9

cccc thisis cool 3


output should be:



             ssss   cccc

thisis cool   5      3





awk




awk






share|improve this question









New contributor




Dimple is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.











share|improve this question









New contributor




Dimple is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









share|improve this question




share|improve this question








edited 19 hours ago





















New contributor




Dimple is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.









asked 22 hours ago









Dimple

11




11




New contributor




Dimple is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.





New contributor





Dimple is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.






Dimple is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.




put on hold as unclear what you're asking by G-Man, Sparhawk, Kusalananda, andcoz, RalfFriedl 17 hours ago


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.






put on hold as unclear what you're asking by G-Man, Sparhawk, Kusalananda, andcoz, RalfFriedl 17 hours ago


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.














  • Your question is not clear, I see 5 columns. You want the 5th column to be printed, if the 2nd, 3rd and 4th match?
    – chaos
    21 hours ago










  • consider thisis as 1 column total 4 column if 2nd and 3rd matches i want 4th column values to be printed as output
    – Dimple
    19 hours ago








  • 1




    Sorry @dimple, what do 2nd and 3rd column have to match? Do you mean "If 2nd and 3rd column are equal"? In your example, "thisis" is clearly not equal to "cool".
    – andcoz
    19 hours ago










  • Hey sorry, i mean second and third column of 1st row is matching to 2nd and 3rd column of 5th row then print the values........
    – Dimple
    19 hours ago










  • thisis cool matches to thisis cool in two different rows then print the values as above mentioned output :
    – Dimple
    19 hours ago




















  • Your question is not clear, I see 5 columns. You want the 5th column to be printed, if the 2nd, 3rd and 4th match?
    – chaos
    21 hours ago










  • consider thisis as 1 column total 4 column if 2nd and 3rd matches i want 4th column values to be printed as output
    – Dimple
    19 hours ago








  • 1




    Sorry @dimple, what do 2nd and 3rd column have to match? Do you mean "If 2nd and 3rd column are equal"? In your example, "thisis" is clearly not equal to "cool".
    – andcoz
    19 hours ago










  • Hey sorry, i mean second and third column of 1st row is matching to 2nd and 3rd column of 5th row then print the values........
    – Dimple
    19 hours ago










  • thisis cool matches to thisis cool in two different rows then print the values as above mentioned output :
    – Dimple
    19 hours ago


















Your question is not clear, I see 5 columns. You want the 5th column to be printed, if the 2nd, 3rd and 4th match?
– chaos
21 hours ago




Your question is not clear, I see 5 columns. You want the 5th column to be printed, if the 2nd, 3rd and 4th match?
– chaos
21 hours ago












consider thisis as 1 column total 4 column if 2nd and 3rd matches i want 4th column values to be printed as output
– Dimple
19 hours ago






consider thisis as 1 column total 4 column if 2nd and 3rd matches i want 4th column values to be printed as output
– Dimple
19 hours ago






1




1




Sorry @dimple, what do 2nd and 3rd column have to match? Do you mean "If 2nd and 3rd column are equal"? In your example, "thisis" is clearly not equal to "cool".
– andcoz
19 hours ago




Sorry @dimple, what do 2nd and 3rd column have to match? Do you mean "If 2nd and 3rd column are equal"? In your example, "thisis" is clearly not equal to "cool".
– andcoz
19 hours ago












Hey sorry, i mean second and third column of 1st row is matching to 2nd and 3rd column of 5th row then print the values........
– Dimple
19 hours ago




Hey sorry, i mean second and third column of 1st row is matching to 2nd and 3rd column of 5th row then print the values........
– Dimple
19 hours ago












thisis cool matches to thisis cool in two different rows then print the values as above mentioned output :
– Dimple
19 hours ago






thisis cool matches to thisis cool in two different rows then print the values as above mentioned output :
– Dimple
19 hours ago












0






active

oldest

votes

















0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes

-

Popular posts from this blog

How to reconfigure Docker Trusted Registry 2.x.x to use CEPH FS mount instead of NFS and other traditional...

Image
0 I am having trouble trying to reconfigure my DTR container to try and use a CEPH FS mount we created to act as a storage backend for our image repository. The Docs are very vague on this and nothing exactly explains on how to do it. Has anyone yet connected the dots? linux filesystems mount storage docker share | improve this question asked Feb 1 at 6:40 jRapp3r jRapp3r 1 1 add a comment  | 
Read more

is 'sed' thread safe

Image
2 If I have a shell/python script that uses sed to modify a file in place based on user inputs, and then two users run the same script at the same time or approx. same time, is 'sed' thread safe ? Or perhaps it is not an issue because the file_descripor that was opened by the first thread will be used to lock the file anyway ? thx linux sed python share | improve this question edited 7 hours ago Jeff Schaller 42.9k 11 59 137 asked 7 hours ago terreys terreys
Read more

How to make a Squid Proxy server?

Image
1 I want to set up squid proxy server for monitoring user activity in a network and Internet Web URL filtering for user. I also want to configure the user login, user log, user access group, and block unwanted web sites in my network. Please help me and guide me the full process to do this. server proxy squid share | improve this question edited Jul 31 '12 at 14:45 Jorge Castro 37.1k 107 422 617 asked Jul 31 '12 at 5:16 Goivind Tiwari Goivind Tiwari
Read more