# string manipulation error

**URL:** <https://forum.knime.com/t/string-manipulation-error/6131>\
**Category:** KNIME Analytics Platform\
**Created:** [April 8, 2017, 5:07pm UTC](https://forum.knime.com/t/string-manipulation-error/6131 "2017-04-08T17:07:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![micheljanos](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/m/aeb1de/32.png) [@micheljanos](https://forum.knime.com/u/micheljanos)\
**Post date:** [April 8, 2017, 5:07pm UTC](https://forum.knime.com/t/string-manipulation-error/6131/1 "2017-04-08T17:07:00Z")

</div>

Hi,

I have one column with churn data (Bin1, Bit2) meaning "0" and '1". When I try to change the strings names (Bin1, Bit2) to "0" and '1" it gives me a **syntax error " insert";" to complete BlockStatetment".** When I only make the renaming transformation from Bin1 to "0" it does correctly but it also transforms Bin2 to "02" (see attached sceenshot)

&nbsp;

Michel

- [capturar.png](https://www.knime.com/sites/default/files/capturar_0.png)

---

<div class="post-metadata">

**Author:** ![rchar01](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/8e8cbc/32.png) [@rchar01](https://forum.knime.com/u/rchar01)\
**Post date:** [April 8, 2017, 8:53pm UTC](https://forum.knime.com/t/string-manipulation-error/6131/2 "2017-04-08T20:53:26Z")

</div>

Hello,

if you want to use String Manipulation Node, you can take one replace statement and nested it within another replace statement:

replace(replace($ChurnIndicator\_Binned$, "Bin1", "1"), "Bin2", "0")

&nbsp;

---

<div class="post-metadata">

**Author:** ![micheljanos](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/m/aeb1de/32.png) [@micheljanos](https://forum.knime.com/u/micheljanos)\
**Post date:** [April 8, 2017, 10:33pm UTC](https://forum.knime.com/t/string-manipulation-error/6131/3 "2017-04-08T22:33:02Z")

</div>

It worked.

&nbsp;

thanks

---

<div class="post-metadata">

**Author:** ![DoreKim](https://forum-cdn.knime.com/user_avatar/forum.knime.com/dorekim/32/45549_2.png) [@DoreKim](https://forum.knime.com/u/DoreKim)\
**Post date:** [October 1, 2022, 11:12pm UTC](https://forum.knime.com/t/string-manipulation-error/6131/4 "2022-10-01T23:12:10Z")

</div>

@rchar01 it’s work, but, there is other way?

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [June 23, 2023, 8:22pm UTC](https://forum.knime.com/t/string-manipulation-error/6131/5 "2023-06-23T20:22:53Z")

</div>