cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nagoor Regular Visitor
Regular Visitor

Delimiter the text after the specific word in random place

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV
Super User IV

Re: Delimiter the text after the specific word in random place

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

 

Email Pic.png

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.

Email Pic.png

Which finally results in the following column.

 

Email Pic.png

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.

 

Email Pic.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

View solution in original post

3 REPLIES 3
Super User IV
Super User IV

Re: Delimiter the text after the specific word in random place

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

 

Email Pic.png

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.

Email Pic.png

Which finally results in the following column.

 

Email Pic.png

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.

 

Email Pic.png





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

View solution in original post

nagoor Regular Visitor
Regular Visitor

Re: Delimiter the text after the specific word in random place

Thanks @GilbertQ it's Solved 

Super User IV
Super User IV

Re: Delimiter the text after the specific word in random place

Awesome!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Power BI Blog

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors