search

cedadev / c3s_434_ecde_page_text

To manage page text for the European Climate Data Explorer being developed by the C3S 434 project.
MIT License
0 stars 2 forks source link

Remove newline characters from Consolidated work sheet #7

Closed jhaigh0 closed 3 years ago

jhaigh0 commented 3 years ago

Currently in the Consolidated work sheet, cells C6-C13 are consolidating a lot of empty strings (since they're aren't that many entries yet). This leads to some newline characters being put in those cells but no actual information. When downloading the data from the spread sheets these newline characters get put into the json array for consolidated texts, leaving a bunch of entries which look like this;

{
    "ConsolidatedText_Explore": "    \n\n  \n\n \n\n\n\n \n\n\n\n  ",
    "ConsolidatedText_Main": "",
    "Indicator": ""
},

This currently creates some problems when creating the markdown files. I think cells C6-C13 shouldn't have their consolidation function until there is actual data, to fix this problem.

charliepascoe commented 3 years ago

Sorry about that. I've removed the concatenate function content from the empty cells on the consolidated tab.