Wondering how to write the match clause so it finds the first non-numeric value. This algorithm is finding the first a-z character, but if the first non-numeric character is a special character, it doesn't work.
for li_x = 1 to li_length
ls_char = Mid( as_nominal, li_x, 1)
lb_match = Match(ls_char, "[A-Za-z]")
if lb_match then
cbx_units.checked = true
ddlb_units.text = Trim(Mid(as_nominal, li_x))
sle_nominal.text = Trim(Left(as_nominal, li_x - 1))
li_x = li_length + 1
exit
end if
NEXT
For example, the string passed in is "1,000 °C". The algorithm is finding the C, but not the °. I tried lb_match = Match(ls_char, "[^0-9]") but that sees the comma as a non-digit.
TIA,
~~~Tracy
