AnsweredAssumed Answered

Extracting the word "INT" or "EXT" from a field

Question asked by bridge101 on Jul 4, 2018
Latest reply on Jul 4, 2018 by fmpdude

Hi,

 

I have imported an excel file and I am wanting to extract / parse out two specific words from the field into another field. The "Int" or "Ext" do not appear in all the fields (which is fine). But when they do appear, I would like to move these words over to isolate them. Since the word is not always in the front of the string, I can't use my usual go to function of right (text: number of characters). Would the case function be the best way to extract these specific words from a spring of text in a field?

 

Thank you in advance for any help.

Outcomes