How to remove character in the middle of the string

[Vincent_Nuestro]

hi Good Day,

how to remove character in the middle of the string inside datatable

I need to remove “0” after AP

Expected Output
AP77003
AP77027
AP77058

Thank you in advance
-VIncent

[Manish540 (Manish Shettigar)]

Hi @Vincent_Nuestro ,

Read your file and loop your datatable in for each and inside the loop in assign activity,
Use this below expression,
row("Your Ref") = New Regex("0").Replace(row("Your Ref").ToString.Trim, "",1)

Hope this helps

[jack.chan]

do this @Vincent_Nuestro
System.Text.RegularExpressions.Regex.Replace("AP0132409","[A-Z]{2}([0])","")

[Vincent_Nuestro]

hi @Manish540

[Manish540 (Manish Shettigar)]

@Manish540

New Regex(“0”).Replace(row(“Your Ref”).ToString.Trim, “”,1)

Hi @Vincent_Nuestro ,

Try this below expression and let us know,
New System.Text.RegularExpressions.Regex("0").Replace(CurrentRow(2).ToString.Trim, "",1)