Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

Re: .TXT to Excel

by GrandFather (Sage)
on Sep 20, 2016 at 21:09 UTC ( #1172247=note: print w/replies, xml ) Need Help??

in reply to .TXT to Excel

Why are you doing this? The assistance you need is different depending on the motive for your task:

  1. This is homework: you need hints so you can figure out how to do it for yourself
  2. You are learning and this is a self assigned exercise: as above, but sample code and some discussion are indicated
  3. You have a real world task: sample code using "production" techniques, probably including use of modules, are indicated, but tutorial type discussion is not needed
  4. You have a real world problem to solve and are using it to learn Perl and programming fundamentals: as above except some discussion of the code is appropriate.

So, why are you doing this?

Premature optimization is the root of all job security

Replies are listed 'Best First'.
Re^2: .TXT to Excel
by UCLAdan06 (Initiate) on Sep 21, 2016 at 13:54 UTC

    Grandfather, this is a real world problem that I have been instructed to use Perl for. I have a large model that will accept data from excel files and my current data is in .txt files. I have rows and columns of data in a .txt file that need to be put into an excel spreadsheet- each item in its own box. In the txt file, there are spaces between the columns of data, and I need a Perl mechanism for reading these spaces and assigning a new cell for each number.

      This sounds exactly like what csv2xls already does.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1172247]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (4)
As of 2019-02-17 10:42 GMT
Find Nodes?
    Voting Booth?
    I use postfix dereferencing ...

    Results (96 votes). Check out past polls.