Skip to content

Unable to have commas in name

edited October 2012 in Troubleshooting
Is there anyway to sidestep this to allow commas in names or custom fields?

Comments

  • 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.
  • 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.
  • 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.
  • 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!
  • You're welcome!
This discussion has been closed.