I am trying to loop through a DT and write data into a newly created column.
- I use table data scraping to obtain data that looks like this
Column-3 Column-4 Action Summary
Appointment Pending David Trump (Tump-D) as Director
Appointment Pending Griffiths (GRIFFITH-O_1) as Director
- I then add a new col to the data table called DirectorID
- then loop through DT and use RegEx to find the text between ( )
However I cant figure out how to write my newly created DirectorID into the column for the right row