On Friday, October 4, 2002, at 07:12 AM, John Tobey wrote:
> Then he has the combination of
>
> "MS Excel spreadsheet"
> "parsed"
> "Solaris server"
>
> which, while I have not tried to do it recently, would certainly have
> been painful in the past. I imagine it is still a pretty imprecise
> science, though I'll be happy to be proved wrong.
>
> Can you require users to save the spreadsheet in a non-Excel format
> such as tab-delimited for uploading?
I forgot to mention that this is exactly what I'm doing. The script
does this:
# sometimes there is a newline in the user data, if so
# then remove it
while (<TABDELIMITED>) {
chomp($_) if ($_ !~ m/\t{20,}/);
print TEMPFILE $_;
}
# open and loop through TEMPFILE, parsing each line
The hard part is that I have zero control over the server
configuration, so I can't use certain kinds of modules that have to be
installed. That's why I'm not using the Excel parse modules (though I
thought about it).
Erik
--
Erik Price (zombies roam)
email: [EMAIL PROTECTED]
jabber: [EMAIL PROTECTED]
_______________________________________________
Boston-pm mailing list
[EMAIL PROTECTED]
http://mail.pm.org/mailman/listinfo/boston-pm
