Is there a way to copy and paste text manually from a document and insert the text into a text field and have the existing formatting removed so the data can use the formatting that is assigned to the field?
Use TextFormatRemove() in a calculated value or script trigger
The best way would be to define the text field with an Auto-Enter Calculated value
After clicking Specify, enter the following calculation: TextFormatRemove ( Self )
a variant could be: Trim ( TextFormatRemove ( Self ) ) You'll kill to birds with one stone and Returns text stripped of all leading and trailing spaces.
Did you like the suggestion, was it helpful? Feel free to share with us and if your problem is solved check correct answer.
You can also do it manually with "undo" just after the paste. (So you need 2 undoes for real undo, when paste formatted text)
If you implement my suggestion be aware that it won't change the fields already containing data. The trick to circumvent that problem is
ThierryGuemboura wrote:Enter the suggested calculation Trim ( TextFormatRemove ( Self ) )
You cannot use Self within Replace Field Contents; you will need to specify the field name.
You are 100 correct, I just CTRL+C and V my previous message and didn't think about it.
You can Drag and Drop the text into the field too.
There's the "Paste Text Only" option under the "Edit" menu:
But I do this so often that my fingers just automatically go to the keyboard shortcut, which is a normal paste (⌘V) plus 2 additional modifier keys (⌥⇧). That's on a Mac, where ⌘ = command, ⌥ = option, and ⇧ = shift. I believe the Windows equivalents are control, alt, and shift, respectively.
Retrieving data ...