Thank you Tim, that little add to the auto field calc will stop people
from doing the same thing in the future.
Lee
Tim Mansour wrote:
On 28/09/2008, at 10:26 am, Lee wrote:
I think I've seen this come up before. I have many fields where the
person who entered data has consistently hit the 'enter' key causing
a carriage return in those fields. How can I do a script to remove
those carriage returns.
Use the Substitute command:
Substitute ( fieldname; "ΒΆ", "" )
For existing records you'll have to perform this calc on each field,
using a Replace Field Contents on all (affected) records. To avoid the
issue in future records, add the calc to each field's auto-enter
calculation, remembering to switch off the "Do not replace existing
value" option.
--
