Alphabetize a list

[ChasCH]

Hi

Can someone clue me in as to alphabetizing a list in FM ina single field. The list is seperated by returns and may contain multiple words per line.

This would be the contents of an example field:

Fred

Abby & Joe

2Happy ToCare

Ancient Aztec Ruins are amazing

Lettuce Pray

Thanks in advance!

Chas

[ChasCH]

I thought I could strip out every "line" and put it in a different field.... but I would definitely like to avoid something like this, as it would require about 80 new custom fields for each record ....

first text field name - "fred"

second text field name - "Abby & Joe" - would bonk anyway because of the &

[Lee Smith]

DO NOT DOUBLE POST!

I have responded to your Post in the "Value List" Topic area, this was after I moved it from the General Question Area.

So, go with that one and Delete this one.

If you want to know more about what a double post is, and why it is frowned upon to do it, just do a search for my name and Double + Post and you will see what it is all about.

Lee

[ChasCH]

THanks Lee,

I was afraid I was in the wrong section before. No more Double posts!!

All the Best

Chas