jack: (Default)
[personal profile] jack
Suppose I had a spreadsheet with columns name, email, and message, and I have a windows computer and an account on a unix server. What do you think the easiest way to turn that into n emails is?

Date: 2005-04-12 03:41 pm (UTC)
From: [identity profile] mobbsy.livejournal.com
Assuming you don't have any commas in the middle of your CSV records. There is a "message" field in [livejournal.com profile] cartesiandemon's spec. Probably safer to use the Perl CSV module.

Date: 2005-04-12 03:48 pm (UTC)
From: [identity profile] filecoreinuse.livejournal.com
Well opviously any code posted into LJ comments is sanity low-passed :).

Date: 2005-04-12 03:51 pm (UTC)
From: [identity profile] cartesiandaemon.livejournal.com
I can easily use something-else separated; or I can recast my sentences to use semicolons; or I could strip up to the second comma ...

Wait, can you have commas in email addresses? :)

Date: 2005-04-12 05:22 pm (UTC)
From: [identity profile] sphyg.livejournal.com
This is why I like TSV.

Date: 2005-04-13 01:13 pm (UTC)
From: [identity profile] cartesiandaemon.livejournal.com
Though there could be an argument for $weird-character-separated, not that I *would* use tabs...

Wait, can you have tabs in email addresses? :)

Date: 2005-05-09 05:25 pm (UTC)
From: [identity profile] sphyg.livejournal.com
Good point. Which is the weirdest character?

Date: 2005-05-09 05:44 pm (UTC)
From: [identity profile] cartesiandaemon.livejournal.com
Well, if you could use unicode... :)