Am 07.03.2012 22:03, Johnny Rosenberg wrote:
A Tab delimited text file – what more could we want to know?
4 different lines of tab delimited text each with 4 identical values:
2012/03/08 1,213.59 text 7-8
"2012-03-08" "1,213.59" "text" "7-8"
8.März12 01213,59 text 7-8
03/08/2012 $1213.59 "text" "7-8"
[...] to be continued with dozends of variants
The import dialog covers all these situations plus dozends of character
encodings.
If you google for macros to load csv you will find dozends of ready
made solutions and all of them use a different set of FilterOptions. The
FilterOptions are bundled in a complex string that reflects all the
settings of the import dialog.
http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/OfficeDev/Handling_Documents#MediaDescriptor
http://wiki.services.openoffice.org/wiki/Documentation/BASIC_Guide/StarDesktop
http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Filter_Options
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
