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 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

Is this a new Fibonacci Identity?

Image
6 1 $begingroup$ I have found the following Fibonacci Identity (and proved it). If $F_n$ denotes the nth Fibonacci Number, we have the following identity begin{equation} F_{n-r+h}F_{n+k+g+1} - F_{n-r+g}F_{n+k+h+1} = (-1)^{n+r+h+1} F_{g-h}F_{k+r+1} end{equation} where $F_1 = F_2 = 1$ , $r leq n$ , $h leq g$ , and $n, g, k in mathbb{N}$ . It is not too hard to show that this identity subsumes Cassini's Identity, Catalan's Identity, Vajda's Idenity, and d'Ocagne's identity to name a few. I have done a pretty thorough literature review, and I have not found anything like this, but I am still wondering if anyone has seen this identity before? I found this by accident after noticing some patterns in some analysis work I was doing, so if this is already known I would be curious to see w...
Read more

19世紀

Image
この記事は検証可能な参考文献や出典が全く示されていないか、不十分です。 出典を追加して記事の信頼性向上にご協力ください。 （ 2012年3月 ） 千年紀: 2千年紀 世紀: 18世紀 - 19世紀 - 20世紀 十年紀: 1800年代 1810年代 1820年代 1830年代 1840年代 1850年代 1860年代 1870年代 1880年代 1890年代 19世紀に君臨した大英帝国。 19世紀 （じゅうきゅうせいき）は、西暦1801年から西暦1900年までの100年間を指す世紀。 目次 1 19世紀の歴史 1.1 国民国家の成立 1.2 帝国主義の興隆 1.3 列強の植民地争奪戦 2 できごと 2.1 1800年代 2.2 1810年代 2.3 1820年代 2.4 1830年代 2.5 1840年代 2.6 1850年代 2.7 1860年代 2.8 1870年代 2.9 1880年代 2.10 1890年代 2.11 1900年代 3 文化 3.1 文学 3.2 音楽 3.3 思想 3.4 科学 3.5 技術 4 人物 4.1 ヨーロッパ 4.1.1 政治家・王族 4.1.1.1 フランス 4.1.1.2 オーストリア＝ハンガリー 4.1.1.3 ロシア 4.1.1.4 イギリス 4.1.1.5 ドイツ（プロイセンほかドイツ領邦を含む） 4.1.1.6 北欧 4.1.1.7 イタリア 4.1.1.8 スペイン 4.1.1.9 ベルギー 4.1.1.10 ギリシア 4.1.2 軍人 4.1.3 実業家 4.1.4 科学と技術 4.1.5 思想と哲学・人文諸学 4.1.6 宗教 4.1.7 文学 4.1.8 美術 4.1.9 音楽 4.1.10 社会事業家 4.1.11 探検家・旅行家 4.1.12 料...
Read more