AnsweredAssumed Answered

Extrecting only specific words that follow a single occurance string

Question asked by jlhfbo on Mar 4, 2017
Latest reply on Mar 4, 2017 by philmodjunk

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

Outcomes