Hi, I need to extract text between asterisk. I’ve used:
REGEXP_EXTRACT(Field , ‘[^]+[^]’)
And the result is..
FIELD: EXTRACTION:
OK! text_to_extract1_anything_else text_to_extract
OK! text_to_extract2_anything_else text_to_extract
OK! text_to_extract_3_anything_else text_to_extract
Mistake text_before_asterisk_text_to_extract4_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!!!