I am running into issues trying to extract a value within a cell in Excel.
- I have 2 columns “OrderNumber” and “InvoiceNumber” in my datatable.
- if ordernumber doesn’t have any value,I need to extract it from my “InvoiceNumber” column
- the Invoice number is a concatenated value separated by hyphens as shown below. i need to extract the value after the last hyphen
- I am trying to use lastIndexof method but havent been successful so far.
Any help is greatly appreciated.