|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Merge column headers and transpose
Post 302737943 by giuliangiuseppe on Friday 30th of November 2012 05:16:59 AM
11-30-2012
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a text file in unix with a layout like this
Column 1 - 1-12
Column 2 - 13-39
Column 3 - 40-58
Column 4 - 59-85
Column 5 - 86-120
Columbn 6 - 121-131
The file also has a header on the first 6 lines of each page. Each page is 51 lines long. So I want to remove the header from each... (30 Replies)
Discussion started by: DerangedNick
30 Replies
2. Shell Programming and Scripting
cat ABC.log | egrep "Error 500" >> /tmp/Logs.log
egrep "<Mango>.*<.Mango>" Logs.log | sed -e "s/^.*<Mango/<Mango/" | cut -f2 -d">"| cut -f1 -d"<" >> /tmp/temp1.xls
egrep "<Apple>.*<.Apple>" Logs.log | sed -e "s/^.*<Apple/<Apple/" | cut -f2 -d">"| cut -f1 -d"<" >> /tmp/temp2.xls
print Heading1,... (1 Reply)
Discussion started by: pk_eee
1 Replies
3. UNIX for Dummies Questions & Answers
Hi All,
I am new to UNIX can you please help me to sort a file with different columns
my file looks like this
$ cat gaut.txt
UID PID PPID PGID SID C STIME TTY TIME CMD
liveuser 3008 2892 3008 3008 0 11:58 ? 00:00:00 gnome-session
liveuser 3019 1 ... (8 Replies)
Discussion started by: cgk1983
8 Replies
4. Shell Programming and Scripting
Hi,
I found the following awk script to transpose multiple (3) columns to multiple rows:
#===
BEGIN {FS=","}
{
for (i=1;i<=NF;i++)
{
arr=$i;
if(nf<= NF)
nf=NF;
}
nr=NR
}
END {
for(i=1;i<=nf;i++)
{ (8 Replies)
Discussion started by: Gery
8 Replies
5. Shell Programming and Scripting
Looking to join three files and then transpose some columns from multiple rows into a single row.
File Info:
FIELD TERMINATED BY '^'
ENCLOSED BY '~'
LINE TERMINATED BY '\r\n'
FIRST FILE (FOOD_DES.txt)
~01001~^~0100~^~Butter, salted~^~BUTTER,WITH... (2 Replies)
Discussion started by: mkastin
2 Replies
6. Shell Programming and Scripting
Hi All,
I'm looking for a script which can transpose field names from column headers to values in one column.
for example, the input is:
IDa;IDb;IDc;PARAM1;PARAM2;PARAM3;
a;b;c;p1val;p2val;p3val;
d;e;f;p4val;p5val;p6val;
g;h;i;p7val;p8val;p9val;
into the output like this:
... (6 Replies)
Discussion started by: popesk
6 Replies
7. Shell Programming and Scripting
Hi
I have 5 columns like this
a b c d e
f g h i j
k l m n o
From 2nd column till the 5th column of every record, I would like to transpose them as rows, so my output file contains only one row
a
b
c
d
e
f
g
h
i
j (9 Replies)
Discussion started by: jacobs.smith
9 Replies
8. Shell Programming and Scripting
Hi Folks,
My input file is like this
cat input
abcd:efgh:jklm 123,456,67,78,89,90
hi:kil:op 76,78,12,3456,
unix:linux:shell:bash 111,111
My expected output
abcd:efgh:jklm hi:kil:op unix:linux:shell:bash
123 76 111
456 78 111
67 12
78 3456
89
90 (5 Replies)
Discussion started by: jacobs.smith
5 Replies
9. Shell Programming and Scripting
hello gurus,
Somebody must have done this before, I couldn't find anything. Please redirect me if this was solved before, and if not please help.
To the problem now, I have multiple csv files (about 1000) which I need to concatenate by column header. The final file should have a superset... (4 Replies)
Discussion started by: abh.kumar
4 Replies
10. Shell Programming and Scripting
Gents,
Transpose from row to column, taking in consideration the first column, which contends the date.
Input file
72918,111000009,111000009,111000009,111000009,111000009,111000009,111000009,111000009,111000009
72918,2356,2357,2358,2359,2360,2361,2362,2363,2364
72918,0,0,0,0,0,0,0,0,0... (12 Replies)
Discussion started by: jiam912
12 Replies
LEARN ABOUT DEBIAN
vlan-interfaces
VLAN-INTERFACES(5) File formats VLAN-INTERFACES(5) NAME
/etc/network/interfaces (vlan) - vlan extensions for the interfaces(5) file format DESCRIPTION
/etc/network/interfaces contains network interface configuration information for the ifup(8) and ifdown(8) commands. This manpage describes the vlan extensions to the standard interfaces(5) file format. Primary extensions exist to make and destroy vlan interfaces, secondary extensions exist for ipv4 interface manipulation which are gener- ally needed when using (a lot of) vlans. VLAN CREATION
Vlan interface definitions exist of the vlan interface name, and an optional 'raw-device' parameter. Vlan interfaces are numbered 1 to 4095. You have the option to have interface names zero-padded to 4 numbers, or just the plain digits without leading zero. The following example shows four ways to create a vlan with id 1 on interface eth0. They all result in different names. iface eth0.1 inet static address 192.168.1.1 netmask 255.255.255.0 iface vlan1 inet static vlan-raw-device eth0 address 192.168.1.1 netmask 255.255.255.0 iface eth0.0001 inet static address 192.168.1.1 netmask 255.255.255.0 iface vlan0001 inet static vlan-raw-device eth0 address 192.168.1.1 netmask 255.255.255.0 # We don't have br support out of the box iface br0.2 inet static vlan-raw-device br0 address 192.168.1.1 netmask 255.255.255.0 # Aliases are ignored iface br0.2:1 inet static address 192.168.1.1 netmask 255.255.255.255 EXTRA IFACE OPTIONS
Usually someone who uses vlans also wants to do some other manipulations with the ip stack or interface. vlan-raw-device devicename Indicates the device to create the vlan on. This is ignored when the devicename is part of the vlan interface name. ip-proxy-arp 0|1 Turn proxy-arp off or on for this specific interface. This also works on plain ethernet like devices. ip-rp-filter 0|1|2 Set the return path filter for this specific interface. This also works on plain ethernet like devices. hw-mac-address mac-address This sets the mac address of the interface before bringing it up. This works on any device that allows setting the hardware address with the ip command. AUTHOR
This manpage was adapted from interfaces(5) by Ard van Breemen <ard@kwaak.net> SEE ALSO
vconfig(8) interfaces(5) vlan September 30 2007 VLAN-INTERFACES(5)