Extract Text After a Hyphen

[fsub]

Hi,

Sample data are INV-7-10-1234 and INV-7-10-12345. I'd like to print just the last digits after the last hyphen. In the example, I want my report to print 1234 and 12345 respectively. Any ideas is greatly appreciated.

 

[lbass]

stringvar array x := split({table.field},"-");
x[ubound(x)]

-LB

 

[Turkbear]

Hi,
Use the InStrRev and Mid functions:

Mid({YourField},InStrRev("-")+1)



To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[fsub]

Thanks Lbass and Turkbear. I had to add the field as the first argument in InStrRev. Otherwise, both codes worked like a gem.

 

[Turkbear]

Hi,
Sorry 'bout that - glad you caught it.





To Paraphrase:"The Help you get is proportional to the Help you give.."