Extract Arabic words using regexp
Summary
I want to extract arabic words from a text.Content
SELECT
'<pre class="tw-data-text tw-ta tw-text-medium" data-placeholder="Translation" id="tw-target-text" data-fulltext="" dir="rtl" style="text-align: left; unicode-bidi: isolate; background-color: rgb(255, 255, 255); border: none; padding: 0px 0.14em 0px 0px; position: relative; margin-top: 0px; margin-bottom: 0px; resize: none; font-family: inherit; overflow: hidden; width: 255px; white-space: pre-wrap; overflow-wrap: break-word; color: rgb(33, 33, 33); height: 36px; font-size: 25px !important; line-height: 36px !important;"><span tabindex="0" lang="ar">بطارية ريناتا</span></pre>'
FROM DUAL
We need to extract only 'بطارية ريناتا' arabic words from this using regexp. How do we achieve it? Is there any other way to extract it.
Tagged:
0