Delimiter the text after the specific word in random place

[nagoor]

Hello, Techie...

I want to delimiter the text after the specific word and add a new column to it. 

Example, 

From the below 2 examples I want to delimiter the text after "ThresholdName=" and add a new column with that. I don't know the exact place where the "ThresholdName=" will come so I can't give the range. 

Apple | ObjectName="Dural/Function Name=23_Dural2_AB, Local ID=2, Sin Name=23_Dural2_AB_JH_2, Function ID=245, Sin FDD TDD =SIN_FDD", ThresholdName=Drop Me | 202006

Apple | ObjectName="B2/Label=21_Dampier_EW_UYH_3, ID=23", ThresholdName=Pick Me | B2 | 

Give me the best solution to fix this problem.

[GilbertQ · Accepted solution]

Hi @nagoor

What I would do in the Query Editor is to Duplicate your Source column.

Then Split the Column by delimeter and then select Custom as shown below

Which would then result in almost the data you need, but with the '| 202006" at the end

After which you split it again, this time by the other delimeter as shown below.

Which finally results in the following column.

And another alternative is to try the Columns from Examples, which could also possibly give you the result that you want, but always double check this as sometimes it can guess what you want incorrectly.

[nagoor]

Thanks @GilbertQ it's Solved 

[GilbertQ]

Awesome!