[softwarelist] Re: Export to CSV?
- From: Alan Adams <alan@xxxxxxxxxxxxxxxx>
- To: davidpilling@xxxxxxxxxxxxx
- Date: Tue, 26 Feb 2013 19:46:58 GMT
In message <e893fc2353.ewen@xxxxxxxxxxxxxxxxxxxxx>
Ewen Pring <Ewen_Pring@xxxxxxxxxxxxx> wrote:
> David Pilling <flist@xxxxxxxxxxxxxxxxxxx> wrote on 25 Feb 2013:
>> On 25 Feb 2013, at 08:24, Ewen Pring <Ewen_Pring@xxxxxxxxxxxxx> wrote:
>>> Has anybody written an applet to export Ovation Pro stories from a
>>> document as a CSV file?
>> I think I'd save the whole document as DDL and then parse out (with
>> another piece of code), the details I wanted.
>> I suppose if I had got around to adding the script functions to allow
>> the caret to be stepped around a document, then that plus saving the
>> contents of text frames would be another way.
>> I'm not sure how your stories with newlines etc. will play with CSV,
>> which usually has elements separated by commas or tab characters, with
>> records split by newlines. It would work if you escaped formatting,
>> like the C language convention of (slash) n for new line etc.
> Thanks for the suggestions to look at exported DDL, I will
> investigate. It is a shame it can't be done by writing an applet,
> though.
> Best regards
You should be aware that multiple lines in CSV cells will cause
problems. Excel for one will only display the first line.
You may have to put some form of token in place of the newline. \n
would be an obvious choice. You then need to work out what to do with
the token when reading the result.
--
Alan Adams, from Northamptonshire
alan@xxxxxxxxxxxxxxxx
http://www.nckc.org.uk/
To unsubscribe or subscribe goto: //www.freelists.org/list/davidpilling
Other related posts:
