M$Excel?

rossored

Senior member
2,103 56
OK not really relevant to trading but someone must know this :

MS Excel - I can remember doing this a few years ago on some marketing/mailshot thing I was doing back in my software sales days, but I cant remember how:

I've got a list of data - names, addresses etc in the following format in a .bout file (file generated by a cgi script on my webserver) which I want to export and play about with:

angela smith|1 the street|the town|the county etc - 12 fields in all.

using MS word, I can get all the "|" symbols changed to, say, commas which I can then chuck into Excel (seemed to remember something about Excel and .csv files but .... no, its gone again), but then I get a bit stuck because of course it pastes them all into one cell on the worksheet, and my grey cells are obviously going faster than I thought.

Whats the easiest way to export these from this .bout (ASCII text format) file so that I can get the data into something legible/usable, preferably in a format which I can sort it in MS Excel or something.

Anyone?

Ta.
RR
 

Trader333

Moderator
8,647 977
RR,

I am not sure I have fully understood your problem but once you have changed the | to , then you need to save the file to a format with a .txt extension.

Then try and open it in Excel by using the open file command. You should then get options for the field separations.


Paul
 

clin

Junior member
16 0
hi rossored,

not familiar with bout file? but i know a text file will open in excel. try saving word doc with txt extension.
 

TWI

Senior member
2,536 254
If you copy the .txt file to excel you can then use Data>Text to Columns to convert it if it does not do this automatically
 

rossored

Senior member
2,103 56
Ah!

Wonderful!

Thankyou all. It works like a charm, and I can now send my mailing lists to the millions :LOL:
 
 
AdBlock Detected

We get it, advertisements are annoying!

But it's thanks to our sponsors that access to Trade2Win remains free for all. By viewing our ads you help us pay our bills, so please support the site and disable your AdBlocker.

I've Disabled AdBlock