I have two variable columns 1 and 2 , and their respective groups in 3 and 4
I want to rearrange the rows in such a way that all similarly grouped (var1 var2) pairs are together . The similarity rule is (gr1 gr2) pair is the same as (gr2 gr1) pair.
For example
the variable pair (a b) has group (g and h) , group (g and h) pair is equivalent to group (h and g) pair. Since variables (c d) has group pair of ( h and g) also equiavalent to (g and h), these can be clubbed together.
In other words columns $3"__"$4 is the same as $4"__"$3
So my desired output is
To achieve this I`m trying to put the last 2 columns in an array and output in a sorted way. Then I can sort by the last columns and get my result, , but it gives me a blank output.
please assist, row order doesn't matter as long as similar groups are togther. Please note this is made up data, and groups have no alpha or numeric pattern.
I have a file that is semi-colon delimited and the column headers are always the same but the column number is totally random each time this file is generated. I don't have the skills to make a script for this so maybe someone can help.
I would like to be able to take this file which has over... (11 Replies)
I wrote script in bash which generates this report:
User1,admin,rep,User2,shell,path1,x1,r1
User2,admin,rep,User7,shell,path1,x1,r1
User3,admin,rep,User4,shell,path1,x1,r1
User4,admin,rep,User3,shell,path1,x1,r1
User5,admin,rep,User1,shell,path1,x1,r1
User6,admin,rep,User5,shell,path1,x1,r1... (6 Replies)
hi!
in awk, i have a file like this:
Trace1: WRIT,Trace2: BLAN,Trace3: BLAN,
-47.2120018005371,,,39815.4809027778
-46.3009986877441,,,39815.4809027778
-46.277000427246,,,39815.4809143519
-46.7389984130859,,,39815.4809259259
-46.3460006713867,,,39815.4809259259... (10 Replies)
Hello, I have the following problem
I have two columns with numbers arranged as follows:
x1 y1
x2 y2
....
....
x250 y250
Now I need them arranged as follows:
"string a"
x1 y1
x1 y2
"string b"
"string a"
x1 y2
x2 y2 (3 Replies)
Hi
I have the input file following like this
"AIX"
"AIX 6.0"
"AIX 7.0"
"Redhat 8"
"Redhat 9"
"Redhat 5.0 Enterprise Linux"
"Sun Solaris 9"
"Sun Solaris 10",
"Sun Microsystems"
"Oracle"
.................................Like this 2000 lines
I need to convert this input into... (5 Replies)
Hi all,
I am a newbie to awk and trying to learn by doing examples.
I got stuck at this relatively simple conversion.
The start file looks like:
1 2 "t1"
1 3 "h1"
2 1 "h1"
2 2 "h2"
and I want to convert it into
1 t1:2, h1:3;
2 h1:1, h2:2;
Thanks. (9 Replies)
Hi,
I am required to arrange columns of a file i.e make the 15th column into the 1st column.
I am doing
awk 'begin {fs=ofs=","} {print $15,$1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14}' ad.data>ad.csv
the problem is that column 15 gets to column 1 but it is not comma separated with the... (10 Replies)
I have 1 row which contains abouts 20000 base64 string.
e.g:
/p4bdllBS8qcvW/69GUYej8nEv6gwt7UAYl0g==WZdjwTUQX9UEKsT/zWaZdQ==uI would like rearrange this file by base64 strings. So the output should be this ( 1 string in 1 row):
69GUYej8nEv6gwt7UAYl0g==
WZdjwTUQX9UEKsT/zWaZdQ==How could I do... (4 Replies)
I've a comma separated file with data below:
61401370587,505,1;0402686146,123;2387936.0;20170812
61401370587,505,2;0401296221,34;3.0;20170811
61401370587,505,5;0431169322,123;2387936.0;20170812
My requirement is to group by using 1st,2nd column . And translate the 3rd column's row data... (1 Reply)
As part of some report generation, I've written a script to fetch the values from DB. But, unluckily, for certain Time ranges(1-9.99,10-19.99 etc), I don't have data in DB.
In such cases, I would like to write zero (0) instead of empty. The desired output will be exported to csv file.
... (1 Reply)
Discussion started by: kumar_karpuram
1 Replies
LEARN ABOUT DEBIAN
pfspad
pfspad(1) General Commands Manual pfspad(1)NAME
pfspad - Add borders to a frame in PFS stream
SYNOPSIS
pfspad [--left <columns>] [--right <columns>] [--top <rows>] [--bottom <rows>] [--width <new_width>] [--height <new_height>] [--R <val>]
[--G <val>] [--B <val>] [--Y <val>] [--help]
DESCRIPTION
Add borders to each frame in PFS stream. User specifies size of left, right, top and bottom border or size of an output image. Color of
borders can be specified as well.
OPTIONS --left <columns>, -l <columns>
Width in pixels of the left border.
--right <columns>, -r <columns>
Width in pixels of the right border.
--top <rows>, -t <rows>
Height in pixels of the top border.
--bottom <rows>, -b <rows>
Height in pixels of the bottom border.
--width <new_width>, -W <new_width>
Width of an output image. Note that --width can be mixed with either --left or --right option.
--height <new_height>, -H <new_height>
Height of an output image. Note that --height can be mixed with either --top or --bottom option.
--R <val>, -R <val>, --G <val>, -G <val>, --B <val>, -B <val>
Color of borders in RGB mode. Default color is black, and if some of the components is not specified, its value is set to 0.0.
--Y <val>, -Y <val>
Color of borders in luminance mode.
--help, -h
Print a list of commandline options.
EXAMPLES
pfsin image.hdr | pfspad --left 50 --bottom 20 | pfsout out.hdr
Add 50 columns to the left and 20 rows to the bottom side of image.hdr. Color of borders is default black.
pfsin image.hdr | pfspad --top 20 --height 500 --width 400 --R 1.0 | pfsout out.hdr
Add 20 rows to the top side of image.hdr and create output image out.hdr 500 pixels in height and 400 pixels in width. Color of bor-
ders is set to red.
SEE ALSO pfsin(1)pfsout(1)BUGS
Please report bugs and comments to Dorota Zdrojewska <dzdrojewska@wi.ps.pl>.
pfspad(1)