Cutting a String

[dinicholls]

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

[alexandros17]

try

Right(invoice_number_numeric, 😎

[PradeepReddy]

Try like this..

SubField(invoice_number_numeric,'-',3)

[anbu1984]

SubField(invoice_number_numeric,'-',-1) //-1 retrieves last field

[puttemans]

Hi,

Pradeeps solution seems to me the best one. add 'as InvoiceNo2' to it, and it should work in all instances.

[anbu1984]

Mid(invoice_number_numeric,Index(invoice_number_numeric,'-',2)+1,8) as InvoiceNo2