오픈리파인에서 KML 시도 구분하기

TL_SCCO_SID.json

[
  {
    "op": "core/column-split",
    "description": "Split column description by separator",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "description",
    "guessCellType": true,
    "removeOriginalColumn": true,
    "mode": "separator",
    "separator": "</p><p>",
    "regex": false,
    "maxColumns": 0
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column description 1 using expression grel:value.replace('<p>','')",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "description 1",
    "expression": "grel:value.replace('<p>','')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/text-transform",
    "description": "Text transform on cells in column description 2 using expression grel:value.replace('</p>','')",
    "engineConfig": {
      "mode": "row-based",
      "facets": []
    },
    "columnName": "description 2",
    "expression": "grel:value.replace('</p>','')",
    "onError": "keep-original",
    "repeat": false,
    "repeatCount": 10
  },
  {
    "op": "core/column-rename",
    "description": "Rename column description 2 to 시도",
    "oldColumnName": "description 2",
    "newColumnName": "시도"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column description 1 to 시도영문",
    "oldColumnName": "description 1",
    "newColumnName": "시도영문"
  },
  {
    "op": "core/column-rename",
    "description": "Rename column name to 시도코드",
    "oldColumnName": "name",
    "newColumnName": "시도코드"
  },
  {
    "op": "core/column-reorder",
    "description": "Reorder columns",
    "columnNames": [
      "시도",
      "시도영문",
      "시도코드",
      "geometry"
    ]
  }
]