Removing text after a specific set of characters

[steostro]

Hi,

I am looking to remove text after "_IN". What formula would be the best to do this?

Example:

Current text: WHP_B_AEL_TUBEMO_DSK_VID_PTUB_BHV_dCPM_30s_BKIN_IN_DADAND_EQU_EQU

Desired text: WHP_B_AEL_TUBEMO_DSK_VID_PTUB_BHV_dCPM_30s_BKIN_IN

The text after "_IN" varies so the formula would need to focus on removing anything after "_IN" as opposed to beginning with "DAD"

Thank you!

[MSalvage]

@steostro,

If you add a Regex tool set to Parse with the expression:

(.*\_IN).*

It should get you what you want.

Also, I have attached an example.

Best,

MSalvage

[estherb47]

Another method is to use a formula tool, and Regex_Replace. Here, [Field1] is the field that needs cleaning. This will separate the text into that which ends with the "_IN" and the rest of the text, and give you the first piece only.

REGEX_Replace([Field1], "(.*?_IN)(.*)", "$1")


Best, Esther

[danrh]

You can also use a Formula tool with Left([Text], FindString([Text], '_IN')+3).

[Surendar16]

How to remove text in Column headers after some specific characters like (-,_,).....

I have header like this below

Current - CBDS - FASTEST ROW

Expected like - CBDS