Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
satishkurra
Specialist II
Specialist II

Extract the required string using string functions

Hi

Can someone help me in getting the desired string from below text in bold

Input Example: Q68. Behavioral Health Screening:

I need the output as

Behavioral Health Screening

Thanks

Satish

1 Solution

Accepted Solutions
petter
Partner - Champion III
Partner - Champion III

You can use these functions like this:

Trim( TextBetween( Txt , '.' , ':' ) )

View solution in original post

3 Replies
petter
Partner - Champion III
Partner - Champion III

You can use these functions like this:

Trim( TextBetween( Txt , '.' , ':' ) )

satishkurra
Specialist II
Specialist II
Author

Thanks . It worked...

Not applicable

You can use TextBetween or MID functions