Replace field content if it contains cariage return

[bens]

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?

[Søren Dyhr]

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

[bens]

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

[David Jondreau]

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

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

Edited January 20, 2010 by Guest