dbTalk Databases Forums  

Help Creating a Numeric Filter via Calculation field or Script in FM6

comp.databases.filemaker comp.databases.filemaker


Discuss Help Creating a Numeric Filter via Calculation field or Script in FM6 in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
amcbdc1
 
Posts: n/a

Default 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?


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.