need a help for column value

dataservices job design
1

Hi Freinds,
need a help to make requirement given below in bods
i have column value given below
abc-meer-abcd
abv-meer-abc-123

so i want only output like meer only

Thanks
Basha

meer.9700 (BOB member since 2017-12-27)

2

Is MEER always between ‘-’ and ‘-’. If so, you could use a multi-step process. In you first query transform use the substr and index functions to strip away everything up to and including the first ‘-’. In your second query transform use the same functions to get all data before the second ‘-’.

Nemesis :australia: (BOB member since 2004-06-09)

3

The Data Services function word_ext() can easily pick a value out of string when you are looking for a specific position.

eganjp :us: (BOB member since 2007-09-12)