Date: Wed, 26 Mar 2003 03:09:39 +0100 From: Simon Barner <barner@in.tum.de> To: Dru <dlavigne6@cogeco.ca> Cc: questions@freebsd.org Subject: Re: port to convert comma delimited file Message-ID: <20030326020939.GA657@zi025.glhnet.mhn.de> In-Reply-To: <20030325204410.D17599@dhcp-17-14.kico2.on.cogeco.ca> References: <20030325204410.D17599@dhcp-17-14.kico2.on.cogeco.ca>
next in thread | previous in thread | raw e-mail | index | archive | help
--liOOAslEiF7prFVr
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable
Hi,
> I have a comma delimited file with approximately 7000 rows and 5 columns.
> I have absolutely no database skills and and almost as much HTML skill,
> yet I need to convert this file into an HTML table. Is there something in
> the ports collection that will do this for me, a sort of converter for
> dummies? Barring that, is there any port that will do this, hopefully with
> docs so I can learn as I go?
You will not need the ports collection.
All you need is the perl programming language, and that's in the base system
(at least, if you are running 4.x, for 5.x you will have to install a port
indeed).
Have a look at the 'split' function.
Your perl script will perform the following algorithm:
print ("<TABLE>");
Read the input file line-wise
for each line, do the following
print ("<TR>");
split the line (with comma as separator) and put the result into an a=
rray
=20
for each component of the array (see the 'shift' function)
print ("<TD>");
now print the element
print ("</TD>");
=20
print ("</TR>");
=20
print ("</TABLE>");
There are lots of perl tutorials around the 'net, but if you perfer books, =
I'd
recommend "Lerning Perl" (Oreily), which I found very helpful.
Btw.: Some perl knowledge can never harm in a UN*X environment. Your task i=
s an
ideal motivation to get to now this mighty language.
Simon
--liOOAslEiF7prFVr
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (FreeBSD)
iD8DBQE+gQvjCkn+/eutqCoRAiXyAJ4/mfN+yRixdN6KRtp/DCBajQyt7ACgkP8g
U2h68YPaNQtfxOTImXV/l/s=
=0Fig
-----END PGP SIGNATURE-----
--liOOAslEiF7prFVr--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20030326020939.GA657>