Incrementing the value

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.

@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

2 Likes

Thanks @Arpit_Kesharwani i will check this.

Thanks @Arpit_Kesharwani it’s working.

1 Like

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