Subtract from a range

[Shikhar_Tandon]

Hi all,
Require some help

My problem is suppose i have a range s A7 , i want to subtract 1 from it and obtain A6 can somebody help me in this
Thanks !!

@ppr @Palaniyappan @ClaytonM

[Arpit_Kesharwani]

@Shikhar_Tandon use the following expression in assign activity
A+(CInt(System.Text.RegularExpression.regex.match(colindex,“\d+” ))-1).ToString

[Shikhar_Tandon]

Thanks for the reply @Arpit_Kesharwani ,

Here colindex would be the index i suppose like 6 , 7 etc but i am getting the whole value like A7, A6 as input what to be done in that case
Thanks !

[Arpit_Kesharwani]

@Shikhar_Tandon colindex will be your variable containing A6 or A7

[Shikhar_Tandon]

there is an error saying System.Text.RegularExpression.regex.match cannot be converted to ineteger

[Arpit_Kesharwani]

@Shikhar_Tandon Sorry for late response. Please use the following into Assign activity. Earlier there was an error because of Match result not getting converted into String
“A”+(CInt(System.Text.RegularExpressions.Regex.Match(“A7”,“\d+” ).ToString)-1).ToString

another solution would be Split your cell address using regex then merge it again by incrementing index. Reference: How to pull out Regex groups in UiPath Seperately