filtering numbers out of a filed

[Anonymous]

Dear all,

I have a field that contains numbers and one letter only. There is no rule where the letter is positioned inside the string, it could be:

E00115

025W06

008S

and so on.

I'm looking for a way to filter out all numbers from the string and have a new field that contains only the letter.

Any idea?

Thanks for your help!

[sunny_talwar]

May be using the KeepChar() function:

Text(KeepChar(FieldName, '1234567890')) as FieldName_Number

[sunny_talwar · Accepted solution]

Alternatively, you can also use PurgeChar()

Text(PurgeChar(Upper(FieldName), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ')) as FieldName_Number

[alexpanjhc]

PurgeChar(FieldName, '0123456789')

[Anonymous]

Dear Sunny and Alex,

I try a combination of both options and it works, basically what I did was

Text(KeepChar(FieldName, 'NSWE'))

Which are the letters I want to keep.

Thank you!!!