Limit data in field import

[gnfb]

Ok please bare with me I know a little so Im dangerous as they say

I have the following data:-

CHRISTINE *Best Price DVD*

Das Boot *Best Price DVD*

FINDING FORRESTER *Best Price DVD*

as individual records

I want to automatically remove the *Best Price DVD* from each record. The title of the DVD changes

Thanks for your help

[IdealData]

Trim(Substitute(DVD_Title, "*Best Price DVD*", ""))

I presume you would want to put this in a script, which would need

SetField[DVD_Title, Trim(Substitute(DVD_Title, "*Best Price DVD*", ""))]

[gnfb]

ok excellent I have to go to work now but will try that when i get home

Thanks