Hi,
Sorry for the confusion, the file is a CSV file and every entry has a comma after it as a delimiter. (the format was not finalized but now it is CSV).
So the output should be the following, spaces are not needed in the output file, it only needs to be comma separated.
Also I have added the numbers 999, 9999 to the input so as to make each row in the output complete.
a, b, c, d,
aa, 12, 33, 102,
bb, 111, 223, 24,
aa, 88, 56, 99,
bb, 130, 21, 45,
aa, 88, 90, 212,
bb, 500, 999, 9999
Also I need to print it back to the same file. Do I add the file pointer after the print statement below to print it back to the same file?
for my $record (@index){
print DATA join(",\t", $record, @values[(scalar(@headings) * $row)
+ .. (
+(scalar(@headings) * $row) + $#headings -1)]),"\n";
$row++;
-
Are you posting in the right place? Check out Where do I post X? to know for sure.
-
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
<u> <ul>
-
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
intervention).
-
Want more info? How to link
or How to display code and escape characters
are good places to start.