Hello, experts. I have a variable text, that contains string '%let blablabla select * from tablename where blablabla; asdsad'. And i want to cut all before word 'select' and after first semicolon. I try next statements: %let text2 = %scan(%nrbquote(&text), 1, %str(; )); %let ind = %index(%qupcase(&text2), SELECT); %let cut_text = %substr(%nrbquote(&text2), &ind); And after %scan function my variable text2 contains nothing judging by log. If i try another string in text (for example '%%asd select ...;') it works, but with %let at start doesn't. Which function have i to use instead %nrbquote and %scan? Help me plz)
... View more
