Character split after each occurrence of specific word

[sailorman]

I want to split each image hyper text after .jpg. I tried number of character split, it does not work.

Please help.

[amitchandak · Accepted solution]

@sailorman ,

You can use

https://docs.microsoft.com/en-us/powerquery-m/text-split

Or https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/