I need a script to find and replace data in a field if it contains one ore more cariage returns. The field also contains different kind of text.

How can this be done?

Why script, why not autoenter with an updating calc ...

http://fmhelp.filemaker.com/fmphelp_10/en/html/func_ref3.33.84.html

...comes to mind as well as this:

http://www.databasepros.com/FMPro?-DB=resources.fp5&-lay=cgi&-format=list.html&-FIND=+&resource_id=DBPros000799

--sd

I have to replace all the the text in the field.

Sometimes the data will look like this:

Text1(return)

Text2(return)

Text3

or this:

Text1(return)

Text2

or this:

Text1

And there can be even more returns in the field.

Only when there is one or more returns, the whole text in the field must to be replaced by "newtext".

bens

You need the Replace[] script step on that field with the calculation

If(PatternCount(Field; ¶); newtext; Field)

Edited January 20, 201016 yr by Guest