Hi @arkiboys ,
we can use ltrim(stringcolumnname,'0')
Please check the below image, on right hand side you see my original values and left hand side trimmed values. Hope it helps. Let us know how it goes,
Thanks
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
How is it possible to remove the beginning 0 values from a string in dataflow?
for example:
43255
5656poppp
00005443
008787
...
It should give:
43255
5656poppp
5443
8787
...
Thank you
Hi @arkiboys ,
we can use ltrim(stringcolumnname,'0')
Please check the below image, on right hand side you see my original values and left hand side trimmed values. Hope it helps. Let us know how it goes,
Thanks
Hi @arkiboys , using length function and substring function should get you there, something along the lines below for example:
@substring('helloworld',0,sub(length('helloworld'),3)) Thanks