05-01-2020
Thanks a lot jgir
This one very quick/fast one liner.
After this awk i used seperate awk to process it further in order to insert new column which has values equal to ($6/$5)*100 or so on. Is it possible to include this as well in your one liner.
Quote:
awk '( $5 ~ /^[1-9]/ ){ newcol=(($6/$5)*100); newpos=length } { printf "%*-s %s\n", newpos, $0, newcol }' file
awk '( $5 ~ /^[1-9]/ ){ newcol=(($8/$5)*100); newpos=length } { printf "%*-s %s\n", newpos, $0, newcol }' file
awk '( $5 ~ /^[1-9]/ ){ newcol=(($8/$7)*100); newpos=length } { printf "%*-s %s\n", newpos, $0, newcol }' file
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have to manipulate a data file which say reads like this
{$index $value $error_on_value}
aa 4.56 0.7
bb 123.456 0.00987
cc 987654 321
.
.
in easily human readable format of type
aa 4.6(7)
bb 123.456(1)
cc 9.877(3)e+05
value rounded to 4.6 with error of 0.7 on the last... (4 Replies)
Discussion started by: ahan
4 Replies
2. Shell Programming and Scripting
Hi.
I have this data below:-
v1 28 14 1.72414 1.72414 1.72414 1.72414 1.72414
v2 77 7 7.47126 6.89655 6.89655 6.89655 6.89655
v3 156 3 21.2644 21.2644 20.6897 21.2644 20.6897
v4 39 3 1.72414 1.72414 1.72414 1.72414 1.72414
v5 155 1 21.2644 23.5632 24.1379 23.5632 24.1379
v6 62 2 2.87356... (2 Replies)
Discussion started by: ahjiefreak
2 Replies
3. Shell Programming and Scripting
please help me writing a awk script
001_r.pdb 0.0265185
001_r.pdb 0.0437049
001_r.pdb 0.0240642
001_r.pdb 0.0310264
001_r.pdb 0.0200482
001_r.pdb 0.0146746
001_r.pdb 0.0351344
001_r.pdb 0.0347856
001_r.pdb 0.036119
001_r.pdb 1.49
002_r.pdb 0.0281011
002_r.pdb 0.0319908
002_r.pdb... (5 Replies)
Discussion started by: phoenix_nebula
5 Replies
4. Shell Programming and Scripting
Input
217:fngadi4osa:fngadi4osa:M 217:415744:N/A
227:fngadi4osa:fngadi4osa: M 227:51200:N/A
228:fngadi4osa:fngadi4osa: M 228:102400:N/A
65:sapgt04:sapgt04: M 65:104448:N/A
228:fngadi4osa:fngadi4oma: M 228:102400:N/A
Output
217:fngadi4osa:fngadi4osa:M 217:415744:N/A... (3 Replies)
Discussion started by: greycells
3 Replies
5. Shell Programming and Scripting
Hi,
i need a perl script which reads the file, content is given below. and output in new file.
TARGET DRIVE IO1 IO2 IO3 IO4 IO5
------------ --------- --------- --------- --------- ---------
0a.1.8 266 236 ... (3 Replies)
Discussion started by: asak
3 Replies
6. Shell Programming and Scripting
Good morning,
I am still learning the powers of awk and perl. I am in need of a bit of help.
I have a script on one of my launch systems...if that is even the word for it. Basically you can only ssh to a system if you are connected to this system due to firewalls.
So from that system, I... (2 Replies)
Discussion started by: brianjb
2 Replies
7. Shell Programming and Scripting
Hello,
I need help with a perl script that will process a text file and match virtual server name to profile(s). the rest will be ignored.
Virtual server name follows the word "virtual" in the begging of the line.
There could be multiple profiles assigned to one virtual server.
For example, ... (3 Replies)
Discussion started by: besogon
3 Replies
8. Shell Programming and Scripting
hi all,
I want to Represent the data in table format in mail content
sample data should be like this...but i m trying to send this table to mail using unix command...hw do i do????even i echoed the table contents ...doesnt work.... help me
<table style="background-color:lightblue;">... (8 Replies)
Discussion started by: navsan
8 Replies
9. Shell Programming and Scripting
/clusters/cluster-1/exports/storage-views/M1_CRE03_SV:
Name Value
------------------------ ---------------------------------------------------------------------------------------------------
caw-enabled true
controller-tag -
initiators ... (7 Replies)
Discussion started by: greycells
7 Replies
10. UNIX for Beginners Questions & Answers
HI
I have a file that looks like below
abc
{Seq('GATAGC', SingleLetterAlphabet()): 1, Seq('ATAGCG', SingleLetterAlphabet()): 1, Seq('TAGCGG', SingleLetterAlphabet()): 1}
BBC
{Seq('AGGATA', SingleLetterAlphabet()): 1, Seq('GGATAG', SingleLetterAlphabet()): 1, Seq('GATAGC',... (2 Replies)
Discussion started by: biofreek
2 Replies
LEARN ABOUT MOJAVE
io::string
String(3) User Contributed Perl Documentation String(3)
NAME
IO::String - Emulate file interface for in-core strings
SYNOPSIS
use IO::String;
$io = IO::String->new;
$io = IO::String->new($var);
tie *IO, 'IO::String';
# read data
<$io>;
$io->getline;
read($io, $buf, 100);
# write data
print $io "string
";
$io->print(@data);
syswrite($io, $buf, 100);
select $io;
printf "Some text %s
", $str;
# seek
$pos = $io->getpos;
$io->setpos(0); # rewind
$io->seek(-30, -1);
seek($io, 0, 0);
DESCRIPTION
The "IO::String" module provides the "IO::File" interface for in-core strings. An "IO::String" object can be attached to a string, and
makes it possible to use the normal file operations for reading or writing data, as well as for seeking to various locations of the string.
This is useful when you want to use a library module that only provides an interface to file handles on data that you have in a string
variable.
Note that perl-5.8 and better has built-in support for "in memory" files, which are set up by passing a reference instead of a filename to
the open() call. The reason for using this module is that it makes the code backwards compatible with older versions of Perl.
The "IO::String" module provides an interface compatible with "IO::File" as distributed with IO-1.20, but the following methods are not
available: new_from_fd, fdopen, format_write, format_page_number, format_lines_per_page, format_lines_left, format_name, format_top_name.
The following methods are specific to the "IO::String" class:
$io = IO::String->new
$io = IO::String->new( $string )
The constructor returns a newly-created "IO::String" object. It takes an optional argument, which is the string to read from or write
into. If no $string argument is given, then an internal buffer (initially empty) is allocated.
The "IO::String" object returned is tied to itself. This means that you can use most Perl I/O built-ins on it too: readline, <>, getc,
print, printf, syswrite, sysread, close.
$io->open
$io->open( $string )
Attaches an existing IO::String object to some other $string, or allocates a new internal buffer (if no argument is given). The
position is reset to 0.
$io->string_ref
Returns a reference to the string that is attached to the "IO::String" object. Most useful when you let the "IO::String" create an
internal buffer to write into.
$io->pad
$io->pad( $char )
Specifies the padding to use if the string is extended by either the seek() or truncate() methods. It is a single character and
defaults to "