Column Engine replace_regexpr in calculation view

[arnold_bosserman2]

Anyone familiar with the column engine string function replace_regexpr in a calculation view? I've looked in the SAP HANA Modeling Guide 2.0 SPS 04 and it is not documented there.

Syntax: replace_regexpr( stringpatttern, stringoption, stringsource, stringreplacement, intstartpos, intoccurrence)

Most of the parameters are self explanatory. I'm trying to get more definitive information on intoccurrence. If not 1, then it sometimes has issues. Is there a value here (like 0) that replaces all occurrences?

thanks in advance!

[shanthi_bhaskar]

check out this thread

https://answers.sap.com/questions/12867706/tryparse-in-calculated-column-of-calculation-view.html

[former_member216578]

The answer uses that function but the question was about the documentation and why that function is available in the modeling since it is not present in docs. Also in that answer there's just an application of the function to solve some task, not an explanation.