I think exact function like regexp_replace is not available in HANA, you might want to use "REPLACE" , "SUBSTRING" and concat them to achieve the same. Can you please tell me what out is your intended out put for 123123|444|555|6666|77|88 ? Cheers Anindya You must be a registered...
as… 是固定的语法格式 打印traceback信息 finally 后的代码不管是否抛出异常都会执行 except 的原理 ...
SAP Managed Tags: SAP HANA Hello Experts, Below is the logic for regexp_replace from oracle source DB. Can you please help how to achieve this in Hana Scipt. regexp_replace(field1,'^[^|]*\|([^|]*).*$','\1') as channel_1, regexp_replace(field1,'^([^|]*\|){2}([^|...