Calc text import not working correctly [closed]
Hello,
I am trying to import this text file - but it doesn't seem to work correctly.
Can you please help?
First time here? Check out the FAQ!
Hello,
I am trying to import this text file - but it doesn't seem to work correctly.
Can you please help?
Please verify activating the option for Detect Special numbers, also you can select a column a set up the proper type in column type box. Maybe select properly the Character set and Language can help.
I did try that but no joy I'm afraid. Excel recognises it as an MS DOS (PC-8) format and translates it well. This is quite critical as it means I will have to upgrade more desktops to Office2013 and I would rather not do that.
Also, the way Excel handles these imports is really nice - you can also during the import join 2 columns making it easy to create a result you desire. How can I request this as a feature in LO?
Item Number Description Customer Name Order Sch Quantity Required
550116859001 SEALKIT PLUS WASHER 00600109 AGCO INTERNATIONAL GmbH(FR SO645934 Fin 18.0 13/01/14 551101326210032 MOTOR 16.8LC SW.VALVE SNM2 VITON SHAFT SE 00603001 Alexander Dennis Ltd (Prod SO627694 Sch 14.0 13/01/14 550LG32890002 SEALPACK 32890 00600109 AGCO INTERNATIONAL GmbH(FR SO646113 Fin 9.0 14/01/14
I thought I had enclosed the file - but I can't seem to see it - I have copied and pasted the first few lines - but I'm not sure this will help you much - so I have uploaded onto mailbigfile.com . The link is here http://mbf.cc/IfKNUB - it is a text file called mfg9_8.txt. Thanks for any assistance you can offer me.
Thanks for the tip Mario. The file is a combination of TAB and spaces as delimiters by the looks of things.
Thanks I tried that earlier - I think I'll have to give up on this unless LO decide to support the MS DOS (PC-8) format and also enable one to merge columns on import like in excel
Asked: 2014-01-27 16:57:54 +0100
Seen: 1,000 times
Last updated: Jan 28 '14
How can I display two cells contents in another cell, both in hour format ? [closed]
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
LibreOffice Calc will not link to external data via internet [closed]
Is there a LibreOffice .odt, .ods viewer for Android? [closed]
Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]
Can you provide more information: Version of LO. Sample data from the file (but no private information). What you've tried so far. Date fields can give mixed results. What type of file or format of the file you are importing -- CSV, TAB, etc.
Hi ,
I'm using LO 4.1.1.2. I have enclosed the file. I tried to import it - so far the best result I have achieved is by ticking the "TAB" "SPACE" and merge delimiters boxes. But even then it is not perfect. Excel seems to handle it fine.