Matrix Games Forums

 Forums  Register  Login  Photo Gallery  Member List  Search  Calendars  FAQ 

My Profile  Inbox  Address Book  My Subscription  My Forums  Log Out

Excel And Text Files

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
  Printable Version
All Forums >> [New Releases from Matrix Games] >> Distant Worlds 1 Series >> Design and Modding >> Excel And Text Files Page: [1]
Login
Message << Older Topic   Newer Topic >>
Excel And Text Files - 10/26/2013 8:36:14 AM   
Darkspire


Posts: 1986
Joined: 6/12/2003
From: My Own Private Hell
Status: offline 		Does anyone know the correct order of selections to get a text file to be read properly in Excel 2007?
First off I have no problems with getting it in using open and selecting the file, its what options to select on the import wizard so that the data is displayed correctly, columns displayed correctly under one another, names of items being correctly spaced etc.

This is an example of what I have tried, I have tried all the combinations I can come up with and still not getting what I want.

1.Delimited
2.Delimiters:
Tab
Comma
Space
3.Column data format
General

Thanks

Darkspire

_____________________________

Darkspires's File Repository
Post #: 1
RE: Excel And Text Files - 10/27/2013 6:17:39 AM   
dostillevi

 

Posts: 222
Joined: 8/31/2012
Status: offline 		Can you point me towards the file you're working on? I find I get good results using delimiters tab comma and space, with the box checked to treat consecutive delimiters as one. The preview window gives a pretty accurate example of how the data will be arranged. I just tested this with the biases file and it imported the values correctly.

(in reply to Darkspire)
Post #: 2
RE: Excel And Text Files - 10/27/2013 7:55:03 AM   
Darkspire


Posts: 1986
Joined: 6/12/2003
From: My Own Private Hell
Status: offline 		That works for single names, if the names have spaces in the columns get messed up and is as useful as a text editor view of the file. I am none to bothered about the names as long as they are all in one column, I can resize that, its the data that is not aligned that is giving me the headache, I know it can be done but I have not worked with excel since the 97 release when I used it for Diablo II.

Unfortunately I can not comment on file types as I am currently in the field on a top secret mission for the NDA

Thanks though, I have another permutation to add to the mix, the tickbox for treat as one, tried that a few times but gave it up with the results I was getting, just never tried it with the biases file, so I know it works at least and I am heading in the right direction.

Edit:

It works Just use tab and comma not space, with treat as one checked, bingo
Now all I need to do is work how to save it, CSV screws it up as does TXT (delimited)

Darkspire

< Message edited by Darkspire -- 10/27/2013 9:18:09 AM >

_____________________________

Darkspires's File Repository

(in reply to dostillevi)
Post #: 3
RE: Excel And Text Files - 10/29/2013 8:07:51 PM   
Cardassian_Union


Posts: 14
Joined: 8/26/2013
Status: offline
quote:

It works Just use tab and comma not space, with treat as one checked, bingo

I am using, just comma without tab. It works fine. Ok, i am using LibreOffice not Office-Excel ... ;)

quote:

Now all I need to do is work how to save it, CSV screws it up as does TXT (delimited)

So whats the result? How does it look like?

The Cardassian_Union

(in reply to Darkspire)
Post #: 4
RE: Excel And Text Files - 10/29/2013 8:10:34 PM   
Darkspire


Posts: 1986
Joined: 6/12/2003
From: My Own Private Hell
Status: offline
quote:

ORIGINAL: Cardassian_Union

quote:

It works Just use tab and comma not space, with treat as one checked, bingo

I am using, just comma without tab. It works fine. Ok, i am using LibreOffice not Office-Excel ... ;)

quote:

Now all I need to do is work how to save it, CSV screws it up as does TXT (delimited)

So whats the result? How does it look like?

The Cardassian_Union


One ends up incorrectly spaced without commas or incorrectly spaced with commas everywhere, so I just saved them in the default format so that they are easier to view

Darkspire

_____________________________

Darkspires's File Repository

(in reply to Cardassian_Union)
Post #: 5
RE: Excel And Text Files - 10/29/2013 8:45:39 PM   
Cardassian_Union


Posts: 14
Joined: 8/26/2013
Status: offline 		You have one line without commas and one with in the same file?
Whats your Textexport-settings / filter-settings in the Save As Dialog?


Sorry, i don't get it without seeing the file. :/ You can mail your file, if you like? So i am able to reconstruct the problem... or not! ;P

The Cardassion_Union

(in reply to Darkspire)
Post #: 6
RE: Excel And Text Files - 11/11/2013 10:56:26 PM   
BigWolfChris


Posts: 634
Joined: 3/31/2010
Status: offline 		Darkspire, did you get this sorted how you wanted in the end?

_____________________________

AMD Ryzen 7 2700X 8 Core @3.7GHz
2x16 GB Vengeance LPX 2666MHz RAM
MSI RTX 2070 Armor 8G
SSD Drive

(in reply to Cardassian_Union)
Post #: 7
RE: Excel And Text Files - 11/12/2013 1:27:59 AM   
Darkspire


Posts: 1986
Joined: 6/12/2003
From: My Own Private Hell
Status: offline
quote:

ORIGINAL: BigWolf

Darkspire, did you get this sorted how you wanted in the end?


Kind of, I am learning Excel as I am using it, I can get the data in and able to format it, add formulas etc for display and easy reading of data but getting a basic file out to text files that have all the right format I still have no idea (for example the biases.txt), CSV or text I still end up with problems on the output file.
Have not commented on here due to the NDA, been cut and pasting from Excel to Textpad or just writing from scratch. All I need to know is the correct output settings.

Darkspire

_____________________________

Darkspires's File Repository

(in reply to BigWolfChris)
Post #: 8
RE: Excel And Text Files - 11/12/2013 2:20:17 PM   
BigWolfChris


Posts: 634
Joined: 3/31/2010
Status: offline 		Unfortunately, due to the nature of said files, excel and openoffice calc is an f'ing pain the in the behind
Don't know about excel (don't use it), but there is sort of a way in calc to do it
Basically the simplest method is using string concatenation
You'll need to set up 2 (IIRC) concatenation methods

Can't really go into to much detail here yet obviously, but if you want, post to my thread in the 'NDA area' (lol) and we can chat in more detail there

_____________________________

AMD Ryzen 7 2700X 8 Core @3.7GHz
2x16 GB Vengeance LPX 2666MHz RAM
MSI RTX 2070 Armor 8G
SSD Drive

(in reply to Darkspire)
Post #: 9
RE: Excel And Text Files - 11/12/2013 7:20:07 PM   
Shark7


Posts: 7937
Joined: 7/24/2007
From: The Big Nowhere
Status: offline 		I can get them to read ok, but have trouble getting them to save correctly.

_____________________________

Distant Worlds Fan

'When in doubt...attack!'

(in reply to BigWolfChris)
Post #: 10
Page:   [1]
All Forums >> [New Releases from Matrix Games] >> Distant Worlds 1 Series >> Design and Modding >> Excel And Text Files Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts


Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

2.406