Keep characters between two positions
This function keeps all characters included in the defined interval, while the ones
outside the interval are removed.
When you use this function, you must define two extra parameters which are the number corresponding to the start and the end values of the interval.
The following table shows examples of masked values depending on the input value and the extra parameter.
| Input value | Extra parameter | Example of a masked value | Details |
|---|---|---|---|
| Jack | "1,3" | Jac | The first three characters are kept, while the other ones are removed. |
| S1000D | "2,4" | 100 | The second, third, and fourth characters are kept, while the other ones are removed. |