String Manipulation/Rule Engine

Hello everyone, everything good ?

I have a problem within my database, I would like your help.

I have two types of data, one being 00098 and the other 00101, I would like to remove the 000 and 00, can you tell me in a simple way how this would be possible? These numbers are always on the left.

I would like only 98 and 101 to remain


String to number node should do it. If necessary follow with Number to string.

1 Like

Alternatively, you could use the String Replacer with the Regular expression pattern 0*([0-9]+) and replacement text $1. This captures all numbers, except leading zeros (if there are any).

Use stringmanipulation node with toInt(your_column)

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