How to extract text between two words in oracle?

by elise_daugherty , in category: MySQL , a month ago

How to extract text between two words in oracle?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

by lindsey.homenick , 25 days ago

@elise_daugherty 

You can extract text between two words in Oracle using the REGEXP_SUBSTR function. Here's an example of how you can use this function to extract text between two words:

1
2
SELECT REGEXP_SUBSTR(column_name, 'word1(.*?)word2', 1, 1, NULL, 1) AS extracted_text
FROM table_name;


In this query:

  • column_name is the column from which you want to extract text.
  • word1 and word2 are the words between which you want to extract text.
  • The regular expression 'word1(.*?)word2' specifies that you want to extract any text between word1 and word2.
  • The parameters 1, 1, NULL, 1 specify that you want to start searching from the beginning of the string and extract the first occurrence of the pattern.


You can adjust the regular expression and parameters based on your specific requirements.