number formatting - 8 digits to 4

[maimew]

I am importing a field containing an eight digit number (with four preceeding zeros) from a pc database (using excel spreadsheets) and need to knock off the zeros once in filemaker. Is there a script I can use to get rid of the four preceeding zeros? My experience with scripts is limited - have never written one myself, only selected from a list. Please help. Thanks.

[LaRetta]

Hi Maimew,

The field should be numeric, then just apply this script:

Go to Record/Request/Page

[ First ]

Loop

Set Field [ YourNumberField, YourNumberField]

Go to Record/Request/Page

[ Next, Exit after last ]

End Loop

If you set a numeric field to itself, it will strip the leading zeros for you! If this is just a one-time thing, you can also use Records > Replace Contents.

LaRetta

[Lee Smith]

Or,

put your cursor in the number field, go to the Menu - Records - Replace and click on the box thas says Specify. In the calculation Dialog box, select your number field and then Okay, and then the Button Replace.

You can also do this with a script as pointed out by LaRetta

Lee