Is there a way to search the content of a specific column of a csv file using the terminal. But that it still returns all the information of the rest of the columns.
I want to be able to search for a string in a column of a csv file and if it matches return all of the information in the same Row
Is there away of implementing it into a shell bash file and ask the user what string to search
Lets say your string to search is "name" in the 4th column, then use
awk -F ',' '$4 ~ /^name$/' filename.csv
awk -F',' '$N == "string to search"' filename.csv
Replace N with column number and filename.csv with filename to search
printf "please enter pattern to search:\n%s"; read pattern; awk -v patt="$pattern" -F',' '$N == patt' filename.csv
printf "please enter pattern to search:\n%s" jut prints the please enter pattern to search: then prints a new-line(\n). read pattern read from stdin and store the input into pattern variable. then in -v patt="$pattern", stored or entered string from user, copies into awk patt local variable and rest of the command search in column $N if it's equal with user entered input.
awk. Have you tried anything so far?awk -F, '$N == 'some string', replacing N with the column number under consideration.