title: remove leading zeroes from a string / varchar in spark scala
body: <p>I have a variable (23 bytes varchar) that has values with leading zeroes (ex: &quot;0000000036754678&quot;). How to remove the leading zeroes from this variable.</p>