Hi!! Knime Experts…
I am facing some issue in following logic(in pic)…
Requirement;
Remove “0” from batch
Batch no.
00AASD1456 (2 times -“0”)
0QWER4897 ( time1-“0”)
000ALPH789 (3 times-“0”)
12345899
EAN0778
HHT0004
Required Output:
Batch no.
AASD1456
QWER4897
ALPH789
12345899
EAN0778
HHT0004
I have applied this formula:
But I am getting Output as;
Batch no.
AASD1456
QWER4897
ALPH789
12345899
EAN778(issue-removing zero after alphabets)
HHT4(issue-removing zero after alphabets)
I just want to remove n-number of “0” if it’s coming before Alphabtes…
Please guide…
Thanks in advance