AnsweredAssumed Answered

extract specific data from a field

Question asked by truji_ on May 8, 2012
Latest reply on May 8, 2012 by philmodjunk


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. 

For instance:

Title: The cather in the rye

Price: 10.00

I started with something like:

cTitle = If(PatternCount(Title;"($");Left(Title;Length(Title)-Position(Title;"($"; .... got stuck here.

ANy help is appreciated.