Hello Community, good day.
I am very new and hope for some advise
I am reading a csv to a table and then processing it with a for each row in “table” loop.
This works fine.
Now I have a problem in the source. Excel converts “002” in “2” and kills the precending two zeroes.
The column name is “Number”
I am inputting the data for each row in a field. The expression I use is : row(“Number”).ToString
Unfortunately I need to check the length before. The length must be 3.
In case length is 1 then it needs to add 2 x zero before the string value
In case length is 2 then it needs to add 1 x zero before the string value
Anyone here that can help a nOOb ?