On 08/27/2008 07:19 AM, Peter Saffrey wrote:
I'd like to be able to convert a spreadsheet (probably in Excel format) into a set of CSV files representing each tab. Can I do this in a script?You certainly can save a document in a tab-delimited format by save as, select file type text csv and edit filter settings, and pull down the Field delimiter to {tab}.I'm running on Linux. This is part of a web based application where a user submits a CSV file for processing. At the moment, my users have to save each tab individually before submission, which is a bit tedious.
Or, if you get a true comma delimited file, you could use a simple bash (using sed) or perl script to change the commas to tabs.
-- Jerry Feldman <[EMAIL PROTECTED]> Boston Linux and Unix user group http://www.blu.org PGP key id: 537C5846 PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB CA3B 4607 4319 537C 5846
signature.asc
Description: OpenPGP digital signature
