Replace part of string with another value in Domo Cards
I have a data set showing some page names and paths of my website, a part of which has to replace with another in the domo card.
Can it be done using beast mode, using any functionality similar to 'Replace' in mysql.
Original Value: 'Site1::LandingPage > Site1::My Cart > Site2:Checkout Initiate:Checkout'
Required value: 'Landing Page > My Cart > Checkout'
Thus, 'Site1::LandingPage has to be replaced with 'Landing Page' , 'Site1::My Cart' is to be replaced with 'My Cart' and so on.
Any insights would be helpful.