Help

The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.

CSV Downloading unwanted line breaks in long text

Topic Labels: Importing & Exporting
Solved
Jump to Solution
582 1
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Lulenka
5 - Automation Enthusiast
5 - Automation Enthusiast
See Solution in Thread

‎Jun 20, 2023 05:30 AM

I need help - my CSV file is downloading the line breaks in my long text fields - I tried to eliminate them running >REGEX_REPLACE for \r, \n, \r\n, u2028, u2029, u0085, u00B6
This took care of most of the line breaks but there are still 2 stubborn line breaks I cannot beat HELP!

0 Kudos
Reply
1 Solution

Accepted Solutions
Lulenka
5 - Automation Enthusiast
5 - Automation Enthusiast
Solved See Solution in Thread

‎Jun 20, 2023 11:37 PM

I managed to figure it out!!! - my formula was spot on but I only focused on the long text fields - I did not realise that the short text fields could also contain line breaks??? go figure😜

See Solution in Thread

0 Kudos
Reply
1 Reply 1
Lulenka
5 - Automation Enthusiast
5 - Automation Enthusiast
Solved See Solution in Thread

‎Jun 20, 2023 11:37 PM

I managed to figure it out!!! - my formula was spot on but I only focused on the long text fields - I did not realise that the short text fields could also contain line breaks??? go figure😜

0 Kudos
Reply
Copyright © 2024 Khoros, LLC