3 Replies Latest reply on May 8, 2012 12:25 PM by philmodjunk

    extract specific data from a field



      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.