You can translate the question and the replies:

Reply to my another question - How to use 3 parameters in 'instr' function?

Hi DENODO Team, I need to read the given string in reverse order ( from reverse position). STRING: ‘abcd-E3/FGHIJ:KL-MNOP-QRST’ As per your last reply answer, I will get the 1st position of symbol ‘-‘, which is 4 SELECT INSTR(SUBSTR(‘abcd-E3/FGHIJ:KL-MNOP-QRST’, 1), ‘-‘) from dual(); Whereas I need the last position of symbol ‘-‘,which is 21. Based on the position result, i will again apply SUBSTRING and retreive the characters of that string (like 21-1 = 20 - 1st 20 characters from the given string) Expected Result: i need ‘abcd-E3/FGHIJ:KL-MNOP’ from ‘abcd-E3/FGHIJ:KL-MNOP-QRST’ Using your answer, I will get ‘abcd’ from ‘abcd-E3/FGHIJ:KL-MNOP-QRST’ SELECT SUBSTR(‘abcd-E3/FGHIJ:KL-MNOP-QRST’, 1,(INSTR(SUBSTR(‘abcd-E3/FGHIJ:KL-MNOP-QRST’, 1), ‘-‘)+1)-1) from dual();
INSTR
user
21-04-2021 14:08:42 -0400
code

1 Answer

Hi, This appears to be a duplicate question of [How to use 3 parameters in 'instr' function](https://community.denodo.com/answers/question/details?questionId=9064u000000L8BjAAK&title=How+to+use+3+parameters+in+%27instr%27+function) You can follow the latest updates on the original question. Hope this helps!
Denodo Team
21-04-2021 21:01:42 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here