Returns a string constructed by inserting a string into another string at a specified insertion point.
Format
STR_INSERT (Destination String, Source String, Insert Position)
Arguments
Destination String | Text string. |
Source String | Text string. |
Insert Position | Integer value noting the destination point in the string where the insertion is to occur. |
Examples
For the following function, blank spaces are needed in the Source String, before and after the text, in order to return the desired output:
Function | STR_INSERT ("That'sfolks", " all ", 7) |
Result | That's all folks |
As with the
STR_DELETE function, Insert Position can have any value, as shown in the following example:
Function | STR_INSERT ("A", "B", -10) |
Result | BA |