extract text between asterisk

[dwender]

Hi, I need to extract text between asterisk. I’ve used:

REGEXP_EXTRACT(Field , '[^*]+[^*]')

And the result is..

               FIELD:                                                                                                                       EXTRACTION:
OK!                      *text_to_extract*_1_anything_else_                                                       text_to_extract

OK!                      *text_to_extract*_2_anything_else_                                                       text_to_extract

OK!                      *text_to_extract*_3_anything_else                                                         text_to_extract

Mistake               text_before_asterisk_*text_to_extract*_4_anything_else_                text_before_asterisk_

The expression works but not at the last line, where is getting the text before the asterisk, not between them…

Some idea to do that?

Thanks!!!