Hi Rick
I add the following formula as an auto enter calculation to remove formatting, leading and trailing spaces, and all carriage returns.
TextFormatRemove ( Trim ( Substitute ( Self ; "¶" ; "" )))
Stan
||||||||||||||||||||||||||||||||||||||||||
Stanley S. Weber, Pharm.D., FASHP, BCPP
Associate Dean for Professional Pharmacy Education
University of Washington
PO Box 354699
Seattle, Washington 98105
[log in to unmask]
(206) 616-8762 (voice)
(206) 221-2689 (fax)
On Feb 4, 2011, at 8:25 AM, Rick O'Quinn wrote:
> I've got a few fields that I need to keep to one line, but not one word. Most are First Name, Last Name fields. I want to make sure users can't enter a carriage return OR any other random characters, such as another name. BUT entering 2 or more words (names) on one line is okay.... examples
>
> I want to prevent this:
> John¶ (carriage return)
> Jimmy
>
> And this:
> John¶ (carriage return)
>
> But I want to allow this:
> Mary Alice
>
> After digging around in the text functions for awhile, I didn't find an "out of the box" solution, so I searched Brian Dunnings Custom Functions list but couldn't find what I was looking for. I'm sure it's there and I just didn't hit the right search parameters.
>
> Anyway, so I came up with my own custom function that is working.... since I'm not too good at righting those, so I was thrilled it worked. It might be a bit over blown with checking for 10 carriage returns, but I figured somebody's keyboard might get stuck. I threw in the trim after I got everything working to also get rid of leading/trailing spaces. The function below works, but I was wondering, is there an easier way to figure the number of words someone might throw in there? Like a >1 function? I tried that: ["¶"&RightWords ( TrimField ; >1 ) ; ""] but obviously the syntax isn't right.
>
> Is there an easier way?
>
>
> Trim (
>
> Substitute ( TrimField ;
>
>
> ["¶"&RightWords ( TrimField ; 10 );""];
>
> ["¶"&RightWords ( TrimField ; 9 );""];
>
> ["¶"&RightWords ( TrimField ; 8 );""];
>
> ["¶"&RightWords ( TrimField ; 7 );""];
>
>
> ["¶"&RightWords ( TrimField ; 6 );""];
>
> ["¶"&RightWords ( TrimField ; 5 );""];
>
> ["¶"&RightWords ( TrimField ; 4 );""];
>
> ["¶"&RightWords ( TrimField ; 3 );""];
>
> ["¶"&RightWords ( TrimField ; 2 );""];
>
> ["¶"&RightWords ( TrimField ; 1 ) ; ""];
>
> ["¶" ; ""] ))
>
>
>
> Thanks,
>
> Rick
> ___________________
> Rick O’Quinn
> Photographic Services Coordinator
> University of Georgia
> Public Affairs
> Broadcast, Video & Photographic Services
> 188 Georgia Center
> Athens GA 30602-3603
> Work: (706) 542-8085
> Fax: (706) 583-0011
> [log in to unmask]
> http://www.photo.alumni.uga.edu
|
