The easiest thing may be to use a comma as the delimiter and name the file with .csv extension you can load it directly into calc. Next best would be to paste the data from a text file into one column in calc and use the Text2Columns macro to parse that column by the delimiter that you've used. I believe the macro can be found if you go to the OOo site and search for 'macros'.
tc
Dave S wrote:
Hi there,
I have written a (complicated for me :), 55KB) spreadsheet & it works well.
I have a m505 palm PDA which I would like to collect data with & 'paste' into my spreadsheet. It does not support any form of spreadsheet but I would probarbly write the data in the notepad with delimiter of '/' ie
/8:00/10:15/mr jackson/somewhere street/ etc.
Can anyone point me in the right direction to pull this data from a file and put it into my spreadsheet? I have experience of programming in Python, Basic etc but know little of oocalc or how to proceed.
Any hints greatfully recieved :)
Dave
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
