Search Results

Thanks for the script. It worked!

Hi,

I have multiple files in a directory. Each file will have a header.I have to check if any of the files has 0 rows other than the header then I have to delete the files.
Here “ Empty file” in...

Thank you.

awk -F',' \
' { if ( substr($7,2,2) == "01" || $4 == "01" ) { print $0; } }' test.txt
This works.

awk -F"," ' { if (substr($4,2,2))= "01" printf $0 }' test.txt

It still gives me the error
The error context is
{ if >>> (substr($4,2,2))= <<< "01" printf $0 }
awk: The...

The data in my test file looks like this example below

"abcd","1234","001245","01","956769","","",""
"abcd","1234","001245","02","956769","",""
"abcd","1234","001245","03","956769","N","",""...

I have a file which is comma separated and has quotes. I can use this command and
awk -F"," '{ if ($4=="01" print $0 }' test.txt
But this doesn't fetch me the data.since it has quotes.
If the...

I have a file which is comma separated and has quotes. I can use this command and
awk -F"," '{ if ($4=="01" print $0 }' test.txt
But this doesn't fetch me the data.since it has quotes.
If the...

I have a file which is comma separated and has quotes. I can use this command and
awk -F"," '{ if ($4=="01" print $0 }' test.txt
But this doesn't fetch me the data.since it has quotes.
If the...