Sbhn_NPScope Try
    Updated 2024-12-07
    select DISTINCT substr(utils.udf_base58_to_hex(instruction:data),3,1000) as raw_data,
    regexp_substr_all(SUBSTR(raw_data, 3, len(raw_data)), '.{8}') as segmented_data,
    utils.udf_hex_to_string((segmented_data [0])) as test0,
    utils.udf_hex_to_string((segmented_data [1])) as test1,
    utils.udf_hex_to_string((segmented_data [2])) as test2,
    utils.udf_hex_to_string((segmented_data [3])) as test3,
    utils.udf_hex_to_string((segmented_data [4])) as test4,
    from eclipse.core.fact_events_inner
    where tx_id = '7tb2yQhgh2W3ifvnxTQasLo28eitDibDf4DGdzwZq57mNuHjqpGGfL6XwN5GHX8ctmQh3DQvQ6rx4ZSqjVu7mCe'
    and program_id = 'Rarim7DMoD45z1o25QWPsWvTdFSSEdxaxriwWZLLTic'



    select DISTINCT to_varchar(base64_decode_binary(instruction:data))
    from eclipse.core.fact_events_inner
    where tx_id = '7tb2yQhgh2W3ifvnxTQasLo28eitDibDf4DGdzwZq57mNuHjqpGGfL6XwN5GHX8ctmQh3DQvQ6rx4ZSqjVu7mCe'
    and program_id = 'Rarim7DMoD45z1o25QWPsWvTdFSSEdxaxriwWZLLTic'


    select
    -- INNER_INSTRUCTION HEX SIGNATURE: 0xe445a52e51cb9a1d
    replace(substr(utils.udf_base58_to_hex(INSTRUCTION:data), 3, 1000), '') AS hex_data
    , utils.udf_hex_to_int('s2c', to_char(reverse(to_binary(substr(hex_data, 17, 8))))) AS length_of_name
    , 25 + (length_of_name * 2) AS symbol_start
    , utils.udf_hex_to_string(substr(hex_data, 25, length_of_name * 2)) AS name
    , cast(name as varchar) as main
    , utils.udf_hex_to_int('s2c', to_char(reverse(to_binary(substr(hex_data, symbol_start, 8))))) AS length_of_symbol
    , utils.udf_hex_to_string(substr(hex_data, symbol_start + 8, length_of_symbol * 2)) AS symbol
    from eclipse.core.fact_events_inner
    where tx_id = '27jW9f9B4oKVTz8Q1Lu9dB1hVgmVB6YdZ6VuWB6DWcUw3Wz5QpKQrDm4TSwM4WrkLp5CRHc7KWxFNwwKtozDW5Vt'
    and program_id = 'Rarim7DMoD45z1o25QWPsWvTdFSSEdxaxriwWZLLTic'
    -- select *
    -- from eclipse.core.fact_events
    -- where tx_id = '7tb2yQhgh2W3ifvnxTQasLo28eitDibDf4DGdzwZq57mNuHjqpGGfL6XwN5GHX8ctmQh3DQvQ6rx4ZSqjVu7mCe'