In awk, I want to print the 4th column values if 2nd and 3rd column matches? [on hold]
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
New contributor
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.
|
show 1 more comment
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
New contributor
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
|
show 1 more comment
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
New contributor
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
New contributor
New contributor
edited 19 hours ago
New contributor
asked 22 hours ago
Dimple
11
11
New contributor
New contributor
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
|
show 1 more comment
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
|
show 1 more comment
0
active
oldest
votes
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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