Specific data from column

[gaurav2000 (Gaurav Mehra)]

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?

[Anil_G]

@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