Convert columns to row using awk Post: 302756051

Sponsored Content

Top Forums Shell Programming and Scripting Convert columns to row using awk Post 302756051 by radoulov on Tuesday 15th of January 2013 05:12:02 AM

01-15-2013

Registered User

Note that awk and sed are not the right tools for parsing html.
If html2text or lynx are not available, I would use Perl, Python or Ruby.

Code:

% cat infile.html
                        <TH TITLE="Different services during last 60s">CASC USERS</TH>
                        <TH colspan="3" class="centered">Action</TH>
                                </TR>
                <TR class="online">
                        <TD class="usercol1"><SPAN TITLE="">master</SPAN></TD>
                        <TD class="usercol2"><b>online</b></TD>
                        <TD class="usercol3">148.31.202.211</TD>
                        <TD class="usercol4">40</TD>
                        <TD class="usercol5">4380</TD>
                        <TD class="usercol6">55</TD>
                        </TR>
                <TR class="offline">
                        <TD class="usercol1"><SPAN TITLE="">madrid</SPAN></TD>
                        <TD class="usercol2">offline</TD>
                        <TD class="usercol3"></TD>
                        <TD class="usercol4">0</TD>
                        <TD class="usercol5">120</TD>
                        <TD class="usercol6">0</TD>
                        </TR>
                <TR class="connected">
                        <TD class="usercol1"><SPAN TITLE="">london</SPAN></TD>
                        <TD class="usercol2"><b>connected</b></TD>
                        <TD class="usercol3">10.10.10.41</TD>
                        <TD class="usercol4">34</TD>
                        <TD class="usercol5">632</TD>
                        <TD class="usercol6">430</TD>
                        </TR>
                                </TABLE><BR>
% lynx -dump infile.html
    CASC USERS Action
   master online 148.31.202.211 40 4380 55
   madrid offline 0 120 0
   london connected 10.10.10.41 34 632 430

radoulov

View Public Profile for radoulov

Find all posts by radoulov

8 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

convert matrix to row and columns

Dear Unix Gurus, I have a sample data set that looks like this y1 y2 y3 y4 y5 x1 0.3 0.5 2.3 3.1 5.1 x2 1.2 4.1 3.5 1.7 1.2 x3 3.1 2.1 1.0 4.1 2.1 x4 5.0 4.0 6.0 7.0 1.1 I want to open it up so that I get x1 y1 0.3 x2 y1 1.2 x3 y1 3.1 x4 y1 5.0 x1 y2 0.5 x2 y2...

2. Shell Programming and Scripting

How to convert 2 column data into multiple columns based on a keyword in a row??

Hi Friends I have the following input data in 2 columns. SNo 1 I1 Value I2 Value I3 Value SNo 2 I4 Value I5 Value I6 Value I7 Value SNo 3 I8 Value I9 Value ............... ................ SNo N

3. Shell Programming and Scripting

Convert columns to single row

Hello all I have data like 1 2 3 4 5 I wish my output would be like 1,2,3,4,5 For this i have executed 'BEGIN {FS="\n"; ORS=","} {print $0}' test and got the output as 1,2,3,4,5, I do not want to have , at the end of 5. output should be like

4. Shell Programming and Scripting

By using AWK can I convert matrice shaped data to a row ?

Hello, I have output in the matrice form , for example: 1 2 3 4 a b c d jim joe sue tom how can I convert this line-column data into a row as follows 1 2 3 4 a b c d jim joe sue tom thank you

5. Shell Programming and Scripting

awk print specific columns one row at a time

Hello, I have the following piece of code: roleName =`cat $inputFile | awk -F';' '{ print $1 }'` roleDescription =`cat $inputFile | awk -F';' '{ print $2 }'` roleAuthProfile =`cat $inputFile | awk -F';' '{ print $3 }'` mappedUserID

6. UNIX for Dummies Questions & Answers

awk: convert column to row in a specific way

Hi all! I have this kind of output: a1|b1|c1|d1|e1 a2|b2|c2 a3|b3|c3|d3 I would like to transpose columns d and e (when they exist) in column c, and under the row where they come from. Then copying the beginning of the row. In order to obtain: a1|b1|c1 a1|b1|d1 a1|b1|e1 a2|b2|c2...

7. Shell Programming and Scripting

Convert row to columns start from nth column

Dear All, We have input like this: 161 57 1378 176 1392 262 1444 441 1548 538 1611 670 1684 241 57 1378 208 1393 269 1447 444 1549 538 1610 677 1700 321 ...

8. Shell Programming and Scripting

awk split columns to row after N number of column

I want to split this with every 5 or 50 depend on how much data the file will have. And remove the comma on the end Source file will have 001,0002,0003,004,005,0006,0007,007A,007B,007C,007E,007F,008A,008C Need Output from every 5 tab and remove the comma from end of each row ...

LEARN ABOUT OPENSOLARIS

kprop

kprop(1M)						  System Administration Commands						 kprop(1M)

NAME

       kprop - Kerberos database propagation program

SYNOPSIS

       /usr/lib/krb5/kprop [-d] [-f file] [-p port-number]
	    [-r realm] [-s keytab] [host]

DESCRIPTION

       kprop  is a command-line utility used for propagating a Kerberos database from a master KDC to a slave KDC. This command must be run on the
       master KDC. See the Solaris System Administration Guide, Vol. 6 on how to set up periodic propagation between  the  master  KDC	and  slave
       KDCs.

       To propagate a Kerberos database, the following conditions must be met:

	   o	  The slave KDCs must have an /etc/krb5/kpropd.acl file that contains the principals for the master KDC and all the slave KDCs.

	   o	  A keytab containing a host principal entry must exist on each slave KDC.

	   o	  The database to be propagated must be dumped to a file using kdb5_util(1M).

OPTIONS

       The following options are supported:

       -d		 Enable debug mode. Default is debug mode disabled.

       -f file		 File to be sent to the slave KDC. Default is the /var/krb5/slave_datatrans file.

       -p port-number	 Propagate port-number. Default is port 754.

       -r realm 	 Realm where propagation will occur. Default realm is the local realm.

       -s keytab	 Location of the keytab. Default location is /etc/krb5/krb5.keytab.

OPERANDS

       The following operands are supported:

       host    Name of the slave KDC.

EXAMPLES

       Example 1 Propagating the Kerberos Database

       The  following example propagates the Kerberos database from the /tmp/slave_data file to the slave KDC london. The machine london must have
       a host principal keytab entry and the kpropd.acl file must contain an entry for the all the KDCs.

	 # kprop -f /tmp/slave_data london

FILES

       /etc/krb5/kpropd.acl	    List of principals of all the KDCs; resides on each slave KDC.

       /etc/krb5/krb5.keytab	    Keytab for Kerberos clients.

       /var/krb5/slave_datatrans    Kerberos database propagated to the KDC slaves.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWkdcu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       kpasswd(1),  svcs(1),  gkadmin(1M),  inetadm(1M),  inetd(1M),  kadmind(1M),  kadmin.local(1M),  kdb5_util(1M),  svcadm(1M),   kadm5.acl(4),
       kdc.conf(4), attributes(5), kerberos(5), smf(5)

SunOS 5.11							    14 Nov 2005 							 kprop(1M)