How to import a txt file

Discuss the spreadsheet application

How to import a txt file

Postby promytius » Sun Jan 19, 2020 6:29 pm

 Edit: Split from solved topic 41045 
I just tried to do this and the items (0000000f - money) as an example, imports in as a scientific notation of that number with the "+e notation, no opportunity to set delimiters, and each cell seems to randomly set to left or right justify. Once in that scientific notation, you can't get the 'text' version back, and it is inconsistent, some are converted, some aren't.
What a mess. Thanks.
Last edited by MrProgrammer on Sun Jan 19, 2020 9:44 pm, edited 2 times in total.
Reason: New person with new problem needs new topic
OpenOffice 4.1.7 on W10pro
promytius
 
Posts: 3
Joined: Fri Jan 10, 2020 4:02 am

Re: [Solved] How to import a txt file

Postby John_Ha » Sun Jan 19, 2020 6:36 pm

promytius wrote:I just tried to do this and ... it is inconsistent, some are converted, some aren't.

Upload the txt file, or a portion of it showing the problem, for advice on which parameters to set. It is probably a problem in the txt file and Calc is merely following the instructions you are giving it.

As a new poster you will find much useful information in the User Guides. May I suggest you bookmark the pages.

Press F1 to access the Help screen and search for your problem

When a pop-up window opens, click the Help button for extensive help on that function - it is often more comprehensive than the manual.

See [Tutorial] Differences between Writer and MS Word files for a description of differences and for why you should always work in, and save Writer files as .odt, Calc files as .ods, Impress files as .odp etc.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 7796
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: How to import a txt file

Postby promytius » Tue Jan 21, 2020 12:03 am

Ever since I first booted into Windows for Workgroups, Notepad has always been my goto for format stripping. I cannot remember a time when it did not work. It just does ASCII, no tabs no indents no italics, just straight ascii, which is why I wa shocked to see such a mess resulting from bringing in a notebook-handled text file.
It's not a real problem, I found two other free office suites that imported the text file without any issues. Thank you for your reply and good luck on your continuing to improve your product.
OpenOffice 4.1.7 on W10pro
promytius
 
Posts: 3
Joined: Fri Jan 10, 2020 4:02 am

Re: How to import a txt file

Postby robleyd » Tue Jan 21, 2020 12:15 am

It may be that when you imported the file, you missed checking an option in the Text Import filter, labelled Detect special numbers.
Attachments
oo_text_import.png
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3463
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia


Return to Calc

Who is online

Users browsing this forum: FJCC, Google [Bot] and 17 guests