Reply To: CSV file wont load

[Damon BellKeymaster]

@Michelle Sohn

It probably wasn’t a space, but just looked like a space. SPA will auto trim spaces. Spaces will never prevent the CSV from loading. It was probably special character that Excel can’t display, so it just displayed it as a space.  The special characters can cause issues.  I have seen where some data collection systems people use create these special characters like letters with circumflexes, greek characters, and other oddball characters. Since Excel can’t display some of these, they show as a blank space. The SPA trim feature will trim spaces but since those characters are not actually spaces they don’t get trimmed. Some characters mess up the javascript parsing.

So if you see this again then look to whatever data collection system you are using to see if it is adding these characters.