Get answers quicker by searching

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion

Unable to have commas in name
  • Vote Up0Vote Down yaoquanyaoquan
    Posts: 36Sendy user
    Is there anyway to sidestep this to allow commas in names or custom fields?
  • 5 Comments
  • Vote Up0Vote Down BenBen
    Posts: 3,489Sendy support
    Hey. CSVs are separated by commas, hence the name 'Comma Separated Values'. You can try sidestepping this by adding subscribers via the 'per line' field.
  • Vote Up0Vote Down yaoquanyaoquan
    Posts: 36Sendy user
    Hmmm, but you seem to be using explode(',') this causes even columns which are like this -> "Peter, Stevens" which happens to be the persons name to be split up, causing issues with importing. The perline adding seems to also have have this hardcoded in.
  • Vote Up0Vote Down BenBen
    Posts: 3,489Sendy support
    CSVs are separated using commas in each line. Exploding lines with respect to commas is a means to process each and every column, there is nothing wrong using explode. If we don't break up columns using explode(',') there is no way to separate the columns in the CSV for processing. Do a search & replace on 'Excel' or 'Numbers' and remove those commas.
  • Vote Up0Vote Down yaoquanyaoquan
    Posts: 36Sendy user
    But the issue is that, those are the exact way the subscribers names are spelt out. Or the custom fields would be required to have. I'll side step it with some hacks though. Thanks for being so prompt in replies!
  • Vote Up0Vote Down BenBen
    Posts: 3,489Sendy support
    You're welcome!
This discussion has been closed.
All Discussions