{
  "version": "5.7.1",
  "className": "datameer.dap.common.entity.WorkbookConfigurationImpl",
  "file": {
    "uuid": "ec8d665b-3140-4f5b-8886-215f8d7c1872",
    "path": "/Analytics/Workbooks/Ticket_8905.wbk",
    "description": "",
    "name": "Ticket_8905"
  },
  "pullType": "MANUALLY",
  "minKeepCount": 1,
  "properties": {},
  "hadoopProperties": "",
  "notificationAddresses": "",
  "notificationSuccessAddresses": "",
  "sheets": [
    {
      "name": "hexString",
      "sheetId": "c4f18e9f-1ad3-43fb-a3e7-d8709466f33b",
      "sheetType": "das.internal.FormulaSheetType",
      "keep": true,
      "formulas": [
        {
          "columnName": "hexString",
          "columnId": "0",
          "columnIndex": 0,
          "formulaString": "\u003d\"537472696e67\""
        }
      ],
      "columnStyles": [
        {
          "columnId": "0",
          "name": "hexString",
          "width": 100,
          "thousandSeparator": true
        }
      ],
      "nextColumnId": 2
    },
    {
      "name": "StringToConvert",
      "sheetId": "1e38d987-7312-43e6-b559-b7e30d47fdd6",
      "sheetType": "das.internal.FormulaSheetType",
      "keep": true,
      "formulas": [
        {
          "columnName": "StringID",
          "columnId": "0",
          "columnIndex": 0,
          "formulaString": "\u003dGROUPBY(1)"
        },
        {
          "columnName": "Tokens",
          "columnId": "1",
          "columnIndex": 1,
          "formulaString": "\u003dREGEXTRACT(#hexString!hexString;\"([a-zA-Z0-9]{2})\")"
        },
        {
          "columnName": "Hex2Dec",
          "columnId": "4",
          "columnIndex": 2,
          "formulaString": "\u003dHEX2DEC(#Tokens)"
        },
        {
          "columnName": "Characters",
          "columnId": "6",
          "columnIndex": 3,
          "formulaString": "\u003dCHAR(#Hex2Dec)"
        }
      ],
      "columnStyles": [
        {
          "columnId": "0",
          "name": "StringID",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1",
          "name": "Tokens",
          "width": 111,
          "thousandSeparator": true
        },
        {
          "columnId": "4",
          "name": "Hex2Dec",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "6",
          "name": "Characters",
          "width": 100,
          "thousandSeparator": true
        }
      ],
      "nextColumnId": 7
    },
    {
      "name": "ConvertedString",
      "sheetId": "8cebe792-15bc-4086-a009-d7e5926eb634",
      "sheetType": "das.internal.FormulaSheetType",
      "keep": true,
      "formulas": [
        {
          "columnName": "StringID",
          "columnId": "0",
          "columnIndex": 0,
          "formulaString": "\u003dGroupBy(#StringToConvert!StringID)"
        },
        {
          "columnName": "Characters",
          "columnId": "1",
          "columnIndex": 1,
          "formulaString": "\u003dGROUPCONCAT(#StringToConvert!Characters)"
        }
      ],
      "columnStyles": [
        {
          "columnId": "0",
          "name": "StringID",
          "width": 100,
          "thousandSeparator": true
        },
        {
          "columnId": "1",
          "name": "Characters",
          "width": 100,
          "thousandSeparator": true
        }
      ],
      "nextColumnId": 2
    }
  ],
  "advancedSchedulingInUse": true,
  "errorHandlingMode": "IGNORE"
}