greetings!
I am struggling with following case and I wonder if someone could help me to figure out the correct coding for this.
In the column expression node I’d like to define that only for numbers in the material column (which currently have a string format from the download), depending on the length, as much zeros are being adding in front so that the total digits equal to 18 digits.
For example:
Material (4 digits originally) -> 18 digits including preceding zeros
4303 -> should be converted to 000000000000004303
1330303 -> 000000000001330303
Hello ipazin,
thanks a lot for your hint. As I am not familiar with the coding by using padleft, would you mind sharing the coding structure if using this function?
function is available in String Manipulation and Column Expressions nodes. When you click on it you’ll see description together with examples on the left and it should all be clear