How to convert hex to decimal values in RM Studio ?

Best Answers

• bhupendra_patil Administrator, Employee, MemberPosts:168RM Data Scientist

  July 2016 Solution Accepted

  Hello@reedevtaneja

  There doesnot seem to be an operator to do that, however we can use the execute script operator to do this.and the script is very easy

  Here is the script you will need and it is also in the attached example rmp process.

  Please not that it changes all columns from hex to dec, so you will need to prefix it with "select attributes" to pass only the desired ones.

  Or depending on your use case, you cna hard code few things..

  Hope this is helpful

  ExampleSet exampleSet = operator.getInput(ExampleSet.class);
  
  for (Attribute attribute : exampleSet.getAttributes()) {
  String name = attribute.getName();
  for (Example example : exampleSet) {
  //example[name] = example[name].toUpperCase();
  example[name] = Integer.parseInt(example[name].trim(), 16 );
  
  }
  }
  
  return exampleSet;
  

  convert hex to decimal.rmp 3.4K

  

  1
• reedevtaneja MemberPosts:2Contributor I

  July 2016 Solution Accepted

  Thanks BP, It was quick and helpful.

  0
• bhupendra_patil Administrator, Employee, MemberPosts:168RM Data Scientist

  July 2016 Solution Accepted

  For similar use casez:This is example of Binary to Integers

  ExampleSet exampleSet = operator.getInput(ExampleSet.class);
  
  for (Attribute attribute : exampleSet.getAttributes()) {
  String name = attribute.getName();
  for (Example example : exampleSet) {
  //example[name] = example[name].toUpperCase();
  example[name] = Integer.parseInt(example[name].trim(), 2 );
  
  }
  }
  
  return exampleSet;
  
  

  

  1
• bhupendra_patil Administrator, Employee, MemberPosts:168RM Data Scientist

  July 2016 Solution Accepted

  This is example of Hex to Binary

  ExampleSet exampleSet = operator.getInput(ExampleSet.class);
  
  for (Attribute attribute : exampleSet.getAttributes()) {
  String name = attribute.getName();
  for (Example example : exampleSet) {
  //example[name] = example[name].toUpperCase();
  int myint = Integer.parseInt(example[name].trim(), 16 );
  example[name] = Integer.toBinaryString(myint)
  
  }
  }
  
  return exampleSet;
  
  

  

  1
• keildvol2 MemberPosts:1Contributor I

  June 2017 Solution Accepted

  遇到同样的问题…任何help is highly appreciated. Thank you!

  EDIT: solved it in my case, maybe the following change to the script is helpful for others:

  ExampleSet exampleSet = operator.getInput(ExampleSet.class);
  
  for (Attribute attribute : exampleSet.getAttributes()) {
  String name = attribute.getName();
  for (Example example : exampleSet) {
  //example[name] = example[name].toUpperCase();
  example[name] = new BigInteger(example[name].trim(), 16);
  
  
  }
  }
  
  return exampleSet;

  You could also try Long type first (instead of int) if your hex values are not that big.

  Best regards

  

  1