# string manipulation

**URL:** <https://forum.knime.com/t/string-manipulation/25568>\
**Category:** KNIME Analytics Platform\
**Created:** [July 30, 2020, 3:21pm UTC](https://forum.knime.com/t/string-manipulation/25568 "2020-07-30T15:21:52Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![sahil786](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/e480ec/32.png) [@sahil786](https://forum.knime.com/u/sahil786)\
**Post date:** [July 30, 2020, 3:21pm UTC](https://forum.knime.com/t/string-manipulation/25568/1 "2020-07-30T15:21:52Z")

</div>

Hi All,

If my input file contain 100 fields and i want to write different transformation logic for each field den do i need to apply string manipulation node 100 times.I have seen the option of string manipulation( multi column) in version 4.2.0 but it will select those 100 field and apply the same logic.but i need to write different logic to each field.Kindly suggest.I am trying to implement below logic(as of now for 2 fields) but it is throwing error.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/1/3/1338b9fa0535d1c108ef60ad689872eb7f8e0532.png)

---

<div class="post-metadata">

**Author:** ![izaychik63](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/i/e9a140/32.png) [@izaychik63](https://forum.knime.com/u/izaychik63)\
**Post date:** [July 30, 2020, 3:32pm UTC](https://forum.knime.com/t/string-manipulation/25568/2 "2020-07-30T15:32:00Z")

</div>

Use Column Expression node.

---

<div class="post-metadata">

**Author:** ![sahil786](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/e480ec/32.png) [@sahil786](https://forum.knime.com/u/sahil786)\
**Post date:** [July 30, 2020, 3:44pm UTC](https://forum.knime.com/t/string-manipulation/25568/3 "2020-07-30T15:44:58Z")

</div>

> [@izaychik63](#):
>
> Column Expression

can see column expression node

![image](https://forum-cdn.knime.com/uploads/default/original/3X/5/1/51f8255d93719e7f293366d820bab90b08f109d2.png)

---

<div class="post-metadata">

**Author:** ![izaychik63](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/i/e9a140/32.png) [@izaychik63](https://forum.knime.com/u/izaychik63)\
**Post date:** [July 30, 2020, 3:49pm UTC](https://forum.knime.com/t/string-manipulation/25568/4 "2020-07-30T15:49:49Z")

</div>

You need to install it from

> **[Column Expressions](https://hub.knime.com/knime/extensions/org.knime.features.expressions/latest/org.knime.expressions.base.node.formulas.FormulasNodeFactory)**
>
> This node provides the possibility to append an arbitrary number of columns or modify existing columns using expressions. For each column that shall be appende…

  
or  

> **[Column Expressions — NodePit](https://nodepit.com/node/org.knime.expressions.base.node.formulas.FormulasNodeFactory)**
>
> Append and modify columns using expressions.

---

<div class="post-metadata">

**Author:** ![AnotherFraudUser](https://forum-cdn.knime.com/user_avatar/forum.knime.com/anotherfrauduser/32/16912_2.png) [@AnotherFraudUser](https://forum.knime.com/u/AnotherFraudUser)\
**Post date:** [July 30, 2020, 4:07pm UTC](https://forum.knime.com/t/string-manipulation/25568/5 "2020-07-30T16:07:13Z")

</div>

Hi @sahil786,

you can add this through  
 ![grafik](https://forum-cdn.knime.com/uploads/default/original/3X/9/6/96795763a7ca0575de14b5367b75a03f5c12c992.png)

 ![grafik](https://forum-cdn.knime.com/uploads/default/original/3X/d/f/df9f096caeb3f6426b52cdac30538cf60b0912df.png)  
(  
or at least one of the Knime Labs extensions - it is great either way to check what expensions can be added - normally I add everything which sounds remotely interesting 🙂  
)

---

<div class="post-metadata">

**Author:** ![sahil786](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/e480ec/32.png) [@sahil786](https://forum.knime.com/u/sahil786)\
**Post date:** [July 30, 2020, 5:37pm UTC](https://forum.knime.com/t/string-manipulation/25568/6 "2020-07-30T17:37:58Z")

</div>

Thank u …It is working for me

---

<div class="post-metadata">

**Author:** ![AnotherFraudUser](https://forum-cdn.knime.com/user_avatar/forum.knime.com/anotherfrauduser/32/16912_2.png) [@AnotherFraudUser](https://forum.knime.com/u/AnotherFraudUser)\
**Post date:** [July 30, 2020, 5:42pm UTC](https://forum.knime.com/t/string-manipulation/25568/7 "2020-07-30T17:42:58Z")

</div>

great! if there are any questions then do not hestitate to ask 😛

---

<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:** [February 5, 2021, 5:28pm UTC](https://forum.knime.com/t/string-manipulation/25568/9 "2021-02-05T17:28:13Z")

</div>

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.