Hi, we've got a rather large inventory database (30,000+ records) and we're
having quite the problem with carriage returns in one of the fields.



I've been googling this quite a bit trying to come up with how best to do
the following different tasks:



1. Quickly do a search in Find mode in a limited set to find records in a
certain field that currently have a carriage return. I currently want to do
this just to see how many records I am dealing with that have this problem.
I have tried Pilcrow character, chr(13), slash r, etc, and I don't seem to
be able to find the wording or text needed to find returns in a field.
Everything I have tried is no results.



2. Be able to quickly zap records that have the CR. So far I am reading
that an auto-enter with Substitute ( YourEmailField ; "¶" ; "" ) would work
well. I currently have some text formatting on this field so I have to be
careful.



TextStyleRemove (TextColor ( TextSize ( TextFont ( SerialNumber; "Courier
New" ); "12"); RGB ( 0;0;51) ); Bold)



This is to present serial numbers in a consistent way instead of the
typical garbage that gets pasted in.



3. Prevent carriage returns from being entered in the field ever again. One
trick I found was to add Return as a Go to next object, but we do searching
on this field heavily so I need the carriage return to work in Find mode.



Thanks for any advice!



James


P.S. I also posted this to the FM forums
#############################################################
This message is sent to you because you are subscribed to
the mailing list FMPro
FMPro@lists.lassosoft.com
To unsubscribe, E-mail to: <FMPro-unsubscribe@lists.lassosoft.com>
Send administrative queries to <FMPro-request@lists.lassosoft.com>