Tim, Thanks for the code - that's a really good option. I'll propose it. On Wed, Mar 1, 2017 at 9:39 AM, Tim Nevels via 4D_Tech <[email protected] > wrote:
> On Mar 1, 2017, at 11:15 AM,Kirk Brooks wrote: > > > In this case an record entry field sometimes has data pasted in from > things > > like Word docs which can introduce a lot of extraneous crap. The user was > > looking for options to control that. > > Pasting data from Word is problematic. Sometimes it works great and styles > are preserved. Other times the resulting paste is a big mess. No easy fix. > You need to get example Word documents that cause problems and then analyze > the info in the pasteboard. > > I ran into a similar problem and I had to put a button on the form called > “Paste With No Style”. This would look at the data in the pasteboard, clean > it up and remove stuff and then add it to the field. I added keyboard > shortcut of Ctrl-Shift-V to the button for convenience. > > Here’ some sample code: > > // Paste With No Style button on Case Activity Notes input form > > C_TEXT($theText_t) > C_LONGINT($start;$end) > > $theText_t:=Get text from pasteboard > $theText_t:=ST Get plain text($theText_t) > > GET HIGHLIGHT([CaseActivityNotes]Comments;$start;$end) > > If (($start=1) & ($end=1)) // at the beginning of the field > [CaseActivityNotes]Comments:=$theText_t+[CaseActivityNotes]Comments > Else // somewhere else, so put it at the end > [CaseActivityNotes]Comments:=[CaseActivityNotes]Comments+$theText_t > End if > > > Of course it also brought up issues of what happens to existing data when > > the option is toggled... > > If you have a field that has styled text stored in it, and you turn off > the Multi-style property on the form, you will just see all the span tags. > > For debugging purposes put 2 copies of the field on a form on top of each > other. Turn on the Multi-style property on one, turn it off for the other. > Set the non-Multi-style field to be “Invisible by Default". Then put an > invisible button on the form with a secret keyboard shortcut only you know. > Have the button toggle visibility of the 2 fields so that you can switch > between “normal” Multi-style viewing and “raw” viewing so you can see all > the span tags. > > This is very useful for tracking down and fixing unescaped characters like > “&”, “<“ and “>” that cause Multi-style fields to display as a big mess. > > Tim > > ******************************************** > Tim Nevels > Innovative Solutions > 785-749-3444 > [email protected] > ******************************************** > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > FAQ: http://lists.4d.com/faqnug.html > Archive: http://lists.4d.com/archives.html > Options: http://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** > -- Kirk Brooks San Francisco, CA ======================= ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
