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 > [email protected] > http://www.photo.alumni.uga.edu -- Jonathan Fletcher FileMaker 9 & 10 Certified Developer Fletcher Data Consulting [email protected] 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
