Contents
How do I grep a specific column in Linux?
The -F, parameter specifies the delimiter, which is set to a comma for your data. $2 refers to the second column, which is what you want to match on. “ST” is the value you want to match.
How do I grep a specific line in Linux?
The -n ( or –line-number ) option tells grep to show the line number of the lines containing a string that matches a pattern. When this option is used, grep prints the matches to standard output prefixed with the line number. The output below shows us that the matches are found on lines 10423 and 10424.
How to grep rows that have certain value in a specific column?
The OP is wanting to use grep, which will print the whole line when a match is found, so the only thing to do is create the pattern that matches all and only what is required. Simplicity itself, and no reason to use sed or awk as `grep can handle the source as a file or a pipe.
How to use grep on column in AWK?
Here I want to only grep the pattern ST in 2nd column. How to do this ? Without doing some fancy RegEx where you count commas, you’re better off using awk for this problem. The -F, parameter specifies the delimiter, which is set to a comma for your data. $2 refers to the second column, which is what you want to match on.
What happens when a grep is sent to the background?
What is happening with this dual grep command is that the first grep is being sent to the background with the & operator. As it is sent to background, the next grep command executes immediately afterwards giving you a uniform output.
Is there a way to retain the first column in a column?
If you want to retain the first column and a column which contains a specific string in the first row (eg. B), then this should work. It assumes that your string is only present once though. There is probably a better solution with amazing awk, but this should work.