How to parse a string
Hi, I have a file name that has multiple nodes, I want to get the file extension after the last '.'.
How do I do this?
Software/Hardware used:
Software/Hardware used:
ASKED:
August 21, 2008 8:06 PM
UPDATED:
August 22, 2008 9:42 AM
Answer Wiki:
Use INSTR
DECLARE
v_pos NUMBER;
v_string VARCHAR2(20) := 'abc.123.txt';
v_file_type VARCHAR2(20);
BEGIN
v_pos := INSTR(v_string, '.', -1);
v_file_type := SUBSTR(v_string, v_pos + 1);
DBMS_OUTPUT.PUT_LINE(v_file_type);
END;
/
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
