need calculated multi-line key field

[nikarc]

How would I do the following (if possible):

I have a text field foo with a string of numbers that are implicitly grouped in chunks of 12 characters. I would like to construct a multi-line key field from this data.

For example:

---

123456789012123456789012...

---

becomes

---

123456789012

123456789012

...

---

Can I do this with a calc field? If so, how? I'm stumped..

[Lee Smith]

I am not sure I fully understand what you are wanting, but here is a calculation that may help get you started.

Left(Foo, 12) & "

[nikarc]

Thanks for the reply.

My text field can contain an arbitrary amount of grouped "chunks" - only the amount of characters per chunk is fixed (at 12). I'm not sure I can use a calc field unless I pick a sufficiently large max chunks number and have an insanely long calc field definition..

[Lee Smith]

Define as many "Chunks" of size 12s that you need, just keep adding to the end of the calculation like this.

Left(Foo, 12) & "

[Vaughan]

A looping script could process the field completely.

Be aware that FMP has a 64k limit on text fields.

[nikarc]

I believe that a script will work better.

I'm working on records of text data that should never (individually) be bigger than 64k, and I'm only working with a subset of that record's data.

[Lee Smith]

Okay, use a script