Help Creating a Numeric Filter via Calculation field or Script in FM6 -
04-13-2007
, 01:51 PM
I am having a problem with a FM 6 DB. I have a field for phone and
right now they contain a variety of different formats (with spaces,
with dashes only, with parenthesis ....) Anyway, I need to update
this field (either by script or a calculation field) to contain only
the digits. I know in FM 8 you can use the function filter to only
return the numeric values and not the special characters:
FILTER ( Telephone ; "0123456789" )
Is this possible in FM 6? |