file 1 and 2 are list of keywords
1 is
a
b
c
d

2 is
aa
aaa
b
bb
ccc
d

I want the AWK script to give us the number of times every keyword in file 1 occurs in file 2.
output should be
a 2
b 2
c 1
d 1

I have a stream of data like below:

By using AWK and substr I am extracting the data, but I need to perform a substr based on the year. Say if Year is less than 2011 then I have to extract 9th char for output 3rd column and if Year is greater than or equal 2011, I have to extract 11th char for output 3rd column.

Thanks.

Output needed is:

2,3,1,0.0,0.0,4
1,2,3,0.0,0.0,0.0,0.0,5,
8,7,3,4,0.0,0.0,0.0,

I have tried reading the file each line, using AWK to parse to find out “,,” and then insert 0.0 . It works but very slow. Need some faster solution please.

Requirement :-
I have shell script in kern shell ,have to run alternate week per month
example-today’s date is 27 Mar 2013 and my script will run today then for the next time when it will run it should check 1st what was the last run date(27 Mar 2013) if it is matched 15days from current date then run else sent a mail with waning mgs.

i have a AWK command it is checking only within a month
date +%Y:%m:%d|awk -vFS=”:” -vOFS=”:” ‘{$3=$3-3;print}’
suppose i am checking 20days from current date it is give some negative value
ex-2013:03:-8

Please give some advice me so i can move forward.

Thank you All.

Regards,
Krupa

I have a little bit of complicated task to finish with AWK. Here it is;
I have a data file in xml format which looks like this

lets say each data block contains 5 rows and 5 columns, what I need to do is this;
I have a condition, and I need to find the row that satisfies this condition then
I need to add an extra field to each row whose value will be calculated using
the columns of the row that satisfies the condition as well as other columns in
other rows. As an example, lets say row “c” satisfies my condition, then I add
an extra field to data which will look like this

where the last fields are calculated as following;

the algebra on the above calculation may not necessarily be simple as this.

Thanks for any help.

I think I need to use AWK – however I have no experience of it. Can someone help please?

I have a file like this but with many more records – it is fixed width
THIS15021X 799999 XX 00000099999 00008888888 XX 15022013
THISQ15021X 999999 XX 00000099999 00008888888 XX 15022013
BLAS15021X 9999999XX 00000199999 00008888888 XX 15022013

I want the file to look like this again it is fixed width
THIS15021X 0799999 XX 00000099999 00008888888 XX 15022013
THISQ15021X 0999999 XX 00000099999 00008888888 XX 15022013
BLAS15021X 9999999 XX 00000199999 00008888888 XX 15022013

I want to add a leading 0 to the 2nd coloumn if it contains the word this at the beginning

I have two files as follow:
[CODE]AFFY_ID RS_ID CHROMOSOME POS_START POS_END ALLELE1 ALLELE2
SNP_A-1780283 rs17011450 chr4 127630275 127630276 C T
SNP_A-1780285 rs6919430 chr6 90919464 90919465 A C
SNP_A-1780286 — chr7 104281409 104281410 A G
SNP_A-1780301 rs2342723 chr16 5748790 5748791 C T[/CODE]

And the second file:

What I need is to match the first columns of two files and print the second column of the first file into the second file, so, the output would be:

SNP_A-1780301 rs2342723 2 181.55 G A

How could I do this with AWK?

Thanks a lot!

i have publicly available txt file with little less than 300000 rows. i want to extract from column 1 to column 218 and save it in another text file. i use the cut command but the file is saved with multiple rows from the source file onto a single row in the destination. basically it is not formatted like the source file. the source file is in the below link. i have removed the www since this is my first post and the file name is INP_psf1301.txt

cms.gov/Medicare/Medicare-Fee-for-Service-Payment/ProspMedicareFeeSvcPmtGen/Downloads/INP_psf1301.zip

i use the following

but the resulting file is is not formatted like the original. i want the resulting file to be exactly the same except without the last few columns. i want columns 1 to 218 in the resulting file.

is there a line break or something that i should mention or would AWK command work better?

thanks

My question is not how sed edits a stream and outputs it to a file, rather something like this below:

I have a .txt with some text in it :rolleyes:

abc:123:xyz
123:abc:987
qwe:145:123

Is there a way, to use sed to get, say “123:abc:987”, convert it to string “123,abc,$987” and standard output it to screen? No file overwrite allowed

I have tried things like
1)
sed -i “s/:/,/g” file.txt –> this of course will change all “:” to “,”
2)
sed -n /123,abc,/p file.txt –> print only matching
3)
sed -i “s/,/:/g” file.txt –> convert back to “:”

I have tried some piping but i think I may have the wrong idea of pipe (eg. “| echo” and wondering why no output)

Could you guys throw me some ideas?
Some of my other friends was mentioning AWK.
Note that stupid “$” 😡