Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
brijesh1991
Partner - Specialist
Partner - Specialist

Extract a part from String

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!

 

Labels (3)
1 Reply
m_woolf
Master II
Master II

Try:

textbetween(mid(index(FiledName,'sulko')),'(',')') as TimeString