Splitting Number fields

[AndreasGistav]

Dear FileMaker friends.

I have a number field, that contains 13 digits.

Now I should splitt those 13 digits in 13 new number fields.

In other words, the first new number field should show the first digit of the original number field. The second new number field should contain the second digit of the original number field. The third new number should contain the third digit of the original number field, and so on.

Is this possible?

Please help.

Many regards from South Africa

[danjacoby]

Use the "Middle" command.

Actually, use the "Left" and "Right" commands for the first and last digits, respectively, and the "Middle" command for all the other digits.