Converting a Value of Type String to Type Long

The JSON transformation process in this example demonstrates how the textual value inside the key 'LONG_VALUE_IN_STRING' is converted to a long integer value.

Sample Original Message

input null:
{
   "LONG_VALUE_IN_STRING" : null
}
input empty string "":
{
   "LONG_VALUE_IN_STRING" : ""
}
input string "123":
{
   "LONG_VALUE_IN_STRING" : "123"
}

CODE

JOLT Code

[ 
  {
    "operation": "shift",
    "spec": {
      "LONG_VALUE_IN_STRING": {
        "": null,
        " ": null,
        "*": {
          "$": "LONG_VALUE_IN_STRING"
        }
      } 
    }
  },
  { 
    "operation": "default",
    "spec": {
      "LONG_VALUE_IN_STRING": 0
    }
  },
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "LONG_VALUE_IN_STRING": "=toLong"
    }
   },
  {
    "operation": "shift",
    "spec": {
      "LONG_VALUE_IN_STRING": "value"
    }
   }
]

CODE

Sample Result Message

{
  "value": 0
}
{
  "value": 0
}
{
  "value": 123
}

CODE