Synthoid / ExportSheetData

Add-on for Google Sheets that allows sheets to be exported as JSON or XML.
MIT License
234 stars 46 forks source link

Ignore multiple prefix #118

Closed Alan3k closed 4 years ago

Alan3k commented 4 years ago

Hi,

I couldn't find solution.

How can I add more than one "Ignore prefix"?

I would like to ignore more than one column on export.

I have tired like this:

id, title, content id; title; content id|title|content

..and it didn't worked.

Sorry for my english and thanks for help.

Synthoid commented 4 years ago

To ignore multiple columns, you just need to add the ignore prefix to each column's key:

Name HP NOEX_MP STR CHR INT Special NOEX_Notes
Gorgon 64 50 13 15 14 10% chance to petrify. https://en.wikipedia.org/wiki/Gorgon

Default output:

{
  "Monsters": {
    "Gorgon": {
      "HP": 64,
      "NOEX_MP": 50,
      "STR": 13,
      "CHR": 15,
      "INT": 14,
      "Special": "10% chance to petrify.",
      "NOEX_Notes": "https://en.wikipedia.org/wiki/Gorgon"
    }
  }
}

Ignore Prefix output:

{
  "Monsters": {
    "Gorgon": {
      "HP": 64,
      "STR": 13,
      "CHR": 15,
      "INT": 14,
      "Special": "10% chance to petrify."
    }
  }
}