Exctract only Characters from string

[ashishpalkar]

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, 

[sunny_talwar]

Have you tried this:

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

[Nicole-Smith]

KeepChar(YourField, 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz /')

or

PurgeChar(YourField, '1234567890.-')