Transformer une colonne de donnees decimals en hexadecimal

[theo_180280]

Hi i want to convert decimal data in hexadecimal. Thanks

[Jeff_Hager]

Try this in a javascript column. The p1 parameter is the number you want to convert.

let num = parseFloat(p1);
return num.toString(16);

[theo_180280]

[theo_180280]

I want to convert rfid_bis in hexadecinal

[slscustom.ru]

@Jeff_Hager

let num = parseFloat(p1);
return num.toString(16);

[theo_180280]

Thanks

[theo_180280]

Hi i have an other problem i want to inverse chiffres for example.
2F86D431 it s resultant after formula but i need to inverse like this
F2684D13.
Thanks

[slscustom.ru]

Hi! Do you mean to change digits order? Does the qty of digits every time same?

[Jeff_Hager]

let arrInput = p1.match(/.{1,2}/g);
let i = 0;

while(i < arrInput.length ) {
   arrInput[i] = 
   arrInput[i].split('').reverse().join('');
   i++;
}

return arrInput.join('');

[theo_180280]

Yes can you show me exactly how you do.thanks

[Jeff_Hager]

Create a javascript column, copy and paste the code above and set the p1 parameter to the column that you want to inverse. Exactly the same procedure that @slscustom.ru is showing in his image from a couple days ago.

[theo_180280]

thanks i want to obtain

at right it the code with your fomule but i want the code on the left.thanks

[Jeff_Hager]

OK, you initially asked to swap every two characters, but now you are saying that you want the entire thing to be reversed?

This should be all you need.

return p1.split('').reverse().join('');

[Xavier_Delplanque]

It doesn’t look like a shift of the string, but of every couple
2F 34 30 41 > 41 30 34 2F
(A shift would produce 140343F2)

It feels like this should have a name
A little endian ?

Would ChatGPT give a correct answer ?

It looks like it’s working

  let hexStr = p1.toString(16); 
  if (hexStr.length % 2 !== 0) {
    hexStr = '0' + hexStr; 
  }
  let hexBytes = [];
  for (let i = 0; i < hexStr.length; i += 2) {
    hexBytes.unshift(parseInt(hexStr.slice(i, i+2), 16)); 
  }
  return hexBytes.map(b => b.toString(16).padStart(2, '0')).join(''); 

[theo_180280]

thanks it s perfect