AnsweredAssumed Answered

have zipcodes imported with no hyphen

Question asked by echolakemt on Sep 16, 2015
Latest reply on Sep 16, 2015 by rgordon

I am importing zip code data daily into Filemaker 14 that does not have a hyphen included.  I want to add a hyphen to the data and still allow the import to happen.  How do I do this?  It appears that the calculation I currently have  Replace (Replace(Filter (Self;12314567890);6;0;"-" );10;0;"") is preventing the import for this particular field.  Any ideas.  I am brand new to Filemaker and every learning as I go through this project.

Outcomes