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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
ashishpalkar
Creator III
Creator III

Exctract only Characters from string

Hi Experts

I have following Req, need to take only characters from the given string.

Find below examples

3.3. Funds Without Activity -
3.3. Funds Without Activity
1.1. Active Remediation
3.3. Funds Without Activity
7. Other Reference Data
8. Other Reference Data
8.21. Deactivated / Merged
8.11. Deactivated / Merged

Should convert like below,

 

Funds Without Activity
Funds Without Activity
Active Remediation
Funds Without Activity
Other Reference Data
Other Reference Data
Deactivated / Merged
Deactivated / Merged

Thanks in advance, 

2 Replies
sunny_talwar

Have you tried this:

SubField(FieldName, '. ', -1) as NewFieldname

Nicole-Smith

KeepChar(YourField, 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz /')

or

PurgeChar(YourField, '1234567890.-')