Are there similar functions to Find, Left, Mid, Right for a whole text column?

[JamesShawPBI]

Hi Guys,

Photo01 data:
https://au.finance.yahoo.com/cryptocurrencies?count=100&offset=0

Photo02 data:
https://au.finance.yahoo.com/cryptocurrencies?count=100&offset=100

The problem I have is that the rows within "Symbol" field of Photo01 are: "Select BTC-AUDBTC-AUD" or "Select MATIC-AUDMATIC-AUD", however I need to convert them to"BTC-AUD" and "MATIC-AUD", similar to what is automatically done in Photo02. Any ideas?

If this was in excel I should use something like =Mid(string,Find(string,"AUD")+2,10)
Are there similar functions to "Find" "Left" Mid" "Right" for a whole column's text in Power Editor?


Photo01:

Photo02:

[komald]

@JamesShawPBI , you can get it column from examples.

select symbol column add go to add column and select column from examples