I want to get date in specific formt

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?



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