Re: Getting rid of Enter symbols in a field, Problems with a Calculation

use the substitute script step:

Find all
goto record (first)
loop
substitute(comments,"SquareThing","¶")
goto next record (Exit after last record)
end loop

-- 
SeeU Ursus


"Andrew Mason" <[EMAIL PROTECTED]> schreef in bericht
news:[EMAIL PROTECTED]
> Hello,
>
> I just updated my filemaker version from 2.5 to 6, and am dealing with
> a few artifacts.  The "Comments" Field, which usually has quite a bit
> of text, is full of those little squares that represent enter symbols
> in excel and other programs.  I'm trying to take them all out and
> replace them with actual line breaks.  What I tried to do was create a
> calculation field that searches for them and replaces them, and then
> when its done I'll import the data in this calculation field into an
> actual text field.
> The formula I wrote only seems to get rid of the first symbol, not the
> rest.  Anyone have any ideas?  Here is what I wrote:
>
> If(PatternCount(Comments, "squarething")>0, Replace(Comments,
> Position(Comments, "squarething", 1, 1), 1, "¶"), "")
>
> only i used the actual square symbol.  It doesn't seem to paste in
> here.
>
> Thanks very much for your help!
> Andrew