Sponsored Content
Top Forums Shell Programming and Scripting awk to output the percentage of a field compared to length Post 302956533 by cmccabe on Wednesday 30th of September 2015 06:04:58 PM
Old 09-30-2015
The input data is very large (~720MB)

Using that code I get the below:

Code:
+    1.000000    -nan
AGRN:exon.1    0.000000    -nan
+    112.000000    2.333333

I thought I followed your code and it is much easier to read, but the calculations don't look right. Thank you very much Smilie.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

creating a fixed length output from a variable length input

Is there a command that sets a variable length? I have a input of a variable length field but my output for that field needs to be set to 32 char. Is there such a command? I am on a sun box running ksh Thanks (2 Replies)
Discussion started by: r1500
2 Replies

2. Shell Programming and Scripting

perl or awk, field length check

Hi Everyone, 1.txt a;1234;134;1111111 b;123;123;1111111 c;123;1334;1111111 d;1234;1234;1111111 output a;1234;134;1111111 c;123;1334;1111111 d;1234;1234;1111111 if field2 legth>3 or field3 length >3, then output. Please advice. Thanks (4 Replies)
Discussion started by: jimmy_y
4 Replies

3. Shell Programming and Scripting

awk output field delimiter

Dear All, 1.txt (tab in between each value in a line) a b c a b c a c d you can see below, why with ~ i can output with tab, but = cannot? # awk -F'\t' '$2 ~ /b/' 1 a b c a b c # awk -F'\t' '$2 = "b"' 1 a b c a b c a b d ... (1 Reply)
Discussion started by: jimmy_y
1 Replies

4. Shell Programming and Scripting

Flat file-make field length equal to header length

Hello Everyone, I am stuck with one issue while working on abstract flat file which i have to use as input and load data to table. Input Data- ------ ------------------------ ---- ----------------- WFI001 Xxxxxx Control Work Item A Number of Records ------ ------------------------... (5 Replies)
Discussion started by: sonali.s.more
5 Replies

5. UNIX for Dummies Questions & Answers

awk - output field separator

In awk, how do I print all fields with a specified output field separator? I have tried the following, which does not print the output FS: echo a b c d | awk 'BEGIN{OFS = ";"}{print $0}' (3 Replies)
Discussion started by: locoroco
3 Replies

6. Shell Programming and Scripting

Replace a field with a character as per the field length

Hi all, I have a requirement to replace a field with a character as per the length of the field. Suppose i have a file where second field is of 20 character length. I want to replace second field with 20 stars (*). like ******************** As the field is not a fixed one, i want to do the... (2 Replies)
Discussion started by: gani_85
2 Replies

7. Shell Programming and Scripting

Need an awk script to calculate the percentage of value field and replace

Need an awk script to calculate the percentage of value field and replace I have a input file called file.txt with the following content: john|622.5674603562933|8|br:1;cn:3;fr:1;jp:1;us:2 andy|0.0|12|**:3;br:1;ca:2;de:2;dz:1;fr:2;nl:1 in fourth filed of input file, calulate percentage of each... (1 Reply)
Discussion started by: veeruasu
1 Replies

8. UNIX for Dummies Questions & Answers

Need an awk script to calculate the percentage of value field and replace

I have a input file called file.txt with the following content: john|622.5674603562933|8|br:1;cn:3;fr:1;jp:1;us:2 andy|0.0|12|**:3;br:1;ca:2;de:2;dz:1;fr:2;nl:1 in fourth filed of input file, calulate percentage of each sub filed seperated by ; semicolon and replace value with percentage . i... (11 Replies)
Discussion started by: veeruasu
11 Replies

9. UNIX for Dummies Questions & Answers

Help with awk, where line length and field position are variable

I have several questions about using awk. I'm hoping someone could lend me a hand. (I'm also hoping that my questions make sense.) I have a file that contains pipe separated data. Each line has similar data but the number of fields and the field position on each line is variable. ... (3 Replies)
Discussion started by: Cheese64
3 Replies

10. Shell Programming and Scripting

Using awk to add length of matching characters between field in file

The awk below produces the current output, which will add +1 to $3. However, I am trying to add the length of the matching characters between $5 and $6 to $3. I have tried using sub as a variable to store the length but am not able to do so correctly. I added comments to each line and the... (4 Replies)
Discussion started by: cmccabe
4 Replies
wml::std::box(3)						     EN Tools							  wml::std::box(3)

NAME
wml::std::box - Easily Create Rectangular Box SYNOPSIS
#use wml::std::box <box [attributes]> ... </box> DESCRIPTION
The "<box>" container tag puts its body into a nice rectangular box which itself is build via a HTML "<table>" construct. ATTRIBUTES
"header" This attribute switches between two totally different box variants. When it is present, a headlined box is created by the use of one single table but with space GIFs. When this attribute is missing a standard box is created by the use of two nested tables but without any space GIFs. "bgcolor" This sets the background color of the box. "fgcolor" This sets the foreground (text) color of the box. "bdcolor" This sets the color for the border of the box. The effect of this attribute is the automatic generation of a nested table construct to achieve the optical effect. "bdspace" This sets the space between the border and the body of the box in pixels. Default is 4 pixel. "bdwidth" This sets the border width in pixels. Default is 1 pixel. "width" This sets the total table width in pixels. Default is no specific width for the standard box and 300 pixels for the headlined box (because the headlined variant needs to know a fixed size to create the GIFs accordingly). "summary" Add a description of this table. This attribute is recommended in HTML 4.0. EXAMPLE
<box bdcolor="#000000" bdwidth=1 bdspace=10 bgcolor="#ffffff" fgcolor="#000000"> Foo Bar Quux </box> <box header="Foo Bar Quux Header" bdcolor="#000000" bdwidth=1 bdspace=10 bgcolor="#ffffff" fgcolor="#000000"> Foo Bar Quux </box> AUTHOR
Ralf S. Engelschall rse@engelschall.com www.engelschall.com REQUIRES
Internal: P1, P2 SEE ALSO
HTML "<table>" tag. EN Tools 2014-04-16 wml::std::box(3)
All times are GMT -4. The time now is 12:55 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy