ying-hua opened a new issue, #10971:
URL: https://github.com/apache/inlong/issues/10971
### Description
- parent #10796
- INSERT(str, pos, len, newstr)
Returns the string str, with the substring beginning at position pos and len
characters long replaced by the string newstr. Returns the original string if
pos is not within the length of the string. Replaces the rest of the string
from position pos if len is not within the length of the rest of the string.
Returns NULL if any argument is NULL.
### Use case
- INSERT('12345678', 3, 4, 'word') = '12word78'
- INSERT('12345678', -1, 4, 'word') = '12345678'
- - INSERT('12345678', 3, 100, 'word') = '12word'
### Are you willing to submit PR?
- [X] Yes, I am willing to submit a PR!
### Code of Conduct
- [X] I agree to follow this project's [Code of
Conduct](https://www.apache.org/foundation/policies/conduct)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
