We are looking to take 300 rows of data in a comma delimited CSV file and move the data into a flat file in the following format.
The CSV column names are different from the "name" in "Value-name-pairs" below that are meant to be the output. We will give you a matching list.
Original format:
"key":"wccf_g2_crowd_rating", "label":"G2 Crowd Rating", "value":"3",
Each value name pair:
"key":"wccf_g2_crowd_rating",
"label":"G2 Crowd Rating",
"value":"3",
These are the data elements in the above example:
"wccf_g2_crowd_rating",
"G2 Crowd Rating",
"3",
This is the full list of value name pairs:
[{"key":"wccf_g2_crowd_rating","label":"G2 Crowd Rating","value":"3","type":"number","option_labels":[],"pricing":[],"file":[],"conditions":[]},{"key":"wccf_num_g2_reviews","label":"Number of G2Crowd Reviews","value":"5","type":"number","option_labels":[],"pricing":[],"file":[],"conditions":[]},{"key":"wccf_g2_url","label":"G2Crowd URL","value":"[login to view URL]","type":"text","option_labels":[],"pricing":[],"file":[],"conditions":[]},{"key":"wccf_gapp_rating","label":"GetApp Rating","value":"3","type":"number","option_labels":[],"pricing":[],"file":[],"conditions":[]},{"key":"wccf_num_gapp_reviews","label":"Number of GetApp Reviews","value":"6","type":"number","option_labels":[],"pricing":[],"file":[],"conditions":[]},{"key":"wccf_gapp_url","label":"GetApp URL","value":"[login to view URL]","type":"text","option_labels":[],"pricing":[],"file":[],"conditions":[]},{"key":"wccf_features","label":"Features","value":"some features","type":"textarea","option_labels":[],"pricing":[],"file":[],"conditions":[]},{"key":"wccf_whats_new","label":"What's New","value":"new","type":"textarea","option_labels":[],"pricing":[],"file":[],"conditions":[]}]