Regex to test if strings exist in a string to match

[ptrobot]

Then the For Each loop I posted previously will give you what you want. Please test it.

[RajivKumar12 (Rajiv Kumar)]

It works Sir thanks . Just really really last question Sir , how do we rename a specific column inside in a for each loop ? for example I wanted to rename col.ColumnName which value is “Test” and rename to “Test2” for example. Thanks

[RajivKumar12 (Rajiv Kumar)]

So when I check the Dynamic_DT.Columns again that column is already renamed.

[ptrobot]

I didn’t get if you figured it out or not. But just to be clear, use an Assign activity with col.ColumnName = “Test2”.

If col.ColumnName = "Test" Then
    col.ColumnName = "Test2"