Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: I need help in sorting a text file

21 Mar 2018   #11
mrjimphelps

Linux Mint 18.2 xfce 64-bit (VMWare host) / Windows 8.1 Pro 32-bit (VMWare guest)
 
 

Download and install Libre Office -- it's free. Open Libre Office Calc, and open a new spreadsheet. Copy each column of words, and paste them into the new Calc spreadsheet, so that you end up with one column containing all of the words. Now sort that column.


My System SpecsSystem Spec
.
21 Mar 2018   #12
iko22

Windows 7 x64, Vista x64, 8.1 smartphone
 
 

Quote   Quote: Originally Posted by mrjimphelps View Post
Copy each column of words, and paste them into the new Calc spreadsheet, so that you end up with one column containing all of the words. Now sort that column.
Doesn't quite work, as Ive tried this myself before. When I go to copy the words, When I drag mouse down to include next line, the blue highlight goes to the end of line and automatically includes end of line.

To separate the columns in a spreadsheet, first you need to add a comma at the end of every word, and then save documnet as a (.txt) text file, and then open this modified file in the spreadsheet. Then you can highlight a column and cut and paste it where you want.

Quote   Quote: Originally Posted by reble View Post
I opened the text file in EditPad Lite and this is what I got. see the attached file. This looks like a raw HTML file to me. The original file is RTF. I looked over the prog and I can't get rid of the coding info.
Select Find and Replace, and enter "\par" in the find box (without the double quotes), and enter " " (without the double quotes) in the replace box. Then select "Replace All" or use "Replace Next" repeatedly.
My System SpecsSystem Spec
21 Mar 2018   #13
mrjimphelps

Linux Mint 18.2 xfce 64-bit (VMWare host) / Windows 8.1 Pro 32-bit (VMWare guest)
 
 

You should be able to highlight and copy an entire column in the text file, then click on one cell in the spreadsheet, then choose Paste. You don't need to drag the mouse down to include the next line; Calc should paste each word into its own separate cell.
My System SpecsSystem Spec
.

21 Mar 2018   #14
iko22

Windows 7 x64, Vista x64, 8.1 smartphone
 
 

Nope, I tried again, it wont do a column for me, as the highlight automatically includes the entire line when I move the cursor down.

I need help in sorting a text file-tabular-text.png

From the picture, if I were to highlight A1, then move the cursor to the end of D1 all the labels on the right side also get highlighted (this is in Word).

I think I can highlight all the text and then do "Insert Table" followed by "Convert Text to Table" that separates into columns that way.


My System SpecsSystem Spec
21 Mar 2018   #15
reble

windows 7 home 32 bit, I just changed back from 64 to 32bit
 
 
I need help in sorting a text file

I didn't know I could get a replacement MS office by saving the product key. Anyways It was MS office 97 and in English. I threw out the cd and scraped the product key off the jewel case when the cd went bad.

Quote   Quote: Originally Posted by Megahertz07 View Post


I can try to send a MS office download link if you tell us what is the version and language you want.
My System SpecsSystem Spec
22 Mar 2018   #16
billm5

Windows 7 Home Premium 64-bit
 
 

Quote   Quote: Originally Posted by reble View Post
A PS: I have been looking for a free word processor that isn't bundled with a bunch of other progs like Excel, Power Point, Office Online and Outlook that meets my needs. I just need the word processor. I am retired. I have no need to keep such files that need the other prog's that come bundled.
What functionality do you need? Is WordPad sufficient?

Or... Word Starter of course is bundled with Excel Starter as Microsoft Office Starter, but the other apps in that bundle don't get in the way... and it ships free with many Win7 machines... "gentle overkill"
My System SpecsSystem Spec
22 Mar 2018   #17
reble

windows 7 home 32 bit, I just changed back from 64 to 32bit
 
 
I need help in sorting a text file

WordPad almost foots the bill. WordPad's default font is Calibri and size is 11. I would like to change the default font and size. WordPad doesn't have the sort cmd period. And WordPad can only read TXT and RTF files. WordPad doesn't know what to do with the codes that are in *.doc and*.docx and so on. And when you said "Word Starter" it triggered a memory about an old word processor that I used to use called "Word Star". Word Star back then was a freeware stand alone word processor. If it still is, I have no ides.

Quote   Quote: Originally Posted by billm5 View Post
What functionality do you need? Is WordPad sufficient?

Or... Word Starter of course is bundled with Excel Starter as Microsoft Office Starter, but the other apps in that bundle don't get in the way... and it ships free with many Win7 machines... "gentle overkill"
My System SpecsSystem Spec
22 Mar 2018   #18
reble

windows 7 home 32 bit, I just changed back from 64 to 32bit
 
 

Word Starter didn't come with the copy of Windows 7 Home that I have. I got this Win7 at Walmart about 4 to 5 yrs ago.
My System SpecsSystem Spec
22 Mar 2018   #19
reble

windows 7 home 32 bit, I just changed back from 64 to 32bit
 
 

I have downloaded Libre Office and installed it. I have learned how to make the 2 columns ( now I have learned to spell column without having to looking it up. That's how I learn new things, hands on). But I still can't select and copy just the left column of words I can only highlight and copy both columns on a single page.
My System SpecsSystem Spec
22 Mar 2018   #20
br4

Windows 7 Ultimate x64
 
 

When you do the copy from the text file into the spreadsheet application are you getting both columns in only one column? If so, and to be expected, you need to do the LibreOffice equivalent of 'text to columns' to split your two columns into the two spreadsheet columns. I don't use LO, but a quick search shows to use Data / Text to Columns.
My System SpecsSystem Spec
Reply

 I need help in sorting a text file




Thread Tools




Similar help and support threads
Thread Forum
File Sorting Problem
Ive just discovered a new problem. In Win XP All my Movie file clips were sorted by Name ie: Dandy, Dandy (1), Dandy (2). Now this dang Win 7 is sorting them Dandy (1), Dandy (2), Dandy. NOW the first clip is Last. How the heck could MS change sorting after years the first way. AHHHH!
General Discussion
Batch File Sorting
Hi Guys, I have collection of 35k lyrics in .txt files. They are all in one folder. Is there a way to sort them all in separate Folders (by Artist name for example) Here is a screenshot, how it looks. Free image hosting for your screenshots + free screen capture tool Thanks in advance
General Discussion
file sorting
I can't seem to get my file folders to sort into catagories . :mad: I want links together, graphics together, word together...etc :cry:
General Discussion
File sorting - limited to one level now?
In Vista, I was able to sort files by date created, highlight the files I want, then sort again by name, and all the files I selected previously would still be highlighted, but now they're in numerical order. Win 7 won't let me apply that second level of sorting. It's either name or date, but not...
General Discussion
File Sorting
I am trying to figure out if it's possible to ignore the articles in a file name (i.e. A, An, The) for sorting purposes. More specifically, I want to organize my music folder and I want the folder for "The Beatles" to sort with the other letter "B" artists instead of with the "T" artists. I...
General Discussion


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 20:20.
Twitter Facebook Google+