Extra characters and line breaks in my lists


#1

I’m getting Quote marks and line breaks in fields, when I copy and paste the data to a txt file (or download a CSV). What should look like this:

MARKETING
MARKETING
ONLINE ORDERS
ONLINE ORDERS

Looks like this!

"
MARKETING
"
"
MARKETING
"
"
ONLINE ORDERS
"
"
ONLINE ORDERS
"

I wonder why this has suddenly started happening, and how I can stop it?


#2

I found the issue. It occurs when importing new records with the same data in the single select field. AT makes a new copy of the options and the double up versions get these extra characters wrapped around them. It could some manual work to Find and replace and then restore the options without the characters.