Remove from a parenthesis

[GEORGETOUBALIS]

HELLO

I have a list of songs It looks like .....

Masquerade Is Over (Magidson/Wrubel)

Make It With You (Gates)

Echo My Heart (Kurasch/Weiss/Wood)

Stay Right Here (Bailey/Booker)

How Can I remove the composers from the line and the list look like

Masquerade Is Over

Make It With You

Echo My Heart

Stay Right Here

Every song is a defferent record.

Can anyone help me?

George

Athens

Greece

[Mike D.]

George,

You can use the Replace Field Contents to do this. Click in the field containing the song title and composer and select from the menu bar Records --> Replace Field Contents. Use this calculation to remove the composers - Left(song title; Position(song title; "("; 1; 1)-1). This calculation looks for the opening "(" and then keeps only the text to the left of that bracket.

Just be aware that the composer info will be deleted and you can't get it back. If you want to split the info between two fields, then that is a different situation.

HTH, Mike

[Søren Dyhr]

Since you're with fm7 would I solve it via a recursive script... and a tiny CF!

--sd

doit.zip

[GEORGETOUBALIS]

IT WORKS FINE THANX VERY MUCH!!!!