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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.-')