excel - How to extract data from one cell to another -

given spreadsheet cell containing string consists of hyphenated series of character segments, need extract fourth segment.

for example, consider column containing data strings xx-xxx-x-g10-xx-xxx, x denotes character. formula need place in column b g10 result?

                           b 1   xx-xxx-x-g10-xx-xxx      g10 

i'm looking formula work in in libre office calc, open office calc, ms excel, or google sheets.

it simple... mid right function:

=mid(a1;10;3)

where:

• a1 data
• 10 start 10 character - in case g
• 3 range of characters count 10 (10, 11, 12)

pros:

• simple

cons:

• work constant strings