awk for scientific notion and decimal combined data
Dea all,
I have a question. I have a column of numbers with scientific notion and decimal combined data. I want to print it only if the number <0.05 using awk. however the very small numbers with scientific notion is not selected. Do any one know how to solve it? Thanks! example as below:
data:
Code:
0.04
0.01
0.11
0.55
3.1*e-6
code:
Code:
awk '($1 <"0.05") {print $1}'
output:
Code:
0.04
0.01
Moderator's Comments:
Please use code tags when posting data and code samples!
Last edited by vgersh99; 05-05-2011 at 12:55 PM..
Reason: code tags, please!
Hi All,
Please let me know if it is possible to convert data from ASCII to Packed Decimal through Unix?
Basically we have ASCII file with numeric data we want to convert that files data to Packed decimal format to send it to main frame.
Please let me know if we can do it through unix script.... (1 Reply)
Assoc.txt
CHR SNP BP A1 TEST NMISS OR STAT P
1 rs2980319 766985 A ADD 4154 1.024 0.1623 0.8711
1 rs2980319 766985 A AGECAT 4154 1.371 6.806 1.003e-11
1 ... (6 Replies)
hi guys,
i have a data with a column of p value (normal format and scientific combined). i want to creat a subset of data which only contains p-value:
data 1: p<10^7
data 2: p<0.01
how should i do it? many thanks!
data looks like:
rs7841347 128887490 1.695e-007
rs1241347 ... (4 Replies)
hello folks,
I have few values in a log which are in scientific notation.
I am trying to convert into actual decimal format or integer but couldn't able to convert.
Values in scientific notation:
1.1662986666666665E-4
2.0946799999999998E-4
3.0741333333333333E-6
5.599999999999999E-7... (2 Replies)
Hi everybody!
I try to printout a csv-file with the exeption of cell $1 and $4.
what i tried so far:
awk '{for(i = 1; i<=NF; i++);if(i == 1 || i == 4);else print($i)}' file.csv
..any ideas how it work and why my example fails?
Thanks in advance!
IMPe (3 Replies)
have written a combined sed+awk to perform a lookup operation which works but looking to enhance it.
looking to match a record using any of the comma separated values + return selected fields from the record - including the field header. so:
cat foo
make,model,engine,trim,value... (6 Replies)
Dear all,
I have a txt file with only one column which contains p values. My data looks like this:
5.04726976606584e-190
2.94065711152402e-189
2.94065711152402e-189
9.19932135717279e-176
1.09472516659859e-170
1.24974648916809e-170
0.1223974648916
0.9874974648916
...
what I want... (2 Replies)
Input file:
data1 0.05
data2 1e-14
data1 1e-330
data2 1e-14
data5 2e-60
data5 2e-150
data1 4e-9
Desired output:
data2 1e-14
data1 1e-330
data2 1e-14
data5 2e-60
data5 2e-150
I would like to filter out those result that column 2 is less than 1e-10.
Command try: (1 Reply)
I have 133 .txt files in a directory that I am combining into 1 file. The problem is when I use awk or cat to combine the files I get out put like this:
output
85 138662360 KCNT1
86 138662962 KCNT1
82 138657053 KCNT1
83 138657635 KCNT1
95 138646881 KCNT1... (12 Replies)
Discussion started by: cmccabe
12 Replies
LEARN ABOUT OPENDARWIN
size
SIZE(1) General Commands Manual SIZE(1)NAME
size - print the size of the sections in an object file
SYNOPSIS
size [ option ... ] [ object ... ]
DESCRIPTION
Size (without the -m option) prints the (decimal) number of bytes required by the __TEXT, __DATA and __OBJC segments. All other segments
are totaled and that size is listed in the `others' column. The final two columns is the sum in decimal and hexadecimal. If no file is
specified, a.out is used.
The options to size(1) are:
- Treat the remaining arguments as name of object files not options to size(1).
-m Print the sizes of the Mach-O segments and sections as well as the total sizes of the sections in each segment and the total size of
the segments in the file.
-l When used with the -m option, also print the addresses and offsets of the sections and segments.
-x When used with the -m option, print the values in hexadecimal (with leading 0x's) rather than decimal.
-arch arch_type
Specifies the architecture, arch_type, of the file for size(1) to operate on when the file is a fat file. (See arch(3) for the cur-
rently know arch_types.) The arch_type can be "all" to operate on all architectures in the file. The default is to display only
the host architecture, if the file contains it; otherwise, all architectures in the file are shown.
SEE ALSO otool(1)BUGS
The size of common symbols can't be reflected in any of the numbers for relocatable object files.
Apple Computer, Inc. May 23, 2002 SIZE(1)
05-05-2011
