Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have few strings like
"sulko uspedo (00:20)+podendo (01:05)+Uskudento (05:01)"
"podendo (07:25)+sulko uspedo droggen(05:50)+Uskudento (05:01)"
"podendo (04:85)+Uskudento (03:21)+sulko uspedo (02:15)"
I need to extract time after key word sulko*
Result of above 3 sample should be 00:20, 05:50, 02:15 respectively; any idea on extracting time after a specific keyword would be highly appreciated. Thank you!
Try:
textbetween(mid(index(FiledName,'sulko')),'(',')') as TimeString