3 Replies Latest reply: Apr 14, 2017 10:07 AM by Peter Cammaert RSS

    Use base64_decode PHP function in Qlikview

    Halmar Heijnen

      Hello all,

       

      I need to decode a field in mij databasetable. It is filled with a value like:

      YTo1OntzOjU6Iml0ZW1zIjthOjE6e2k6MDthOjE3OntzOjY6Iml0ZW1JZCI7czozOiI0NjkiO3M6NToiY291bnQiO2k6MTtzOjc6Im9wdGlvbnMiO2E6MDp7fXM6NDoiaGFzaCI7czoxNToibHJzcHlvNDl6WlZEVFVhIjtzOjk6Im9wbWVya2luZyI7czoxMDI6IlppZSBlbWFpbCB2YW4gamVudGVkZWpvbmdAZ21haWwuY29tIHZlcnN0dXVyZCBvcCAxMiBhcHJpbC4gbWVwdGFhcnQgYmlqcGFzc2VuZCBiaWogZ2Vib29ydGVrYWFydHRhYXJ0LiI7czo4OiJsZWVmdGlqZCI7YjowO3M6NDoiZmlsZSI7YjowO3M6NDoidHlwZSI7czo1OiJ0YWFydCI7czo0OiJuYW1lIjtzOjIwOiJNZXAtIGVuIFBsZXQgVGFhcnRqZSI7czoxMToicHJvZHVjdENvZGUiO3M6NzoiTWVwLTAwMiI7czo3OiJmaWxlVXJsIjtiOjA7czo1OiJwcmljZSI7czo1OiIxMi45NSI7czo2OiJ0YXhMb3ciO3M6NDoiMC43MyI7czo3OiJ0YXhIaWdoIjtzOjQ6IjAuMDAiO3M6MTA6InRvdGFsUHJpY2UiO3M6NToiMTIuOTUiO3M6MTE6InRvdGFsVGF4TG93IjtzOjQ6IjAuNzMiO3M6MTI6InRvdGFsVGF4SGlnaCI7czo0OiIwLjAwIjt9fXM6MTA6InRvdGFsUHJpY2UiO3M6NToiMTIuOTUiO3M6NDoidHlwZSI7czo1OiJ0YWFydCI7czoxMToidG90YWxUYXhMb3ciO3M6NDoiMC43MyI7czoxMjoidG90YWxUYXhIaWdoIjtzOjQ6IjAuMDAiO30=

       

      In PHP you can use the function unserialize(base64_decode("<tekst>")).

      Can anyone help me to do this in QlikView/Qlik Sense?

       

      Thanks!

       

      Halmar