i have a curentRow(“DFF”) that contain number with this format 1.2.3.4
i need to split the numbers to be set into 4 different variables lets say they names (FirstNumber. SecondNumber, thirdNmumber and fourthNumber).
to be able to print the numbers individually.
so after this i need when i use message box for FirstNumber variable will print 1 and the same for all numbers in the column.
also put in mind that the number will some times will be like this 1…3.4 which is the second number is null. so when i use message box to print the second variable it will print it as null.
thanks in advance
You can split the & assign like this
currentRow("DFF").ToString().Split("."c)
NumSplit is the array of string variable
Hope this helps
this worked fine until it came to the final line which is contain number like this 1…
this nuber should be reded like this
1-“1”
2- “null”
3-“null”
4-“null”
but it gives me this error
Test digit ectraction - Copy.xaml (16.3 KB)
GL Template.xlsx (11.3 KB)
forget about my previous replay this work fine thank you very much for your support.
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.