Extract Text from Field

[Anonymous]

Hello,

I have a list of SKU numbers and descriptions like the following:

567 - MICROWAVE 6 1/2 C

How would I extract everything after the hyphen?

Thanks!

Isabel

[eduardo_sommer]

Hi

subfield(SKU, '-',2)

eduardo

[venkatg6759]

Use subfield funcion

Subfield(ltrim(Right(Replace(SKU),'-',' '),3))

[Anonymous]

Hello,

Thanks!

What if I were to have something like

4576 - Flower Pot - Misc

and want everything after the first hyphen?

Isabel

[eduardo_sommer]

This should work

=right(SKU,index(SKU,' - ',-1))

Eduardo

[Anonymous]

Hmm..that doesn't work in every case. It usually only gives me everything after the last hyphen.

[maxgro]

everything after first hyphen

=right(SKU,  len(SKU - index(SKU, '-', 1))

everything after last hyphen

=right(SKU,  len(SKU - index(SKU, '-', -1))

[swuehl]

Or a little shorter using mid() function:

=mid(SKU,  index(SKU, '-', 1)+1)