| View previous topic :: View next topic |
| Author |
Message |
Bronc
General User
Joined: 19 May 2006
Posts: 6
|
 Posted: Fri May 19, 2006 9:20 am Post subject: Saving .txt Files |
 |
|
| OK, instead of opening them, how do I save them properly? |
|
| Back to top |
|
 |
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Fri May 19, 2006 11:03 am Post subject: Re: Saving .txt Files |
|
|
| Bronc wrote: | | OK, instead of opening them, how do I save them properly? |
Assuming you mean savining several cells, each with text, Save As and choose CSV.
David. |
|
| Back to top |
|
|
Bronc
General User
Joined: 19 May 2006
Posts: 6
|
| Posted: Fri May 19, 2006 11:23 am Post subject: |
|
|
| yeah, i figured that out about five minutes after i posted it, but the way i want it saved it ruins the formatting. |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Fri May 19, 2006 1:20 pm Post subject: |
|
|
| Bronc wrote: | | yeah, i figured that out about five minutes after i posted it, but the way i want it saved it ruins the formatting. |
CSV is strictly data. Formatting implies keeping the spreadsheet [or wordprocessor] codes; i.e. saving AS a spreadsheet. If simply passing the data to another program, it is up to the other program to determine what formatting is needed there. Considering the wide variety of programs that can make use of a CSV file, it's still pretty awesome, yet so simple. It is the stuff other than the raw data that make the file a spreadsheet or whatever.
David. |
|
| Back to top |
|
|
Bronc
General User
Joined: 19 May 2006
Posts: 6
|
| Posted: Fri May 19, 2006 2:09 pm Post subject: |
|
|
| would it help if i posted the .txt i wanted to preserve? |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Sat May 20, 2006 6:44 am Post subject: |
|
|
| Bronc wrote: | | would it help if i posted the .txt i wanted to preserve? |
Bronc,
I think that you are asking the wrong question but I am not sure what the right one is. And yes it probably would help if we could see what you want to save.
A handy place to post a file that others can read is http://www.mytempdir.com
However, to return to the question: When you say that you want to save something as.txt this means in computer terms that you "want" to save with no formatting, i,e, that you want to strip all the formatting from the text leaving only the 'raw' text. That is exactly what David gave you.
It does not sound like that is what you want to do. Can you give us a bit of description of what you have and what you want to achieve?
BTW, you might want to look at Edit > Paste Special > and see if there is anything there that might help.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
Bronc
General User
Joined: 19 May 2006
Posts: 6
|
| Posted: Sat May 20, 2006 7:48 am Post subject: |
|
|
huh. never knew about this site.
Click Here
i'm actually doing a project for a game and this file can only be done in spreadsheet form. if it doesn't get saved properly the game won't work properly. |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Sat May 20, 2006 8:38 am Post subject: |
|
|
| Bronc wrote: | huh. never knew about this site.
Click Here
i'm actually doing a project for a game and this file can only be done in spreadsheet form. if it doesn't get saved properly the game won't work properly. |
Uh, what it this supposed to look like or do?
I seem to have a text file that I cannot properly open in Calc because the first three lines are
| Code: | This file contains ship data for SFC
<- keep this coulmn blank if your line is a comment....
|
and this is followed by 61 blank lines. The actual data seem to start on line 65.
Once I delete the 64 lines and save the file as a csv file I can open it in Calc however there seems to be some 0's in the first column that don't make sense. Have a look at
http://ca.geocities.com/jrkrideau/OpenOffice/spacebats.jpg to see what I mean.
You need to give us a clue about what the thing is supposed to be or to do. and what it or is not missing when you save it as a text file. Is this supposed to feed into a database for the game or is it a layout for developing rules or what??
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Sat May 20, 2006 9:12 am Post subject: |
|
|
| Bronc wrote: | | i'm actually doing a project for a game and this file can only be done in spreadsheet form. if it doesn't get saved properly the game won't work properly. |
You seem to be expecting a lot, but offering little. If you need the file as a spreadsheet, rename the filename.txt as filename.csv. When you decide to bring that into Calc, be sure to choose the TAB delimiter to separate into cells.
You say it must be "saved properly", but don't say what "properly" is.
David. |
|
| Back to top |
|
|
Bronc
General User
Joined: 19 May 2006
Posts: 6
|
| Posted: Sat May 20, 2006 12:49 pm Post subject: |
|
|
| jrkrideau wrote: | | Bronc wrote: | huh. never knew about this site.
Click Here
i'm actually doing a project for a game and this file can only be done in spreadsheet form. if it doesn't get saved properly the game won't work properly. |
Uh, what it this supposed to look like or do?
I seem to have a text file that I cannot properly open in Calc because the first three lines are
| Code: | This file contains ship data for SFC
<- keep this coulmn blank if your line is a comment....
|
and this is followed by 61 blank lines. The actual data seem to start on line 65.
Once I delete the 64 lines and save the file as a csv file I can open it in Calc however there seems to be some 0's in the first column that don't make sense. Have a look at
http://ca.geocities.com/jrkrideau/OpenOffice/spacebats.jpg to see what I mean.
You need to give us a clue about what the thing is supposed to be or to do. and what it or is not missing when you save it as a text file. Is this supposed to feed into a database for the game or is it a layout for developing rules or what?? |
That's supposed to be that way, don't ask. This file is from a game from the 1990's so the file should look sloppy.  it's kind of like a database, yes. this file has all the ship data and weapons and model files. If i were to open it in notepad i wouldn't be able to edit it properly because of the complex workings of the file. but if i were to open it in spreadsheet form it would be much easier to edit without royall ****ing something up.
@ David: If you look at that file, you'll see. |
|
| Back to top |
|
|
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| Posted: Sat May 20, 2006 1:35 pm Post subject: |
|
|
| Bronc wrote: | | David: If you look at that file, you'll see. |
I did. Let's try again:
1. I change the file name to sfbspc13.csv
2. I open it using Calc, and am shown a dialogue in which I can select the Tab delimiter. I do.
3. It is now a spreadsheet. I can edit that.
4. I Save As, and choose to save as CSV.
5. I change the extension back to TXT, and am done.
Whatever else you have in mind, I've run out of options.
David. |
|
| Back to top |
|
|
Bronc
General User
Joined: 19 May 2006
Posts: 6
|
| Posted: Sat May 20, 2006 2:26 pm Post subject: |
|
|
| well, your way works. everything is the same. thanks! |
|
| Back to top |
|
|
|
