I have a table with 2 columns as below
If you see under TEXTVAL column highlighted is "Verfied:Y" for ID 10. Similarly "Verified:Z" and "Verified:YN" for 20 and 30.
I am trying to extarct only the value as Y,N,YN.
When i do substrt i can get the begging position but i am unable to provide extarct till you find '|' after value "Verified:". I had query like below
SyntaxEditor Code Snippet
select substr(VARVALUE,INSTR(VARVALUE,'Verified:')+9, ??? )
Here the end position is where i am not sure how to provide it.
Can you please help me here.
You should switch to a regular expression:
This looks for 'Verified:' and extracts the following characters until the next '|'.