I need to convert some columns form a html file to rows.
I do manage to make it works without help (some proud )
For some reason the offline status is not in bold, so I do need to remove the <b> tag from the other field to make this to work. All fields are not needed, so I test and select only one that I need.
Is there a more simple way to do this or can this code be cleaned some?
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:
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 "".
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
... (4 Replies)
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... (1 Reply)
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 (14 Replies)
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 (5 Replies)
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 (1 Reply)
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... (3 Replies)