[Solved] Alphabetizing lists as typed

[Fumbly210]

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

[therabi]

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?

[Fumbly210]

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

[Fumbly210]

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.

[Fumbly210]

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

[therabi]

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

[Fumbly210]

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.

[therabi]

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.

[floris v]

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.