i have a excel with 2 columns, i took the 1st column from the datatable.
Now i want to take all those rows only from column 1 which full fills following condition:
The format of data in each row should be of type
i.e get the 1st 11(dfgdjgd) characters before the delimiter _
And then the 2nd set of string after underscore - here its ONE
after getting these 2 strings i have to put it to the Column C and column D respectively from all the rows from the Data table.
so far i have done till here
Please help me out