Extract everything after the nth occurrence of a character

Viewed 36

In SQL Server 2017 I have a string like

GSLO¥10-00950000207406¥61500¥CRS15596859¥20220714153630¥2022-07-14¥¥¥¥¥¥¥63031¥0¥¥79087¥6793¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥¥

and I would like to extract everything after the 11th appearence of the special character ¥. In Oracle I can use regexp_substr(). What is the equivalent in SQL Server?

0 Answers
Related