trying to setup a form for ordering supplies. Depending on who is ordering they may type an item number as "123-45" or "12345". I want Filemaker to recognize either of these as "12345". In other words to disregard the hyphen or (if possible) any characters other than numbers or letters

Checked google and other forums but I'm not sure I know the right keywords to search for.


Any help would be awesome.

6/7/2007 2:00:37 PM

last company i worked for used filemaker for everything. shittastic peice of software.

6/7/2007 2:08:28 PM

it's good for the small,quick, and dirty. like if I need to build a database for your dick.

6/7/2007 4:30:48 PM

Use the regular expression plugin and run it through this -

s/(\d[3])\-?(\d[2])/$1$2/g

[Edited on June 7, 2007 at 6:29 PM. Reason : best I can give you just by doing ~30 seconds of googling]

6/7/2007 6:29:05 PM