UNIX for Beginners Questions & Answers

I have number of csv files (like tmo_2019*). In these files some files have 5th column value as V. I want to copy those files having 5th column value as V to specific directory /test/V_files/.

I tried to extract file names by below but not able to complete command for copy.

Code:

find -type f -iname "tmo*"  -exec awk -F',' '$5 == "V" {print FILENAME}'  {} \;

How to complete command to copy these files having 5th column value as V.

Thanks In advance

How far would this (untested) get you?

Code:

awk -F',' '$5 == "V" {print "cp " FILENAME " /test/V_files/"}' tmo* | sh

In awk better print "quotes" around the filenames because they become command arguments in sh where unquoted arguments are subject to substitutions.

Code:

{print "cp \"" FILENAME "\" /test/V_files/"; exit}

The exit ensures that the filename is printed only once.

Hi
If there are multiple files should be used ; nextfile instead ; exit

Might work as well:

Code:

cp -v $(grep -lE "([^,]*,){4}V," tmo*) /test/V_files/