I am working on links and need to automate a process so here's the problem:
Link for example
http://www.random.123/vid/xxrx08_tit...keeps-changing
Required result:
<iframe frameborder="0" width="480" height="389"src="http://www.random.123/embed/vid/xxrx08?n=92"></iframe>
Constants are as follows:
http://www.random.123
n=92 remains same across the board
'_' will always be present
'_' is replaced by '?'
Values after '_' should be copied and sent to another cell simultaneously where the '-' is removed regardless of the number of words there, preferred result will look like 'title portion keeps changing'
So basically will need a way to generate two different results from one link.
note 'xxrx08' this value could be worth more or less alphanumeric characters and would be always changing
Bookmarks