reading messy data from spreadsheet

[xombox@seznam.cz]

Hello,

I have tried to load data from spreadsheet file (see the attachment) but it doesn`t work correctly, although I have tried to use different delimiter and format settings. Could you please give me advice how to handle this problem?

The only possibility that worked was to copy all data to openoffice, convert dots to commas and then copy it back. However, this is not much userfriendly 😞

Thank you for your help!

[GregFreeman]

Have you tried something like this with read spreadsheet file?

Message Edited by for(imstuck) on 05-07-2009 03:29 PM

[johnsold]

You have specified an incorrect delimiter.  The correct delimiter is tab, which is the default.  If you disconnect your delimiter, you get all the data in "subarray."

The symbol for tab is \t not /t.  You also need to change the constant format to '\' Codes Display.  Context click on the constant and select from the pop up menu.

Lynn