Hi,
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.
![image](https://global.discourse-cdn.com/uipath/original/3X/b/6/b63d047d81b2a02f40d1ad27ce0e7df1dad0f393.png)