Solved: Re: PowerQuery - Text before multiple Delimiters

ngct1112 · ‎07-13-2021

Hi,

May I know is there any way I could split text before multiple Delimiters in one function?

Great thanks!

mahoneypat · ‎07-13-2021

Add a step to extract the text before one of those delimiters, and then modify the code in the formula bar to look like this

= Table.TransformColumns(Source, {{"Column1", each Text.Start(_, Text.PositionOfAny(_, {"&", "/", "-"})), type text}})

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

ngct1112 · ‎07-13-2021

@mahoneypat it works in my query. Very brilliant. Thanks for your help!

mahoneypat · ‎07-13-2021

Add a step to extract the text before one of those delimiters, and then modify the code in the formula bar to look like this

= Table.TransformColumns(Source, {{"Column1", each Text.Start(_, Text.PositionOfAny(_, {"&", "/", "-"})), type text}})

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

doubleclick · ‎04-05-2022

how can this be done with a multiple character string?

PowerQuery - Text before multiple Delimiters