I have a column
with thousands of addresses, most of them have a number but lot of addresses have no number, the addresses are like this:
- streetname 4
- streetname 8
- streetname 4/5
how do i detect the fiels like 'streetname' having no number.
I have tryed with:
or isANumber() but none gives the right result