Remove Space and Prefix from string

Couchbase Server
1

I want to remove space and - from my string.
And if string stated with 88 then i want to remove starting (prefix) 88 from string .
If 88 is in between the string then it should not remove . only i w.ant to remove prefix

Please help me out
thanks in advance,

2

You can use any string functions https://docs.couchbase.com/server/current/n1ql/n1ql-language-reference/stringfun.html#fn-str-contains
LTRIM, POSITION, SUBSTR, REPLACE