I'd say you'd definitely want to unpack, as JavaFan mentioned. Something similar to:
#!/usr/bin/perl use strict; use warnings; use Data::Dumper; my $rcount = 1; while (<DATA>) { my $string = $_; next if $rcount++ < 8; my @fields = unpack ('A34 A30 A40', $string); print Dumper(@fields), "\n"; } __DATA__ Ignore Me Line 1 Ignore Me Line 2 Ignore Me Line 3 Ignore Me Line 4 Ignore Me Line 5 Ignore Me Line 6 Ignore Me Line 7 This is a very long sentence which should illustrate the unpacking fun +ctionality in accordance to what you require.
Outputs:
$VAR1 = 'This is a very long sentence which'; $VAR2 = ' should illustrate the unpacki'; $VAR3 = 'ng functionality in accordance to what y';
For writing excel spreadsheets, Spreadsheet::WriteExcel does the trick for me.

In reply to Re: Seperating Fixed Line Feed into Fields by Transient
in thread Seperating Fixed Line Feed into Fields by drodinthe559

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.