topic Re: Exctract only Characters from string in QlikView

Exctract only Characters from string

ashishpalkar — Wed, 25 Nov 2020 16:16:04 GMT

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

Active Remediation

Funds Without Activity

Other Reference Data

Deactivated / Merged

Thanks in advance,

sunny_talwar — Mon, 14 Mar 2016 19:48:12 GMT

Have you tried this:

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

Nicole-Smith — Mon, 14 Mar 2016 19:50:38 GMT

KeepChar(YourField, 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz /')

PurgeChar(YourField, '1234567890.-')