Keep characters between two positions
This function keeps all characters included in the defined interval, while the ones
outside the interval are removed.
| Option | Description |
|---|---|
| Extra parameter | This function requires two extra parameters. The extra parameters must be numbers, which are the start and the end values of the interval. |
In the first example, the first three characters are kept, while the other ones are removed.
In the second example, the second, third and fourth characters are kept, while the other ones are removed.
| Input value | Extra parameter | Example of a masked value |
|---|---|---|
| Jack | "1,3" | Jac |
| S1000D | "2,4" | 100 |