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...
2.解析 关键字try 以及except是 使用Python 解释器主动抛出异常的关键， Python解释器从上向下执行 当...
Favorite Download PDF ShareWas this page helpful? YesNoCopyright Disclaimer Privacy Statement Legal Disclosure Trademark Terms of Use Cookie Preferences System Status Ask a question about the SAP Help Portal Find us on Share
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}([^|...
2.解析 关键字try 以及except是 使用Python 解释器主动抛出异常的关键， Python解释器从上向下执行 当...