Hi Knime Experts!! Hope you all are doing well. Just need your help in filtering out certain rows: Bascially i am having data as follows: Input data: 9852 9875 7393.32- 410.74- 821.48- 4928.88- 1232.22- 1232.22- 410.74- 12732.94- 11500.72- 6571.84- 1642.96- 1642.96- 2875.18- 1642.96- 6571.84- 3696.66- 3285.92- 1642.96- 2464.44- 9036.28- 1642.96- 4107.40- 3696.66- 2875.18- 4518.14- 18894.04- 821.48- 2875.18- 2053.70- 821.48- 3696.66- 410.74- 3285.92- 2053.70- 3696.66- 4518.14- 1232.22- I just want to bring “-” sign ahead of digits. Output: 9852 9875 -7393.32 -410.74 -821.48 -4928.88 -1232.22 -1232.22 -410.74 -12732.94 -11500.72 -6571.84 -1642.96 -1642.96 -2875.18 -1642.96 -6571.84 -3696.66 -3285.92 -1642.96 -2464.44 -9036.28 -1642.96 -4107.4 -3696.66 -2875.18 -4518.14 -18894.04 -821.48 -2875.18 -2053.7 -821.48 -3696.66 -410.74 -3285.92 -2053.7 -3696.66 -4518.14 -1232.22 Thanks, Ravi

Hello @ravi13 , see here for one node regex solution: [image] Formatting negative values on the right KNIME Analytics Platform Hi everybody, I am running a txt file that has negative values with minus sign on the right such as: 717,31 717,31- 216,55 216,55- 244,19 244,19- 10,58 10,58- The column is a string and it seems I can’t turn it into a number’s one. How can I move the sign on the left and turn into numbers? Thanks a lot Br, Ivan

Row Filter

KNIME Analytics Platform

ipazin October 26, 2020, 2:08pm 3

Hello @ravi13,

see here for one node regex solution:

Br,
Ivan

2 Likes