How do I parse CSV database and organise results ?

One option is to use CSV addon, you can download it here:

github.com/erenertugrul/construct-plugins/tree/master/ported_plugins/plugins

Here is an example I made a few years ago which demonstrates how to use this addon:

howtoconstructdemos.com/platformer-game-template-with-in-game-shop-where-different-items-sold-on-different-levels

.

The second option is to load this data into an array and make a couple of helper functions which will lookup data by column and row headers.

Hi dop2000

Thank you for the suggestion ! Unfortunately, the CSV plugin doesn't wourk with the latest version of Construct 3. I turned the csv into json, it may help to be more Construct3 compatible. Here is the link : https://www.dropbox.com/s/d244shnhug9yhd9/TestFile.json?dl=0

One of my big question here, is how to populate the dropdown list with Names in a case and Dates in the other case as to trigger display as indicated.

You can do this in Excel with a macro.

It's possible to parse the table in your original format. If the two lines for weather and moral always follow each other, then just grab the weather from the first line, and moral value from the next one.

It is not an option unfortunately. The little display/sorting app is meant for people who have no skills to make this convertion. They are just capable of uploading their csv and click to have the info they need. I'll use this capx here to transform the csv into an proposer C3 json : https://www.construct.net/en/forum/construct-3/how-do-i-8/csv-similiar-array-json-vice-129070

Like I said, you can still use your original table format. Read each line from the array one by one, compare name, compare date, compare the value in "key" column and add the information from "value" column to the text object.

Hi dop2000

Thanks to your help, I managed to extend your example and added all the options that I needed. I also managed to used the original csv as it. Work is not over yet but it is all in good shape. Thanks again !

So I had a quicker idea for how to access data from a list of names or dates. Basically, for all the names you'd add it to an array along with the indices of where it was in the original array. Then you can sort that, add it to a dropdown, and when changing selection you just reference the sorted array to find the original location.

dropbox.com/s/2cf76xirktuks2d/csv_lists.capx

Got sidetracked by the csv file format. In your example file it uses semicolons instead of commas, and you didn't use any quotes. Made things simpler to parse. That converter c3p seems to deal with quotes but seems esoteric. Generic csv support seems more involved as it's not super standardized.

There is a CSV2Array addon which works with the latest version of C3:

construct.net/en/forum/construct-3/plugin-sdk-10/erens-ported-plugins-modules-159391