Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I'm trying to get the last bit of a string out, but I'm not doing it right!
This is my string and couple of examples:
100-ARINVK-13296910
029-ARINV-10816695
I need to get the numbers after the second '-'. So in the example above, this would be:
13296910
10816695
I've tried this:
Mid(Index("invoice_number_numeric",'-',2),8) | as InvoiceNo2 |
But it's not pulling it through.
What am I doing wrong?
I'm a newbie to this, so any help is appreciated!
Di
try
Right(invoice_number_numeric, 😎
Try like this..
SubField(invoice_number_numeric,'-',3)
SubField(invoice_number_numeric,'-',-1) //-1 retrieves last field
Hi,
Pradeeps solution seems to me the best one. add 'as InvoiceNo2' to it, and it should work in all instances.
Mid(invoice_number_numeric,Index(invoice_number_numeric,'-',2)+1,8) as InvoiceNo2