10 Replies Latest reply on Mar 4, 2017 3:47 PM by philmodjunk

    Extrecting only specific words that follow a single occurance string


      I have a text field with hundreds of words. Imbedded is a unique string (Inc#) followed by a number, varying in length (i.e. 17-12, 17-123, 17-1234, 17-122345, 17-123456) but never more that six numbers. I need to put only the [Inc#] and the [following number] in a calculation field.


      I have tried everything; have come close but no cigar. Please HELP!


      -Jim H