Breaking a list into 2 columns

[Ender]

Hi All,

I need a little help figuring out a way to take return-separated list of vocabulary words or phrases, and split it into 2 balanced columns for my printout (to save space).

Here's an example list:

goggles

aquarium

turtles

coral

migratory

shark

seal

pond

ocean

salt water

starfish

fish

diver

beach

crab

seahorses

blowfish

mammal

They do not need to retain their listed order.

I'm thinking one calc might do it, if there's an easy way to get every other line tabbed over on the previous line.

In FM7, I would probably use a custom function to do this, but since this is in FM6, I'm not sure how to parse it.

[comment]

I don't see a way to do this with a single calc field. This needs recursion. You could use a repeating field, but then you'd need an index and a global index, so that's even worse.

Really easy with 2 fields, though - esp. if version 6 has LeftValues() and RightValues().

[BobWeaver]

If they are all in one field and you don't care what order they appear in, then why not make two calculated fields to split them in half:

ColumnOne = Left(WordList,Position(WordList,"

[Ender]

Two calcs it is then.

Thanks for the help.

[dwins]

If the one calc field substitutes tabs for the returns, and you size the tabs and field accordingly, it's a perfect two columns.

[Lee Smith]

You can also use a boarder-less Value List, and attach it to your field

HTH

Lee