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.
--
Tim Mansour <[EMAIL PROTECTED]>
Neologica Print & Promotions (ABN 63 904 335 408)
159 Commonwealth Street Surry Hills NSW 2010
Sydney 02 9212 1789 Melbourne 03 9012 7441 Mobile 0405 500 846
