My input should be in this format “AT_10JAN(1)”
AT_10JAN(2) and so on depending how many times I loop the number in bracket should increment. Can anyone help me with this?
Thankyou
You can use an integer variable as counter and use that to form this value inside the Loop
This would do the job
System.Text.RegularExpressions.Regex.Replace(YourStringVar,"(?<=\()\d+(?=\))",Function (m) (CInt(m.value)+1).toString)
Save a string into string variable (str) as "AT_10Jan(x)"
Now in the for loop properties you will have a index peoperty…assign a int32 variable to it…
Now in your loop use str.Replace("x",(index+1).Tostring)
Hope this helps
Cheers