topic Exclude alpha numeric strings in App Development

Exclude alpha numeric strings

leobrand — Sat, 27 Oct 2018 04:47:41 GMT

I have a table dimension that contains text and alpha-numeric strings. I want to create an expression that excludes the alpha-numeric strings The syntax below excludes one alpha-numeric string but is obviously not enough to exclude them all. Can you help?

=If([Product Names]<>'XE94',[Product Names])

Re: Exclude alpha numeric strings

PrashantSangle — Sat, 27 Oct 2018 05:27:08 GMT

USe findoneof()

try like

if(not findoneof(fieldName,'0123456789'),fieldName)

Regards,

Prashant Sangle