Apache OpenOffice Community Forum

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

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?

Therabi. I'm not sure what you're talking about. On the splash page I clicked on document and took it from there.

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.

Therabi,
No dice on the sorting. I clearly don't know what I'm doing.

Does the page your working on look like a sheet of plain paper or like graph paper with lines running up/down and across?

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.

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.

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.