Search Results

How many lines in each of these files? If each of these files have more than one line, are all the FIELD 12's the same? I don't see your sample file that you say is attached.

How many lines from the files are in the single line above? grep returns the file name : then the line in the file. # example:
filename:[line with the matching item] I see several colons on the...

It helps if you were to specify the actual field delmiter and a sample of the file instead of the grep.

It seems you are using , (comma as the field delimiter)
So

awk -F\, "{print $12}"...

I am sure it must be a more elegant solution and more efficient.

If I understood correctly, you want to rename the file BW*2014*.csv if the field 12 is "No" and remove those lines matching.

#...

Remove BEGIN block it should work, its executed before reading anything

This was supposed to be

echo -e "a b c\nd e f\ng h i" | awk '$2 != "e"{exit 2}'; echo $?

---------- Post updated at...

Hello kekanap,

Following may help you.


awk -F"," '{$4=$7=$39} 1' OFS="," Input_file


NOTE: This is not tested code.

Thanks,
R. Singh

did you miss 's/sed -i 's/*pax1.csv:BW-CDR/BW-CDR/g' pax1.csv

Try awk ' {for (i=0; i<=3; i++) S[i]+=$(ST+i)*SGN}
END {printf "MHG - Inbound Final\t"; for (i=0; i<=3; i++) printf "%s\t", S[i]; printf "\n"}
'...

Add the below command to your command
awk '{sub("@", "A@", $2)}1' FS=','

cat investigate.csv |grep "BSO,BST,PGWI"| cut -f24,28 -d"," | sort -u | awk '{sub("@", "A@", $2)}1' FS=','

You can...

awk '{print $1}' inputfile > output

You want the highest field 2 value for each unique field 1? (If so, your output data appears to be missing a few rows, e.g. for 335550)

You could do something like:
awk '{ if ($2 > rates[$1]) {...

Are some numbers are missing from your output?

$ sort -u -r -n <input file>
415550 0.21
335550 0.28
315550 0.28
215650 0.28
130650 0.22
125550 0.28
122850 0.22
120650 0.22
105550 0.28...

What have you tried?

Try:
awk '{sub(/..$/,"-&",$9); sub(/..-/,"-&",$9)}1' FS=, OFS=, file

Try:perl -F, -ape '$F[8]=~s/(\d{4})(\d\d)(\d\d)/$1-$2-$3/;$_=join ",", @F' input

Please submit new thread for this new problem.

Your file is not comma separated

for given input this should work

$ awk 'NR==1{$0=$0 OFS "Prefix"}1' file

if your real data is comma separated use following

$ awk 'NR==1{$0=$0 OFS...

Did you mean-

awk -F"," '/",Call Forward Not Reachable"/, { T=$4 ; $4=$36 ; $36=T } 1' *2013*

Input appears to be a csv file.

grep ",Call Forward Not Reachable" *2013* | awk 'BEGIN{OFS=FS=","}; {a=$4; $4=$36; $36=a;}1'

awk -F"," -v OFS="," '{ T=$4 ; $4=$36 ; $36=T } 1'

How about this?
awk -F',' '$14~/910[0123] && $42 != 0' *_201304*.csv | wc -l > pax1

Here 910[0123] will evaluate to 9100, 9101, 9102, 9103

regards,
juzz4fun

awk -F',' ' if ($14==9101' && $42!=0) ' *_201304*.csv|wc -l > pax1

Create a script:

for i in *_201304*.csv
do awk -F',' '$14~/910[0123]/ && $42 != 0' $i | wc -l >> parx1
done

Hope this helps..

Looks difficult for me to express all these using single regexp/pattern, but surely you can do that using multiple awk.

You forgot the pipes in the regex: $14 ~ /9100|9101|9102|...