I am facing a issue while assigning a variable with leading zeros to a column value in data table.
Below are the steps
in For Each Row in Dt1
For example: Var1 = 0068 ( reading from Database)
Assign row(“Column8”) = Var1
Var1 (68) is getting assigned to Column8 in DT1. I am not getting leading zeros.
I tried padding but its not working. Can you help me?
You have it as an integer value. That won’t keep the leading 0s because 0068 is really just 68 in terms of numbers. If you want to keep the leading 0s, make the column a string.
is it possible to add any character, symbol or combination of any text before the leading zero? That will prevent the conversion of that to absolute value? Just a thought…