is there a more clever way

[GEORGETOUBALIS]

hello!

I have import from a text file A name list

Jaspar, Bobby, & Henri Renaud

Houston, Whitney, & George Michael

Basie, Count, and His Orchestra

Rietman, Jan, Band

Commodores, The

Harrison, George, And Friends

Primal Scream

Culture Beat

Ram Jam

Getz, Stan, & His Quartet

Burton, Gary, Quartet, The

as you can see I have move words so

Burton, Gary, Quartet, The

be

Gary Burton The Quartet

I have import the list in Excel using comma sep text and then I import the names in a fm file

then I use not a very clever way to change the order of words...

See the file....

is there a more clever way to do that?

External_convert_names.fp7.zip

[Lee Smith]

This seems very similar to your other post Here

Please do not double post.

Lee