I need to calculate 2nd column of input with different function, based on 1st column.
if colum 1st contain CE2_12-15 do (4086-$1)*2
if colum 1st contain CE2_12-52 do ($1-836)*2
if colum 1st contain CE2_12-54 do ($1-1088)*2
...
...
I am unable to spit the file based on the 2nd column passing as a parameter with awk command.
Source file:
“100”,”customer information”,”10000”
“200”,”customer information”,”50000”
“300”,”product information”,”40000”
script: the command is not allowing to pass the parameters with the awk... (7 Replies)
Hi friends,
My file is like:
Second file is :
I need to print the rows present in file one, but in order present in second file....I used
while read gh;do
awk ' $1=="' $gh'" {print >> FILENAME"output"} ' cat listoffirstfile
done < secondfile
but the output I am... (14 Replies)
Hello Expert,
I need to transpose Date-Timestamp based on same column values and calculate time difference. The input file would be as below and required output is mentioned in the bottom
INPUT File
========
08/23/2012 12:36:09 JOB_5340
08/23/2012 12:36:14 JOB_5340
08/23/2012... (2 Replies)
Hi Friends,
Require a quick help to write the difference between 2 timestamps based on a unique column value:
Input file:
08/23/2012 12:36:09,JOB_5340,08/23/2012 12:36:14,JOB_5340
08/23/2012 12:36:22,JOB_5350,08/23/2012 12:36:26,JOB_5350
08/23/2012 13:08:51,JOB_5360,08/23/2012... (4 Replies)
Hi,
I would like to calculate the average of column 'y' based on the value of column 'pos'.
For example, here is file1
id pos y c
11 1 220 aa
11 4333 207 f
11 5333 112 ee
11 11116 305 e
11 11117 310 r
11 22228 781 gg
11 ... (2 Replies)
Hi,
I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column)
The input is for example, after sorted:
K00001 1 1 4 3... (8 Replies)
I have file that looks like this,
DIP-17571N|refseq:NP_651151 DIP-17460N|refseq:NP_511165|uniprotkb:P45890 DIP-17571N|refseq:NP_651151
DIP-19241N|refseq:NP_524261 DIP-19241N|refseq:NP_524261 DIP-17151N|refseq:NP_524316|uniprotkb:O16797
DIP-19588N|refseq:NP_731165 ... (2 Replies)
I would like to have some help in calculating 5th percentile value of column 2 for each site, the input is like below:site val1 val2
002 10 25.3
002 20 25.3
002 30 25.3
002 40 20
002 50 20
002 60 20
002 70 20
002 80 30
002 90 30
002 100 30
002 120 30
003 20 30.3
003 20 30.3
003 30 20... (2 Replies)
hi
I have 2 file with more than 10 columns for both
1st file
apple,0,0,0......
orange,1,2,3.....
mango,2,4,5.....
2nd file
apple,2,3,4,5,6,7...
orange,2,3,4,5,6,8...
watermerlon,2,3,4,5,6,abc...
mango,5,6,7,4,6,def.... (1 Reply)
Discussion started by: tententen
1 Replies
LEARN ABOUT HPUX
quot_hfs
quot_hfs(1M)quot_hfs(1M)NAME
quot_hfs: quot - summarize ownership on an HFS file system
SYNOPSIS
filesystem ...
DESCRIPTION
The command displays the number of 1024-byte blocks in the named HFS filesystem that are currently owned by each user. filesystem is
either the name of the directory on which the file system is mounted or the name of the device containing the file system.
Options
recognizes the following options:
Generate a report for all mounted HFS file systems.
Report size rather than user statistics.
Generates histogram statistics in 3-column format:
Column 1: File size in blocks. Sizes are listed in ascending order up to 499 blocks per file. Files occupying 499
or more blocks are counted together on a single line as 499-block files (but column 3 is based on actual
number of blocks occupied).
Column 2: Number of files of size indicated in column 1.
Column 3: Cumulative total blocks occupied by files counted in current plus all preceding lines.
Use of this option overrides the and options.
Display number of files and space occupied by each user.
Specify the file system type
Calculate the number of blocks in the file based on file size
rather than actual blocks allocated. This option does not account for sparse files (files with holes in them).
Accept data from the
command (see ncheck(1M)) as input. Run the pipeline:
to produce a list of all files and their owners.
Report on users.
This is the default action.
Display three columns containing the number of blocks
not accessed in the last 30, 60, and 90 days.
Echo the completed command line, but perform no other
action. The command line is generated by incorporating the user-specified options and other information derived from This
option allows the user to verify the command line. If the options specified are valid, the completed command line is
echoed. If the options specified are not valid, an error message is printed.
AUTHOR
a disk quota command, was developed by the University of California, Berkeley, Sun Microsystems, Inc., and HP.
FILES
Static information about the file systems
Mounted file system table
Password file (contains user names)
SEE ALSO du(1), find(1), ls(1), fstyp(1M), mount(1M), ncheck(1M), quot(1M), repquota(1M), quota(5).
quot_hfs(1M)