REQ: How to sort 4-line addresses alphabetically

[Stuart Reed]

I have hundreds of 4-line addresses (of companies) gathered from several
different sources and would like to be able to create a duplicate list which
shows all the information on one line so that I can sort them
alphabetically. Is there a quick way of doing this?

All help gratefully appreciated.

Stuart Reed

 

[Howard Kaikow]

A crude way would be to create a 4 column table.
Put each line of the address in the appropriate column.
Then sort on the column of interest.

 

[Suzanne S. Barnhill]

If you're lucky enough to have the addresses in either of the following
formats, then you have a good start:

1. Lines ending in line breaks, address block ending in a paragraph break.
You can sort (by paragraphs) as is (using Table | Sort), but you'll be
sorting by the first word in each block. You can choose to sort by Word 2 or
Word 3, but if you want to sort by Last Name, and it isn't in a specific
location, you'll need to do some more work.

2. Lines ending in paragraph breaks, address block ending in two paragraph
breaks ("blank line" between blocks). Replace ^p with ^l, then ^l^l with ^p,
which will give you the setup in (1) above.