[FP5] Correcting information in fields

[Robert Collins]

I'm stuck again

I am trying to get Filemaker to correct a couple of fields once information has been entered in them

for example, I use a barcode reader to scan in serial numbers and telephone numbers of mobile phones. The manufacturers print the telephone number barcodes without a "-" between the code and the rest of the number . I want Filemaker to correct it to look like this 07973-123123 .

I also need it to add "-" sybols after every 3 digits of a nine digit number

for example : 123456789 needs to be corrected to 123-456-789

I don't want the corrected result in an other field , I need it to correct the wrong field. (I hope that makes sense)

Thanks in advance

FileMaker Version: 5

Platform: Mac OS 9

[MarkWilson]

Robert,

Here is a sample file for formatting an unformatted field.

The Look-up method is originally from CobaltSky's article on "Automatically indexing non-indexable fields in FileMaker Pro

Phone.zip

[Robert Collins]

Thank you very much for this

[Robert Collins]

Is there an extra line I can add so that if the telephone number is entered correctly in the first place (ie. 07956-123123) then it will not try to reformat the field , for example add the - symbol or shift the digits along.

thanks

[Ender]

Like this?

if(PatternCount( Text, "-") > 0, Text, <Format Calc>)

[Robert Collins]

Thanks , I will try that.