Copy from a field with are comma delimiters numbers
We have a field that will be populated by users “Copy and pasting” bunch of numbers that are comma delimiters.
What we trying to do is to copy each number into a targeted “field2” field and issu new record and copy the next numbers into the field 2 again. Here are the steps:
1.Enter find mode
2. users manually paste bunch of comma delimiters numbers such as: 213, 2133, 2144, 2177, 2199, 2100 into” field1”
3. Then paste 213 into filed2.
4. New Record/Request
5. Then paste 2133 into filed2.
6. New Record/Request
7. Then paste 2144 into filed2.
Repeat the same step over over until no more number left in the” field1”
8. Once there is no more number left in field1 then
9. Perform find.
Is this possible with FileMaker scripts
Thanks in advance,