0 Replies Latest reply on Mar 22, 2012 2:15 PM by varoujanchakarian

    Convert binary data to float

    varoujanchakarian

      I have a data source in which one of the database columns is a binary string (in hex form) of an 2D array of float numbers. I'd like to convert it back to float. Does anyone know how to do this in Tableau? Currently we do this by using a C# program and use a built-in C# function  BitConverter.ToSingle(rawData, i * sizeof(float)). I'd like to do this inside Tableau if possible.

       

      Any help is appreciated.

       

      Here is an example of an array to be converted:

      BFB6D8C05C94D8C0E197D8C0B182D8C0C466D8C0D84AD8C0A935D8C0E121D8C0190ED8C05806D8C0C303D8C02F01D8C0BDFAD7C0B8ECD7C0B3DED7C0AFD0D7C025B5D7C07599D7C0C57DD7C0AA63D7C0F34CD7C03C36D7C0851FD7C0F00FD7C0A302D7C056F5D6C04EE8D6C006DED6C0BFD3D6C077C9D6C0DAB9D6C0F79DD6C01482D6C03166D6C0EA47D6C03F27D6C09306D6C0E7E5D5C022CAD5C099B0D5C01097D5C0867DD5C09868D5C03E55D5C0E441D5C08A2ED5C0F40FD5C006F0D4C018D0D4C08FADD4C08077D4C07241D4C0640BD4C094D3D3C0E597D3C0355CD3C08620D3C009DBD2C0DA8AD2C0AA3AD2C07BEAD1C0717FD1C0470DD1C01C9BD0C07B0DD0C01847CFC0B580CEC0A1B6CDC06579CCC02A3CCBC004F6C9C0061DC8C00844C6C01B17C4C03377C1C06CA9BEC0DF0BBBC00126B7C0F359B2C08FECACC070F0A6C04009A0C0984398C0C79D8FC031FD85C0B9CD76C0FCE45FC0A3FE46C05A122CC0181C0FC006B6E0BFCE619EBFD6272DBFD11805BEC9E0E33E1FD0873FC3AFD93F574017400E614340EBB07040