Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Alternatively, you can also use PurgeChar()
Text(PurgeChar(Upper(FieldName), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ')) as FieldName_Number
May be using the KeepChar() function:
Text(KeepChar(FieldName, '1234567890')) as FieldName_Number
Alternatively, you can also use PurgeChar()
Text(PurgeChar(Upper(FieldName), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ')) as FieldName_Number
PurgeChar(FieldName, '0123456789')
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!!!