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.
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.