
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 01, 2024 01:31 PM
I have a Long Text column in my table with a lot of text, likely 20K plus pages. I used formulas to clean this text, removing undesirable characters, extra spaces, etc. Is there any way to copy the contents of the Formula column back to the Long Text column, so that the Long Text column will ahve clean but editable data for future use? While I can copy and past some smaller data sets, when I tried to copy and paste this column, I get a 'too large' error.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 01, 2024 01:48 PM - edited ‎Mar 01, 2024 01:49 PM
One easy way to do this would be to just convert the formula field to a long text field.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 01, 2024 01:48 PM - edited ‎Mar 01, 2024 01:49 PM
One easy way to do this would be to just convert the formula field to a long text field.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 02, 2024 01:46 AM
Interesting! Does it fail when you use an automation to copy paste it over too? Maybe using an automation bypasses the character limit or something. Any chance you can provide the text you're trying to paste into a longtext field via DM or something?
My immediate assumption is that your end result should have a lower character length than your original text, and so pasting it into the original field should be fine. Are your formulas adding anything to the text?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Mar 02, 2024 11:32 AM
I think I understand what you mean. If I write a formula like this Trim(DESCRIPTION), it does indeed work fine. The problem is, it isn't editable. What works is converting that field into long text, then renaming it. It's a bit onerous, but works.
