For a project using the REFramework, I have a TransactionItem which is of type datarow.
The row in question comes from a datatable which contains 2 columns: “ID” & “Date”.
The issue is that the ID column contains the first letter of the first name a dot and then the last name while, I’m just looking to get the Firstname. I have another excel file which contains the columns “FirstName” & “ID”.
So what I’m trying to do is to get the FirstName from the excel file for the row where the “ID” is equal to TransactionItem(“ID”).
I’ve tried a couple of things so far but nothing worked so far and I’m getting really confused any help would be greatly appreciated.