[Solved] Alphabetizing lists as typed

Discuss the word processor

[Solved] Alphabetizing lists as typed

Postby Fumbly210 » Tue Nov 30, 2010 10:18 pm

How do I alphabetize a 6 page list I have made.
The list is all websites. They are uppercase and underlined.
Below each address is a username and password.
When I tried to "sort" the document, it got all seperated and split up. All the websites start with a different letter. I want to alphabetize this list. It is one column per page.
I don't know what to call it. Data sheet, spreadsheet, etc..I am not an office person, so I just call it a list.
Any direction on how to alphabetize this list will be appreciated.
Have a great holiday,
Fumbly210
Last edited by Fumbly210 on Wed Dec 01, 2010 2:09 am, edited 1 time in total.
Openoffice 3 on Windows 7
Fumbly210
 
Posts: 5
Joined: Tue Nov 30, 2010 10:11 pm

Re: alphabetizing lists as typed...

Postby therabi » Tue Nov 30, 2010 10:28 pm

Fumbly210 wrote:How do I alphabetize a 6 page list I have made.
The list is all websites. They are uppercase and underlined.
Below each address is a username and password.
When I tried to "sort" the document, it got all seperated and split up. All the websites start with a different letter. I want to alphabetize this list. It is one column per page.
I don't know what to call it. Data sheet, spreadsheet, etc..I am not an office person, so I just call it a list.
Any direction on how to alphabetize this list will be appreciated.
Have a great holiday,
Fumbly210


What application did you use to create the list, Writer or Calc?
OpenOffice.org v3.3, LibO v3.32 on Ubuntu 10.10 and Win7
User avatar
therabi
Volunteer
 
Posts: 763
Joined: Wed Sep 01, 2010 10:01 pm
Location: USA

Re: alphabetizing lists as typed...

Postby Fumbly210 » Tue Nov 30, 2010 10:45 pm

Therabi. I'm not sure what you're talking about. On the splash page I clicked on document and took it from there.
Openoffice 3 on Windows 7
Fumbly210
 
Posts: 5
Joined: Tue Nov 30, 2010 10:11 pm

Re: alphabetizing lists as typed...

Postby Fumbly210 » Tue Nov 30, 2010 10:54 pm

Therabi.
I just went back and worked with the installing of 3.2.
I had a choice of writer or calc...among others. I chose writer and opened it up.
I'll try to sort it now and see what happens.
Openoffice 3 on Windows 7
Fumbly210
 
Posts: 5
Joined: Tue Nov 30, 2010 10:11 pm

Re: alphabetizing lists as typed...

Postby Fumbly210 » Tue Nov 30, 2010 10:57 pm

Therabi,
No dice on the sorting. I clearly don't know what I'm doing.
Openoffice 3 on Windows 7
Fumbly210
 
Posts: 5
Joined: Tue Nov 30, 2010 10:11 pm

Re: alphabetizing lists as typed...

Postby therabi » Tue Nov 30, 2010 10:59 pm

Does the page your working on look like a sheet of plain paper or like graph paper with lines running up/down and across?
OpenOffice.org v3.3, LibO v3.32 on Ubuntu 10.10 and Win7
User avatar
therabi
Volunteer
 
Posts: 763
Joined: Wed Sep 01, 2010 10:01 pm
Location: USA

Re: alphabetizing lists as typed

Postby Fumbly210 » Tue Nov 30, 2010 11:46 pm

paper is like piece of plain white stationary. The column of addresses is margined fluch left. There are two spaces between each entry....I'll try to show you ..

DDDDD.DDD
uxxxxxxx - xxxxh
pxxxxxxx - xxxxxxx


FFFFFFFFFFFF.COM
usexxxxx - ddddd. dddd
pasxxxxx - jjjjm.jjjjj

and so on for 6 pages.
Openoffice 3 on Windows 7
Fumbly210
 
Posts: 5
Joined: Tue Nov 30, 2010 10:11 pm

Re: alphabetizing lists as typed

Postby therabi » Wed Dec 01, 2010 12:06 am

Fumbly210 wrote:paper is like piece of plain white stationary. The column of addresses is margined fluch left. There are two spaces between each entry....I'll try to show you ..

DDDDD.DDD
uxxxxxxx - xxxxh
pxxxxxxx - xxxxxxx


FFFFFFFFFFFF.COM
usexxxxx - ddddd. dddd
pasxxxxx - jjjjm.jjjjj

and so on for 6 pages.


You need to have each link + use + pass on one line, making 1 paragraph. Then highlight the full text and then sort. What is happening is that Write is seeing each line as a new paragraph and sorting everything. A simpler way would have been to do it in Calc with link in the first column, use in the second and pass in the third.
OpenOffice.org v3.3, LibO v3.32 on Ubuntu 10.10 and Win7
User avatar
therabi
Volunteer
 
Posts: 763
Joined: Wed Sep 01, 2010 10:01 pm
Location: USA

Re: alphabetizing lists as typed

Postby floris v » Wed Dec 01, 2010 12:07 am

There is a way to do it. Using a set of replace commands. Make a copy of your file and work with the copy.
Press Ctrl+F, then type ^$ in the Search for box and || in the Replace with box. Click More options and click Regular expressions. Click Replace all. That will remove all paragraph breaks. Now type || in the Search for box and \n in the Replace with box and click Replace all again. Now all entries are on their own line. Select all text (Ctrl+A), Tools - Sort - go for it.

If your problem has been solved, please edit the first post in this thread and add [Solved] to the title bar.
MS Windows Vista - AOO 4.0.1 - LibreOffice 4.1.0.4.
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
User avatar
floris v
Moderator
 
Posts: 3029
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands


Return to Writer

Who is online

Users browsing this forum: Google [Bot] and 42 guests