B2B Integration

Sterling B2B Integration

Come for answers, stay for best practices. All we're missing is you.

 View Only

  • 1.  Converting binary sequences back to ASCII

    Posted Fri April 24, 2020 10:55 AM
    Edited by System Admin Wed March 22, 2023 11:44 AM
      |   view attached
    I received a query about converting binary sequences to ASCII, so that the following:

    01010100 01001000 01001001 01010011 00100000 00100000 01001001 01010011 00100000 00100000 01000001 00100000 00100000 01010100 01000101 01010011 01010100 00100000 01000110 01001001 01001100 01000101 00100000 00100000 01000011 01001111 01001110 01010100 01000001 01001001 01001110 01001001 01001110 01000111 00100000 00100000 01001111 01001110 01001100 01011001 00100000 00100000 01000010 01001001 01001110 01000001 01010010 01011001 00100000 00100000 01000011 01001000 01000001 01010010 01000001 01000011 01010100 01000101 01010010 01010011 00001010
    01001001 01010100 00100000 01001010 01010101 01010011 01010100 00100000 01000011 01001111 01001110 01010110 01000101 01010010 01010100 01010011 00100000 01000010 01001001 01001110 01000001 01010010 01011001 00100000 01000011 01001000 01000001 01010010 01000001 01000011 01010100 01000101 01010010 01010011 00100000 01010100 01001111 00100000 01010100 01001000 01000101 01001001 01010010 00100000 01000001 01010011 01000011 01001001 01001001 00100000 01000101 01010001 01010101 01001001 01010110 01000001 01001100 01000101 01001110 01010100 00001010
    01010100 01001000 01000101 01010010 01000101 00100000 01000001 01010010 01000101 00100000 01001110 01001111 00100000 01000011 01001000 01000001 01010010 01000001 01000011 01010100 01000101 01010010 00100000 01010011 01000101 01010000 01000001 01010010 01000001 01010100 01001111 01010010 01010011 00100000 01000010 01010101 01010100 00100000 01010100 01001000 01000101 01010010 01000101 00100000 01000001 01010010 01000101 00100000 01000101 01001110 01000100 00100000 01001111 01000110 00100000 01001100 01001001 01001110 01000101 01010011 00001010

    ....needs to be converted to:

    THIS IS A TEST FILE CONTAINING ONLY BINARY CHARACTERS
    IT JUST CONVERTS BINARY CHARACTERS TO THEIR ASCII EQUIVALENT
    THERE ARE NO CHARACTER SEPARATORS BUT THERE ARE END OF LINES

    I have attached my approach to the issue using ITX.  The key was the TOBASETEN() function with the second argument being '2' (as in binary).

    Enjoy!


    ------------------------------
    Paul Brett
     
    IBM Sterling Transformation Extender (ITX) Client Support
    ------------------------------
    #B2BIntegration
    #SupplyChain

    Attachment(s)

    zip
    Binary2Ascii.zip   6 KB 1 version


  • 2.  RE: Converting binary sequences back to ASCII

    Posted Sat April 25, 2020 03:25 AM
    Edited by System Admin Wed March 22, 2023 11:47 AM
      |   view attached
    Here's a better version (no run map required).

    I suddenly thought this morning (while making tea) - "I could use a SYMBOL() function instead of that RUN() map).

    ------------------------------
    Paul Brett
     
    IBM Sterling Transformation Extender (ITX) Client Support
    ------------------------------

    Attachment(s)

    zip
    Binary2Ascii_V2.zip   6 KB 1 version
    Original Message


  • 3.  RE: Converting binary sequences back to ASCII

    Posted Sat April 25, 2020 10:27 AM
    Thanks Paul. Hope you had a good Tea :)

    ------------------------------
    Luv
    ------------------------------

    Original Message