This might work for you, Rick...

Left ( Self ; Position ( Self ; "¶" ; 1 ; 1 ) -1 )

This would chop off all that was entered from the first carriage return to the end of the text.

j


On Feb 7, 2011, at 8:36 AM, Rick O'Quinn wrote:

> Thanks to everyone who responded regarding my request for additional help on keeping a field limited to 1 line. First, I definitely prefer an auto enter calc solution over a dialog box. Although the majority of my users are pretty savvy and familiar with our system, I have a few that use it maybe once every week or 2, and no matter how much training and help I provide, they either can't or won't remember a thing. And my experiences with dialogs in general are, nobody really reads the details, they just whack a button, then I have to clean up the mess. And finally, why ask the user to do something in 2, 3 or 4 steps that I can do in the background in 1?
> 
> So the Substitute function ( Substitute ( Self ; "Paragraph Symbol" ; "" )) does work fine for removing any carriage returns. My bigger question was (and maybe I didn't make it clear) that I also wanted to remove any additional text the user typed in after the carriage return. In testing the auto enter, I found that if a user input:
> john (carriage return)
> jim (carriage return)
> 
> The Substitute auto enter would result in: johnjim
> 
> What I want is: john
> 
> I also wanted to trap for more than one carriage return with data typed in so:
> john (carriage return)
> jim (carriage return)
> amy (carriage return)
> mark (carriage return)
> 
> Did not become" johnjimamymark
> 
> This may sound unlikely, but in our older FMP6 solution, ID'ing multiple people in a photo shoot was done this way.... now the names reside in a child table of People, entered in the system in a portal from the parent table.
> 
> So that's why I had included the RightWords steps in the substitute also, to try to remove anything after the first carriage return. If anyone has a more elegant fix for that, I'm all ears.
> 
> 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

--
Jonathan Fletcher
FileMaker 9 & 10 Certified Developer

Fletcher Data Consulting
[log in to unmask]
http://www.fletcherdata.com
502-509-7137

Kentuckiana's FileMaker Users Group
Next meeting: February 22, 12:00 pm to 3:00-ish
Special Location! Special Program!
Info & RSVP: http://fmpug.com/scheduleMeetings.php
Listserv signup: http://fmpug.com/mailman/listinfo/louisville_fmpug.com
Blog: http://www.kyfmp.com