Forum Discussion

Andybr's avatar
Andybr
Frequent Visitor
6 years ago

Address find number

Hi,   I have an 'address 1' column with values as follows:   1 Main Street 100 Main Road Avenue Boulevard   I want to be able to flag the addresses which don't start with a number, so 'Avenu...
Need Help
Show and Tell
Tips and Tricks
az38's avatar
az38
Community Champion
6 years ago

Hi Andybr 

create a column

Column = IF(ISERROR(VALUE(LEFT([Address 1],1))), TRUE(), FALSE())

and filter by Column = True

  • Andybr's avatar
    Andybr
    Frequent Visitor
    6 years ago

    Appreciated - thanks az38