extract specific data from a field
I have a field (called Description) with the following format...
"The Catcher in the Rye ($10.00)"
I need to create two fields: one that extract the title and the other that extracts the price.
Title: The cather in the rye
I started with something like:
cTitle = If(PatternCount(Title;"($");Left(Title;Length(Title)-Position(Title;"($"; .... got stuck here.
ANy help is appreciated.