not as familiar with IWP as I am with non-web FMP, but in the Inspector you can set fields to 'Got to next object using...' - if you select Enter, then your users will go to the next field rather than enter a CR in the field...
I'm only assuming that this would still be valid for IWP
Hi thanks symbister - unfortunately this doesn't work for IWP. I need some sort of code that removes all the extraneous text. Thanks
OK I worked it out myself. I put this code into the field as an auto-entered calc, unchecking the "donot replace existing data" (or something):
If ( Position ( field ; "¶" ; 1 ; 1 ) = 0 ; field ; Left ( field ; (Position ( field ; "¶" ; 1 ; 1 ))-1) )