# Converting string to integer

**URL:** <https://forum.knime.com/t/converting-string-to-integer/482>\
**Category:** KNIME Analytics Platform\
**Created:** [June 15, 2009, 3:43pm UTC](https://forum.knime.com/t/converting-string-to-integer/482 "2009-06-15T15:43:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![walsh](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/w/67e7ee/32.png) [@walsh](https://forum.knime.com/u/walsh)\
**Post date:** [June 15, 2009, 3:43pm UTC](https://forum.knime.com/t/converting-string-to-integer/482/1 "2009-06-15T15:43:27Z")

</div>

I’ve used the ‘String to Number’ node to convert strings that look like ‘08’ to ‘8’. The problem is that I can’t find a way to make the node convert it to an integer type. When I later use the ‘Column Combiner’ node to join this new column with another, I get values that look like ‘A8.0’, whereas what I want is ‘A8’. Is there a way to convert either string or numeric to integer?

Thanks a lot,

Andrew

---

<div class="post-metadata">

**Author:** ![gabriel](https://forum-cdn.knime.com/user_avatar/forum.knime.com/gabriel/32/61386_2.png) [@gabriel](https://forum.knime.com/u/gabriel)\
**Post date:** [June 15, 2009, 5:05pm UTC](https://forum.knime.com/t/converting-string-to-integer/482/2 "2009-06-15T17:05:47Z")

</div>

Hi Andrew,  
We have this new feature already on our wish list, and its importance is constantly increasing… In the meantime, you can only use the Java Snippet node using

`return Integer.parseInt($your_string_column$);`

and you can even append string values in the same run, i.e.

`return “A” + Integer.parseInt($your_string_column$);`

Best, Thomas

---

<div class="post-metadata">

**Author:** ![walsh](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/w/67e7ee/32.png) [@walsh](https://forum.knime.com/u/walsh)\
**Post date:** [June 16, 2009, 11:26am UTC](https://forum.knime.com/t/converting-string-to-integer/482/3 "2009-06-16T11:26:06Z")

</div>

Thank you, Thomas, I will try this out.

---

<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:14pm UTC](https://forum.knime.com/t/converting-string-to-integer/482/4 "2023-06-23T20:14:50Z")

</div>


