Convert columns to row using awk Post: 302756107

Sponsored Content

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

01-15-2013

Registered User

I'll try to explain the script.

Code:

func buildrec() {
  if (match($0, />[^<]*<\//))
    rec = length(rec) ? rec OFS substr($0, RSTART + 1, RLENGTH - 3) : \
      substr($0, RSTART + 1, RLENGTH - 3)

buildrec is a user defined function that I used to avoid to repeat the same code for every match.
The function doesn't require parameters as it directly modifies
the global variable rec.
The function code performs the following actions:
- search for the pattern: an > followd by 0 or more occurrences of characters different than <, followed by the closing tag sequence </,
using the following regular expression: >[^<]*<\/
- when match is found, the value is appended to the variable rec (short for record). RSTART and RLENGTH are automatically set by the match builtin function

After that, the code is simple:

Code:

  /col[1-3,5]/ { buildrec() }
  /<TR class="[^"]*"> *$/ && length(rec) {
    print rec
    rec = x
    }

When the records match the pattern represented by the regular expression col[1-3,5], build the record - append the values.
When the pattern <TR class="[^"]*"> *$ matches for a second time (rec is already build) - print the record and reset it: rec = x.
x is an uninitialized variable, so I'm using it as a shortcut for "".

This User Gave Thanks to radoulov For This Post:

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 MOJAVE

mpsmatrixdecompositionlu

MPSMatrixDecompositionLU(3)				 MetalPerformanceShaders.framework			       MPSMatrixDecompositionLU(3)

NAME

       MPSMatrixDecompositionLU

SYNOPSIS

       #import <MPSMatrixDecomposition.h>

       Inherits MPSMatrixUnaryKernel.

   Instance Methods
       (nonnull instancetype) - initWithDevice:rows:columns:
       (void) - encodeToCommandBuffer:sourceMatrix:resultMatrix:pivotIndices:status:

   Additional Inherited Members
Detailed Description
       This depends on Metal.framework.

       A kernel for computing the LU factorization of a matrix using partial pivoting with row interchanges.

       A MPSMatrixDecompositionLU object computes an LU factorization:

		   P * A = L * U

	       A is a matrix for which the LU factorization is to be computed.
	       L is a unit lower triangular matrix and U is an upper triangular
	       matrix.	P is a permutation matrix.

Method Documentation
   - (void) encodeToCommandBuffer: (nonnull id< MTLCommandBuffer >) commandBuffer(MPSMatrix *__nonnull) sourceMatrix(MPSMatrix *__nonnull)
       resultMatrix(MPSMatrix *__nonnull) pivotIndices(__nullable id< MTLBuffer >) status
       Encode a MPSMatrixDecompositionLU kernel into a command Buffer.

       Parameters:
	   commandBuffer A valid MTLCommandBuffer to receive the encoded filter
	   sourceMatrix A valid MPSMatrix containing the source data. Must have enough space to hold a rows x columns matrix.
	   resultMatrix A valid MPSMatrix to contain the result. Must have enough space to hold a rows x columns matrix.
	   pivotIndices A valid MPSMatrix to contain the pivot indices. Must have enough space to hold an array of size 1xmin(rows, columns)
	   values. Element type must be MPSDataTypeUInt32.
	   status A MTLBuffer which indicates the resulting MPSMatrixDecompositionStatus value.

       This function encodes the MPSMatrixDecompositionLU object to a valid command buffer.

       Upon completion the array pivotIndices contains, for each index i, the row interchanged with row i.

       If during the computation U[k, k], for some k, is determined to be exactly zero MPSMatrixDecompositionStatusSingular will be returned in
       the provided status buffer. The data referenced by the MTLBuffer is not valid until the command buffer has completed execution. If the
       matrix return status is not desired NULL may be provided.

       Upon successful factorization, resultMatrix contains the resulting lower triangular factor (without the unit diagonal elements) in its
       strictly lower triangular region and the upper triangular factor in its upper triangular region.

       This kernel functions either in-place, if the result matrix completely aliases the source matrix, or out-of-place. If there is any partial
       overlap between input and output data the results are undefined.

   - (nonnull instancetype) initWithDevice: (nonnull id< MTLDevice >) device(NSUInteger) rows(NSUInteger) columns
       Initialize an MPSMatrixDecompositionLU object on a device

       Parameters:
	   device The device on which the kernel will execute.
	   rows The number of rows in the source matrix.
	   columns The number of columns in the source matrix.

       Returns:
	   A valid MPSMatrixDecompositionLU object or nil, if failure.

Author
       Generated automatically by Doxygen for MetalPerformanceShaders.framework from the source code.

Version MetalPerformanceShaders-100				  Thu Feb 8 2018				       MPSMatrixDecompositionLU(3)