Specific data from column

In a data table, I hv a column assigned to. Sometime it gets data ‘assigned to @finance’ or sometimes it’s like ‘assiged to @DAteam for analysis’. I just want to get department name. How to get it?

1 Like

@gaurav2000

You can use lile this

Use a loop…

And inside loop use currentrow("ColumnNam”).ToString will give the total string lets say for now str then

System.Text.RegularExpressions.Regex.Match(str,"(?<=@)\w*").Value will give you the required value

Hope this helps

Cheers

1 Like

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