-- forked from sam / hex to string on input data @ https://flipsidecrypto.xyz/sam/q/PLHGqAmEwi09/hex-to-string-on-input-data
select
tx_hash,
utils.udf_hex_to_string(substr(input_data, 3)) as extracted_string
from ethereum.core.fact_transactions
where block_timestamp::date >= '2024-02-01'
and extracted_string is not null
and extracted_string != ''
and extracted_string not like '%mint%'
and extracted_string not like '%data%'
and REGEXP_LIKE(extracted_string, '[A-Za-z0-9\s,.!? ]+')
and len(extracted_string) >= 10