# Stirng manipulation

**URL:** <https://forum.knime.com/t/stirng-manipulation/91905>\
**Category:** KNIME Analytics Platform\
**Created:** [May 8, 2026, 1:36pm UTC](https://forum.knime.com/t/stirng-manipulation/91905 "2026-05-08T13:36:13Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gabriel2020](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/g/ee59a6/32.png) [@Gabriel2020](https://forum.knime.com/u/Gabriel2020)\
**Post date:** [May 8, 2026, 1:36pm UTC](https://forum.knime.com/t/stirng-manipulation/91905/1 "2026-05-08T13:36:13Z")

</div>

Good morning everyone, how are you?

It’s been a while, haha. I was out of the corporate world for a while, so I ended up not using Knime as much and forgot some simple functions that I used very frequently.

Well, I have a database that shows me the times the ticket was opened. Basically, I want to add a condition saying that if the value is between 7 am and 12 pm, it should be included as a morning, for example.

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

---

<div class="post-metadata">

**Author:** ![rfeigel](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/7ea924/32.png) [@rfeigel](https://forum.knime.com/u/rfeigel)\
**Post date:** [May 8, 2026, 1:57pm UTC](https://forum.knime.com/t/stirng-manipulation/91905/2 "2026-05-08T13:57:51Z")

</div>

You can use a Rule Engine node.  
[Assign AM PM Based on Hours.knwf](https://forum.knime.com/uploads/short-url/onDMwbkA1Nz3DwHl2rrpRJvnCRQ.knwf) (61.0 KB)

 ![Workflow](https://forum-cdn.knime.com/uploads/default/original/3X/b/2/b2c966fccedbff7230c60421fe7b694b6faad6a4.jpeg)  
 ![Output](https://forum-cdn.knime.com/uploads/default/original/3X/1/c/1c4cfe365e7761425622cbbf50c7a5f0fa500c5e.jpeg)

---

<div class="post-metadata">

**Author:** ![gonhaddock](https://forum-cdn.knime.com/user_avatar/forum.knime.com/gonhaddock/32/35425_2.png) [@gonhaddock](https://forum.knime.com/u/gonhaddock)\
**Post date:** [May 11, 2026, 9:07am UTC](https://forum.knime.com/t/stirng-manipulation/91905/3 "2026-05-11T09:07:59Z")

</div>

Hello @Gabriel2020  
You can test to code ‘String Manipulation’ node as follows:

`string(toBoolean(toInt($Ticket Created - Hour$) >= 7)).equals(“true”) &&`  
` string(toBoolean(toInt($Ticket Created - Hour$) <= 12)).equals(“true”)`  
` ? “morning”`  
` : “other”`

BR

---

<div class="post-metadata">

**Author:** ![Gabriel2020](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/g/ee59a6/32.png) [@Gabriel2020](https://forum.knime.com/u/Gabriel2020)\
**Post date:** [May 13, 2026, 11:12am UTC](https://forum.knime.com/t/stirng-manipulation/91905/4 "2026-05-13T11:12:39Z")

</div>

![image](https://forum-cdn.knime.com/uploads/default/original/3X/f/6/f626d68120214c0ffcc79ce944edcde86a1df8ef.png)

---

<div class="post-metadata">

**Author:** ![gonhaddock](https://forum-cdn.knime.com/user_avatar/forum.knime.com/gonhaddock/32/35425_2.png) [@gonhaddock](https://forum.knime.com/u/gonhaddock)\
**Post date:** [May 13, 2026, 12:21pm UTC](https://forum.knime.com/t/stirng-manipulation/91905/5 "2026-05-13T12:21:50Z")

</div>

Hi @Gabriel2020

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/d/7/d7d06ceeaeabec01bb7a65c13a12a656bb3715d6.png)

Check your input row 66 to see the exception.  
You can test with: ‘Insert Missing as Null‘ check box, share a sample of the data…

BR

---

<div class="post-metadata">

**Author:** ![takbb](https://forum-cdn.knime.com/user_avatar/forum.knime.com/takbb/32/57077_2.png) [@takbb](https://forum.knime.com/u/takbb)\
**Post date:** [May 16, 2026, 8:49am UTC](https://forum.knime.com/t/stirng-manipulation/91905/6 "2026-05-16T08:49:49Z")

</div>

Hi @Gabriel2020 , the syntax error will most likely be because the code contains double quotes that have been modified when they were posted to the forum.

Retype the double quotes so instead of appearing as

“… “  
They appear as

```auto
"..."

```

---

<div class="post-metadata">

**Author:** ![rfeigel](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/r/7ea924/32.png) [@rfeigel](https://forum.knime.com/u/rfeigel)\
**Post date:** [May 16, 2026, 7:11pm UTC](https://forum.knime.com/t/stirng-manipulation/91905/7 "2026-05-16T19:11:21Z")

</div>

Curious why you insist on using a String Manipulation node. My workflow works and is much simpler.

---

<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:** [August 14, 2026, 7:11pm UTC](https://forum.knime.com/t/stirng-manipulation/91905/8 "2026-08-14T19:11:32Z")

</div>

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