How to add string of csv data into new records via collection ?
How to add string of csv data into new records via collection ?
Hi,
I wonder if there is a way to turn a string containing csv values into a format suitable for adding as individual records into a report. This is my example data :
My thought is I need to create a collection and then add the string data to it, then iterate through the collection to add the record. I can see help files for creating blank collections, but not how to add existing data to those collections - especially when the headers are contained in the string rather than me having to create it manually.
a) Is creating a collection the right method to handle data like this ?
b) How do I convert the string of comma separated values into a collection ?