You’re offline. This is a read only version of the page.
Announcements
88
Hi all,
I'm working on a project that processes surveys from our dept from a CSV file we get weekly. I followed this guide to the T How To Parse any CSV to JSON Array - DamoBird365 and it works very well except for one thing, returns.
Some people like to have a return in their comments such as
"This person was great.
Thanks Company!"
this breaks the script and locates things in places where they shouldn't be.
The thing I could use as a "delimiter" of some sort is the double quotes because those are there but I am just a bit confused on how I would go about doing that.
What are your thoughts.
Have a look at my solution using the link below were you can use Office Scripts to extract the JSON data from a CSV file. I'm pretty sure it will handle this scenario.
Share
Report
All responses (
Answers (
