It's not exactly a BBedit solution, but I do this a lot with Excel and
OpenOffice. I just save as CSV first - there's a couple tools I use on my
mac, one that lets you choose a number of diferent delimitations and gives a
friendly little GUI too (as long as you don't mind inferring the ifx in
German):
http://www.oio.de/public/konverter/csv2xml.htm
Works great, I've used it for years, and have yet to see a file bring it to
its knees. It's default setting is semi-colon delimited though.
Commandline (with english base) which I've not used is here
http://www.dpawson.co.uk/java/csv2xml.html
I've never used it as CSV2XML.jar has always done the trick.
john
--
John Robert Gardner, Ph.D., NR-EMT
Principal Information Architect
Keane Architecture Services
Cambridge, MA
Views and opinions expressed or implied in this email are independent of
Keane, National EMT Registry, and/or their clients and partners.
On 5/19/07, BBEdit-Talk List <[email protected]> wrote:
BBEdit-Talk Digest #1960
1) Re: tab-delimited-text to XML?
by Chris Pepper <[EMAIL PROTECTED]>
At 9:21 AM -0600 2007/05/18, Doug McNutt wrote:
>At 07:48 -0400 5/18/07, Bill Whitacre wrote:
>>Thanks Walter. I think I'll work on a PHP script today to do it.
>>It'll give me something to do on my telecommuting day!
>
>Out of curiosity, do you regularly find reasons to view tab
>separated Excel "txt" files with BBEdit?
>
>I find it nearly impossible except for columns of pure numbers with
>no interposed text items of varying length. Typewriters and 026 card
>punches have better setting facilities for tab stops.
I do this frequently, roundtripping between BBEdit & Excel
because editing multiple fields in Excel is so painful, while viewing
non-fixed-length tabular data in in BBEdit is difficult.
Chris
--
Chris Pepper: <http://www.reppep.com/~pepper/>
<http://www.extrapepperoni.com/>
The Rockefeller University: <http://www.rockefeller.edu/>
--
------------------------------------------------------------------
Please send bug reports to <[EMAIL PROTECTED]>, not to the list.
List FAQ: <http://www.barebones.com/support/lists/bbedit_talk.shtml>
List archives: <http://www.listsearch.com/BBEditTalk.lasso>
To unsubscribe, send mail to: <[EMAIL PROTECTED]>
