Skip to Content

how to convert hexadecimal to integer in SAP BODS

Hi All,

We have a value from source 0x000000000007D407 as timestamp datatype. which we take as varchar(255) in BODS(Because we checked the option unsupported datatype in datastore level). so value in BODS is 000000000007D407. Here our requirement is to convert the value into interger type.

How to achieve this in BODS.

Immediate response is much appreciated.

Thankyou in Advance :)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Mar 14 at 09:18 AM

    Hello Kalyani,

    I've made a blog with some sample data out of your question.Hexadecimal to Integer

    Let me know if it helps!

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 14 at 06:10 AM

    Write a custom function.

    You'll find plenty of examples when you Google "SAP Data Services how to convert hexadecimal to integer". Please always search before posting.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 14 at 08:03 AM
    Add comment
    10|10000 characters needed characters exceeded