Hi Can some one please help me on the following. I have the following data , I only require the first letter after the 2nd dash if the letter is L or R or S and if the length of the characters after the second dash is 4
<colgroup><col><col></colgroup><tbody>
</tbody>
Data | Require |
BW1550T-NAV-L084 | L |
BW1550T-NAV-L089 | L |
BW1550T-NAV-R097 | R |
BW1550T-NAV-R102 | R |
BW1550T-NAV-S117 | S |
BW1550T-NAV-S122 | S |
CFPR180-CS | |
CFPR180-DM | |
CFPR180 | |
DTW1150-NAV-ZBULK | |
DTW1150-NAV-12 | |
DTW1150-NAV-14 | |
GFPR100-CS | |
GFPR100-DM | |
GFPR105-CS | |
GFPR105-DM | |
BW1550T-NAV-R097 | R |
BW1550T-NAV-S117 | S |
DS2166T1-O/N-AXXS | |
DS2166T1-O/N-BXS | |
DS2166T1-O/N-CS | |
DS2166T1-O/N-DM | |
DT1138T-NAV-R127 | R |
DT1138T-NAV-S087 | S |
DT1138T-NAV-S092 | S |
DT1138T-NAV-S097 | S |
DT1138T-NAV-S102 | S |
DT1138T-NAV-S107 | S |
<colgroup><col><col></colgroup><tbody>
</tbody>