I wanted first column to be selected by default and den all the numeral columns i.e. column 2,4,6,8.
Major issue is the columns are volatile....
i.e. everyday there is one more script of mine which will add columns i.e. paste columns...
plzzzz help!!!!
Above mentioned is the required o/p...
one more thing is the columns are volatile dey are not fixed.....
i.e i wan the 1st column by default and den i want all the even columns i.e 2,4,6,8..... goes on
Bipin thanks for that.... once i executed ur awk script den i realised i had one more problem..... :P i.e. there are chances few times that the column just gives blank value not 0.... so cani replace those columns with blank value as 0....??
Hi all. Wondering if someone can help with an awk solution to a problem I'm stumped with.
I have a matrix file with >1000 fields and would like to add another column after each column with a text label. For example:
Input:
$cat file.txt
name col1 col2 col3 coln
aaaa ... (2 Replies)
Hi
I am having a csv file like this
ahsh,90.82,add,32424,ahha
hhdh,98.89,hdhdh,92728,neha
hshs,you,97.7,hdhdhd,are,a
jsjsj,wonderful,9788,79.9,aheh
ahdh,95.5,girl, 2737,jolllI need to add width="100" to the value which is greater than 90 like decimal points but less than 100
Output... (5 Replies)
Hi everyone. I have a file with ~500 columns and I would like to perform a simple calculation on every two columns. The file looks like this:
$cat input
id A B C D E F.....X
1 2 4 2 3 4 1 n
2 4 6 4 6 4 5 n
3 4 7 5 2 2 3 n
4 ... (5 Replies)
Hello! Well, I searched and wasn't able to find a specific example of my dilemma, so hopefully someone could assist? Or maybe there was an example but I missed it?
I have two files:
file1 = order data file
file2 = list of 65,000+ order numbers
I would like to extract from 'file1' any... (5 Replies)
I want to make a bff installp package which should be AIX5.2 compatible, but i don't know how to mark a file as volatile within the mkinstallp's template file. Anyone could help pls? (1 Reply)
I am writing a awk script that gathers certain data from certain fields. I needed a awk solution for this, because it will later become a function in the script.
I have the following data that I need output on a single line, but record spans across multilple lines and records are not... (7 Replies)
Hi guys
I have my 5th column like this
12
12:00
12:13:14
5-12:13:14
Meaning
5 days 12 hrs 13 minutes and 14 seconds
I need to split this column into above meaning format. But all other columns are separated by single while space.
I am using awk command to print other... (8 Replies)