kylerjphillips

Mobile Number Calculation

Discussion created by kylerjphillips on Feb 9, 2016
Latest reply on Feb 10, 2016 by kylerjphillips

What's the best way to trim the first '0' of a Mobile Number in FileMaker - currently we have a database with Mobile Phone records in and would like to match the billing records from our service provider to these records however the phone number format differs and we want to relate these.

 

FileMaker Phone Records:

 

07352586201

 

Billing Phone Records

 

 

7352586201

Outcomes