오픈리파인에서 KML 시군구 구분하기
TL_SCCO_SIG.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"
]
}
]