Hi,

I don't know if this is a bug, something I'm doing wrong, or something by design, but almost every field I import from a CSV file starts with a space.
When my UTF-8 CSV file is like this:
Field-1, Field-2, Field-3
"This", "is", "very weard"

the imported field end up in the database like this
Field-1: " This"
Field-2: " is "
Field-3: " very strange"

As a workaround I trim the imported fields in the database, but I suppose this is not the way it should be???

Comments

wusel’s picture

wusel commented

Try to avoid the "space" between the fields in your CSV-file like:

Field-1,Field-2,Field-3
"This","is","very weard"
GeertWil’s picture

GeertWil commented

Thank you Wusel. The solutions may seem obvious, but I coulnd't find it myself.
You make my day.

wusel’s picture

wusel commented
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.