Incrementing the value

Learning Hub Academy Feedback
, , , , ,
1

Hi everyone, i have a scenario that i have number i need to increment that number based on previous number.

ex : ABI043 this is the number , I need to increment it to ABI044.

I’m using this in my current project i’m scraping the number (ABI043) from SAP, and i need to increment the number to (ABI044) and i need to write it in SAP. Can anyone help me how to solve it.

2

@ranaprathap928 Use below Regular expression in Assign activity to get the incremented String

System.Text.RegularExpressions.Regex.Match(“ABI043”,“[A-Z0]+”).Value.Trim+(CInt(System.Text.RegularExpressions.Regex.Match(“ABI043”,“\d{1,3}”).Value.Trim)+1).ToString

image
image1093×437 20.2 KB

3

Thanks @Arpit_Kesharwani i will check this.

4

Thanks @Arpit_Kesharwani it’s working.