11-30-2009, 09:51 PM
table1.vals
$100.43
20
20,123
4,128.43
I want to return everything that's either digits or dots. That is, ([0-9]|\.)
It seems that the built-in REGEX function only returns whether a pattern is matched; it doesn't do extraction.
Can this be done?
Thanks!
Greg
$100.43
20
20,123
4,128.43
I want to return everything that's either digits or dots. That is, ([0-9]|\.)
It seems that the built-in REGEX function only returns whether a pattern is matched; it doesn't do extraction.
Can this be done?
Thanks!
Greg