# otp.Operation.str.insert

### insert(start, length, value)

Returns a string where `length` characters have been deleted from string,
beginning at `start`, and where `value` has been inserted into string, beginning at `start`.

* **Parameters:**
  * **start** ([*int*](https://docs.python.org/3/library/functions.html#int) *or* [*Column*](../root.md#onetick.py.Column) *or* [*Operation*](../root.md#onetick.py.Operation)) -- Position to remove from and to insert into.
  * **length** ([*int*](https://docs.python.org/3/library/functions.html#int) *or* [*Column*](../root.md#onetick.py.Column) *or* [*Operation*](../root.md#onetick.py.Operation)) -- Number if characters to remove.
  * **value** ([*str*](https://docs.python.org/3/library/stdtypes.html#str) *or* [*Column*](../root.md#onetick.py.Column) *or* [*Operation*](../root.md#onetick.py.Operation)) -- String to insert.

### Examples

```pycon
>>> data = otp.Ticks(X=['aaaaaaa', 'bbbbb', 'cccc'], Y=['ddd', 'ee', 'f'])
>>> data['INSERTED_1'] = data['X'].str.insert(3, 1, 'X')
>>> data['INSERTED_2'] = data['X'].str.insert(3, 2, 'X')
>>> data['INSERTED_Y'] = data['X'].str.insert(3, 2, data['Y'])
>>> otp.run(data)
                     Time        X    Y INSERTED_1 INSERTED_2 INSERTED_Y
0 2003-12-01 00:00:00.000  aaaaaaa  ddd    aaXaaaa     aaXaaa   aadddaaa
1 2003-12-01 00:00:00.001    bbbbb   ee      bbXbb       bbXb      bbeeb
2 2003-12-01 00:00:00.002     cccc    f       ccXc        ccX        ccf
```

It is possible to insert without removal:

```pycon
>>> data = otp.Ticks(X=['aaaaaaa', 'bbbbb', 'cccc'])
>>> data['INSERTED'] = data['X'].str.insert(3, 0, 'X')
>>> otp.run(data)
                     Time        X  INSERTED
0 2003-12-01 00:00:00.000  aaaaaaa  aaXaaaaa
1 2003-12-01 00:00:00.001    bbbbb    bbXbbb
2 2003-12-01 00:00:00.002     cccc     ccXcc
```

It is possible to remove without insertion:

```pycon
>>> data = otp.Ticks(X=['aaaaaaa', 'bbbbb', 'cccc'])
>>> data['REMOVED'] = data['X'].str.insert(3, 2, '')
>>> otp.run(data)
                     Time        X REMOVED
0 2003-12-01 00:00:00.000  aaaaaaa   aaaaa
1 2003-12-01 00:00:00.001    bbbbb     bbb
2 2003-12-01 00:00:00.002     cccc      cc
```