Getting Values from Paragraph separations

[simoncpage]

If I have a field which is

1

2

3

4

(Paragraph separated)

How can I use scripting to get a value from the list? say 1, 2, 3, 4

Any help would be great!?

[Lee Smith]

Use the Substitute Function in a Calculation, a script step or Replace in the Main menu Go to Menu > Records > Replace

Substitute(YourField, "

[Tom Donaldson]

If by "Paragraph separated" you mean that the list is delimited by the ASCII character whose value is decimal 13, you can use the function MiddleValues(text, valueNumber, numberOfValues).

The example in the "Help" for the function is reasonably clear.

--tomd

FileMakerSignature.txt