Divided character after each occurrence of specific word

[sailorman]

I want to split every hyper text of image after .jpg. I tried the character division number, it doesn't work.

Please help me.

[v-diye-msft · Accepted solution]

Hi @sailorman 

I found here's the same question you posted yesterday which has been resolved. details refer to:

https://community.powerbi.com/t5/Desktop/Character-split-after-each-occurrence-of-specific-word/m-p/... 

I'll close this thread and merge them into one.

[amitchandak]

@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/