• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
double-quotes stripped in CSV import
#3
(04-04-2020, 08:15 AM)Zubersoft Wrote: The reason double quotes are being stripped is they are actually used a way to get around the column delimiter if needed. For example, if you wanted to be able to have a semi-colon in the name of something, for whatever reason, you could do so by putting double quotes around the entire entry. So I'm not sure how to support both that and your desire to have double quotes show up in the name. I suppose either I could switch this to single quotes or you could switch your use to single quotes. I'm fine with switching it to single quotes on my end, but I want to ensure that no other users are going to be negatively impacted by this before I make the change. 

Thanks,
Mike
I understand, but how about simply stripping the quotes IF AND ONLY IF the prohibited character is found between them--the semi-colon in your example--thus ensuring that only quotes that are performing that exceptional function will be stripped. The same logic would apply to users who use single quotes for their own purposes--if they're using them to Escape the standard delimiter, etc., you'll know it because you'll find it in the string. Then and only then should the single or double quotes be stripped.

Otherwise, I have a substantial amount of editing of 1000s of entries in my existing database before I can import them. I'm already spending hours editing the stripped ones from 100s of songs already imported.
Reply


Messages In This Thread
double-quotes stripped in CSV import - by KHS - 04-04-2020, 07:51 AM
RE: double-quotes stripped in CSV import - by KHS - 04-04-2020, 08:57 AM
RE: double-quotes stripped in CSV import - by KHS - 04-04-2020, 09:49 AM
RE: double-quotes stripped in CSV import - by KHS - 04-04-2020, 11:12 AM



Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2024 MyBB Group.