I have a database with 40,000 records that a field that can only have a max char count of 100 chars.  Not a problem, except this is a new spec, and most records exceed that value.

The data was entered in a multi line box that accepted RTN codes The box has been reshaped to be a sinlge line of 100 chars, vs. the multiline format that had unlimited lines.  This part of the effort to eliminate using the RTN code.  No line wrapping.

The new layout shows the ^J character for the old line feeds, and seems to be a changing value of spaces.  If I manually delete the ^J my char count comes down dramatically, so the length frequently fits, means less editing.

So now I need to do a Search/Replace.

But I now have two problems:
1. I cannot retrieve records that have a ^J
I have tried CTL-J, ^J, @LF, @CHR(10) with and without { } braces

2. I cannot find a value to use in the @Replace formula, @Replace(Field,^J," ") and @Replace(Field,"^J"," ") with above variations.

I have tried the same values from above in the Search part of the @Replace function. 

I tried copying the ^J char from the box and pasting that into my Retrieve and Replace attempts.

I am sure this will be an easy fix, but am stymied so far.

Thanks actiontech, but I tried to do a  Mass Update on a single record, and @Replace (FieldName,@CHR(10)," ") does not work.  Don't see how @Replace (FieldName,@CHR(10),@CHR(8)) will work.

Or maybe I am misunderstanding? 
Are you saying to add a new temp multiline field.
Then make that new multiline field the existing text field value with the ^J.
And then try the @Replace, and send it back to the text field.

Like this:

NewMultiLineField = TextField

TextField = @Replace(NewMultiLineField,@CHR(10),@CHR(08))
OR
NewMultiLineField = @Replace(NewMultilineField,@CHR(10),@CHR(08))
TextField = @FormFieldValue("FormName","NewMultilineField",0)
 

Then remove the temp new multiline field?

Thanks Ray.

I figured out the same retrieve spec over the weekend and it works fine.  (I seem to be getting some extra records without the character.   Don't understand why, but is not a problem for what I am doing).

The Replace is working.  Great.   It looks identical to what did not work for me, so I must have made a synyax typo.   Who knows, who cares?

PROBLEM SOLVED.

Thanks again.