On Wed, 2003-01-08 at 13:05, Travis Roy wrote:
> Let me just add that it's not always 3 fields, it could be up to 30.
> Naming them is not needed.
Alright, then in that case, how about something like this:
#!/usr/bin/perl -w
use strict;
my @lengths;
my $datapos = tell DATA;
while () {
>> I cobbled the attached script together a while back
>> and it may solve at least part of your problem by
>> allowing you to tabularize your data. It's a hack
[..]
>They can't be tabs, they MUST be spaces in between
>each field and line up the data EXACTLY.
OK. So how doe
On Wed, 2003-01-08 at 13:29, [EMAIL PROTECTED] wrote:
> Why do you need to iterate over the file twice? Can't you just do
> something like:
>
[ .. code .. ]
>
> That way you only iterate over the file once.
Right, but then he actually needs to work with the data after he's found
the longest r
In a message dated: 08 Jan 2003 13:01:05 EST
Ben Boulanger said:
>Read the entire thing into memory (does not scale for
>large files) or iterate over the file twice and just mark the maximum
>length. Anyone else have a better idea on how to find the max length of
>a field in a CSV file?
Why d
> I cobbled the attached script together a while back
> and it may solve at least part of your problem by
> allowing you to tabularize your data. It's a hack
> that I never intended be seen by actual humans so,
> please, cut me at least as much slack about its
> (lack of) readability as you would
Let me just layout exactly what I do.. I didn't want to get to specific,
but I guess it's needed :)
We get files from all over for mailing lists.. They come in just about any
format you can imagine on just about any media.. 90% of them are either
Excel, or CSV. Sometimes we get CSV files that are
In-Reply-To: Your message of "Wed, 08 Jan 2003 12:35:15 EST."
<000801c2b73c$4e7a16a0$301216cf@winbox>
References: <000801c2b73c$4e7a16a0$301216cf@winbox>
I cobbled the attached script together a while back
and it may solve at least part of your problem by
allowing you to t
> > Putting data out in a formatted setup is easy once you know the max
> length of the record. I understand that you want to figure out the max
> length of each entry in each field and then add one - you can do this
> one of two ways. Read the entire thing into memory (does not scale for
> l
On Wed, 2003-01-08 at 12:35, Travis Roy wrote:
> I realize that, but my end solution is a fixed width format. Excel can
> also do that but I was looking for something a little more automated and
> easier. It's a lot easier/faster to take an excel/csv file and type
> convert filename.csv and get a n
t; To: Jerry Feldman
> Cc: [EMAIL PROTECTED]
> Subject: Re: Data conversion
>
>
> Excel can save as CSV just go to file/save as and select the format
>
>
> Jerry Feldman wrote:
>
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
&g
Excel can save as CSV just go to file/save as and select the format
Jerry Feldman wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Content-Type: text/plain; charset=us-ascii
>
> You might look at OpenOffice.org. It's calc module reads (and writes Excel
> spread sheets which you ca
Travis Roy wrote:
Hi, I'm looking for two things, they might both be in the same package,
but I can't find either, at least from a command line.
I'm looking to convert something from Excel to CSV and then from CSV to
fixed with or "Standard Data Format" as dBase calls it.. Example:
FirstN
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Content-Type: text/plain; charset=us-ascii
I was looking through their libraries and was unable to locate one which
might be useful for Travis. However, there has been some discussion on the
OOo list regarding command line switches as well as file c
On Wed, Jan 08, 2003 at 10:19:14AM -0500, Travis Roy <[EMAIL PROTECTED]> wrote:
> But Open/StarOffice are X apps. Even if they have a command line converion
> program to compile OpenOffice would require Xlibs to compile (that are not
> installed).
Depending on the modularity of OpenOffice, the
> I did.
> "Travis Roy" wrote:
>
>> You must of missed the "from a command line." part.. I need to do this
>> from a prompt.
But Open/StarOffice are X apps. Even if they have a command line converion
program to compile OpenOffice would require Xlibs to compile (that are not
installed).
___
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Content-Type: text/plain; charset=us-ascii
I did.
"Travis Roy" wrote:
> You must of missed the "from a command line." part.. I need to do this
> from a prompt.
- --
Jerry Feldman <[EMAIL PROTECTED]>
Boston Linux and Unix user group
http://www.blu.o
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Content-Type: text/plain; charset=us-ascii
>
> You might look at OpenOffice.org. It's calc module reads (and writes Excel
> spread sheets which you can save to dBASE or CSV format.
You must of missed the "from a command line." part.. I need to
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Content-Type: text/plain; charset=us-ascii
You might look at OpenOffice.org. It's calc module reads (and writes Excel
spread sheets which you can save to dBASE or CSV format.
"Travis Roy" wrote:
> Hi, I'm looking for two things, they might both be in
On Wed, 2003-01-08 at 08:57, Travis Roy wrote:
> I'm looking to convert something from Excel to CSV and then from CSV to
> fixed with or "Standard Data Format" as dBase calls it.. Example:
>
> FirstN LastN EMail
> Travis Roy[EMAIL PROTECTED]
> JoeBob[EMAIL PROT
19 matches
Mail list logo