How to split one long column into multiple rows with 3 each ?
I have a large csv dataset like this :
what I expected output is :
I'm thinking of use like awk, columns , but haven't find a proper way to do that.
could anyone give me some clues?
i have single column which is starting with same string(many number of rows)
i have to convert each into a single row.how can i do that?
laknar
std
mes
23
55
laknar
isd
phone no
address
amount
99
I have to convert above like below.
laknar|std|mes|23|55
laknar|isd|phone... (3 Replies)
hey guys...
Im looking to do the following:
1
2
3
4
5
6
7
8
9
Change to:
1 4 7
2 5 8
3 6 9
Did use | perl -lpe'$\=$.%3?$":"\n"' , but it doesnt give me the matrix i want. (3 Replies)
Hi all,
I need to convert this file having just one column into two column file
current file:
a
15
b
21
c
34
d
48
e
10
wanted:
a 15
b 21
c 34 (15 Replies)
Hello Friends,
I am trying to implement the following using UNIX. I am getting a sequential file as input which would have two columns, "Name" and "Countries Visited". The "Countries Visisted" field will be multi-valued, each value separated by a space and also the number of values are not... (2 Replies)
Hi pls help me out to short out this problem
rm PAB113_011.out
rm: PAB113_011.out: override protection 644 (yes/no)? n
If i give y it remove the file.
But i added the rm command as a part of ksh file and i tried to remove the file. Its not removing and the the file prompting as... (7 Replies)
Dear fellows, I need your help.
I'm trying to write a script to convert a single column into multiple rows.
But it need to recognize the beginning of the string and set it to its specific Column number.
Each Line (loop) begins with digit (RANGE).
At this moment it's kind of working, but it... (6 Replies)
Hi,
I have input dataset as below:
Cl.jenn,1051,ABCD
JEN.HEA,9740|1517|8119|2145,ZZZZ,REPEAT
Rich.Sm,
Ann.Car,3972|4051|1064|4323|4122|2394|2574|4507
Sta.for,7777,ABCD,UUUU
Sm.Ric,
Ch.LRD,
Eh.ab,
Gr.sh,
Expected output:
-------------------
Cl.jenn,1051,ABCD... (6 Replies)
Discussion started by: saravananravim
6 Replies
LEARN ABOUT SUSE
html::formatter
HTML::Formatter(3) User Contributed Perl Documentation HTML::Formatter(3)NAME
HTML::Formatter - Base class for HTML formatters
SYNOPSIS
use HTML::FormatSomething;
my $infile = "whatever.html";
my $outfile = "whatever.file";
open OUT, ">$outfile"
or die "Can't write-open $outfile: $!
Aborting";
binmode(OUT);
print OUT HTML::FormatSomething->format_file(
$infile,
'option1' => 'value1',
'option2' => 'value2',
...
);
close(OUT);
DESCRIPTION
HTML::Formatter is a base class for classes that take HTML and format it to some output format. When you take an object of such a base
class and call "$formatter->format( $tree )" with an HTML::TreeBuilder (or HTML::Element) object, they return the
HTML formatters are able to format a HTML syntax tree into various printable formats. Different formatters produce output for different
output media. Common for all formatters are that they will return the formatted output when the format() method is called. The format()
method takes a HTML::Element object (usually the HTML::TreeBuilder root object) as parameter.
Here are the four main methods that this class provides:
SomeClass->format_file( $filename, option1 => value1, option2 => value2, ... )
This returns a string consisting of the result of using the given class to format the given HTML file according to the given (optional)
options. Internally it calls "SomeClass->new( ... )->format( ... )" on a new HTML::TreeBuilder object based on the given HTML file.
SomeClass->format_string( $html_source, option1 => value1, option2 => value2, ... )
This returns a string consisting of the result of using the given class to format the given HTML source according to the given
(optional) options. Internally it calls "SomeClass->new( ... )->format( ... )" on a new HTML::TreeBuilder object based on the given
source.
$formatter = SomeClass->new( option1 => value1, option2 => value2, ... )
This creates a new formatter object with the given options.
$render_string = $formatter->format( $html_tree_object )
This renders the given HTML object accerting to the options set for $formatter.
After you've used a particular formatter object to format a particular HTML tree object, you probably should not use either again.
SEE ALSO
HTML::FormatText, HTML::FormatPS, HTML::FormatRTF
HTML::TreeBuilder, HTML::Element, HTML::Tree
COPYRIGHT
Copyright (c) 1995-2002 Gisle Aas, and 2002- Sean M. Burke. All rights reserved.
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
This program is distributed in the hope that it will be useful, but without any warranty; without even the implied warranty of
merchantability or fitness for a particular purpose.
AUTHOR
Current maintainer: Sean M. Burke <sburke@cpan.org>
Original author: Gisle Aas <gisle@aas.no>
perl v5.12.1 2004-06-02 HTML::Formatter(3)