In a column we have R series with numbers but i want only after 0 numbers only.
@Arjun_Reddy What do you mean by After Zero Numbers only
for each row in DataTable :
Number = system.Text.RegularExpressions.Regex.Match(row(“Column”).tostring,"[1-9]+").Value
In “Number” , you can have only the number after the Zeros
greater than 0 only
@Arjun_Reddy If possible, Can you Show Input Excel File and the Output Excel you Expect?
it is working,
but if the value like this" R001302"
it is showing “13” only.
can u please help on this.
i have shown in the picture. left column what i have and right column what i want.
Modify the REGEX as shown below
Number = system.Text.RegularExpressions.Regex.Match(row(“Column”).tostring,"[1-9]+[0-9]*").Value
Mark As solution . If it is working
ya its working @Krishna_547
ya i will mark.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.