Skip to Content
0
Former Member
Jun 20, 2007 at 07:19 PM

Extract characters right of hyphen

14 Views

Hi all,

I'm trying to extract data from a field that contains hyphens. I want the data to the right of the hyphen only. This data can be different lengths.

Sample data:

0105-GROC

0890-PHARMA

In the above samples, I want to extract GROC in the first, PHARMA in the second.

Any suggestions?

Thanks

Charla