Why is '\r' being added to values that are copied from Excel or Word into into a Text column in QuickBase? It is not happening consistently, using IE 11, Office 2013..

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I create two text columns and am copying those from two text columns in a spreadsheet.  One column copies fine, the other column adds '\r' at the end of each copied value.
Photo of Jim

Jim

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
With script you can automatically correct this type of data entry. In fact the script can modify the pasted value in a wide variety of ways including:

  • Expand abbreviations
  • Remove or substitute specific characters or short codes
  • Change capitalization
  • Anything else you can dream up
In your specific situation it would be best to work with a known spreadsheet and cell from which the offending "\r" character is being pasted into a form field to insure the problem is solved.
If you need assistance implementing this solution fee free to contact me using the information in my profile:

https://quickbase-community.intuit.com/users/513/
Photo of Jim

Jim

  • 0 Points
Thanks for the suggestion on how to fix this after it happens, I would like to know how to prevent it from happening in the first place?  I made sure the column in Excel is a Text column and I also applied the 'Clean' formula in Excel to remove any unprintable characters (I then copied and pasted values only to a new TEXT column in Excel before copying to QB).  Seems like someone from Quickbase should explain when/why they append the '/r' to a value that is pasted into a cell.  I can share a portion of the spreadsheet if someone want to try to recreate this.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
I understand what you are saying but I am offering a broader view of this problem and a general solution which will subsume hundreds of individual use cases. When pasting data from external sources (or even when it is keyed in by a human) into QuickBase you want to verify that data and clean it up before it is saved. Using script to clean up your data entry should be your default action as this requirement will eventually appear during the lifetime of your application. So I say use script in every instance - no exceptions.