Delete cell values if a paticular value present

Hai Guys,
In a column we have R series with numbers but i want only after 0 numbers only.
ui

@Arjun_Reddy What do you mean by After Zero Numbers only :sweat_smile:

Hi @Arjun_Reddy

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?

Hi @Krishna_547
it is working,
but if the value like this" R001302"
it is showing “13” only.
can u please help on this.
thank you

hai @supermanPunch
i have shown in the picture. left column what i have and right column what i want.
thank you

Hi @Arjun_Reddy

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

5 Likes

ya its working @Krishna_547
ya i will mark.
thank you

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.