For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
When I have upgraded the JDK version 1.7.0_111. facing that issue during when the ftp server pushed the file to concerned receiver
.When I have used the JVM 1.7.0_99 it is working fine as per expected behavior.
SQL> WITH test_data AS ( 2 SELECT 'c:\temp\folderA\fileA.txt' t FROM DUAL UNION ALL 3 SELECT 'c:\temp\fileA.txt' t FROM DUAL UNION ALL 4 SELECT '\\mymachine\A\fileB.txt' t FROM DUAL UNION ALL 5 SELECT '\\mymachine\A\B\fileB.txt' t FROM DUAL UNION ALL 6 SELECT '\\mymachine\A\B\C\image.jpg' t FROM DUAL UNION ALL 7 SELECT '\\mymachine\A\B\C\D\music.mpg' t FROM DUAL UNION ALL 8 SELECT 'c:\myfolder\folderD\folderE\4969-A.txt' t FROM DUAL 9 ) 10 SELECT t, substr(t, instr(t,'\',-1,2)+1, (instr(t,'\',-1,1)-instr(t,'\',-1,2))-1) my_string 11 FROM test_data; T MY_STRING -------------------------------------- -------------------------------------- c:\temp\folderA\fileA.txt folderA c:\temp\fileA.txt temp \\mymachine\A\fileB.txt A \\mymachine\A\B\fileB.txt B \\mymachine\A\B\C\image.jpg C \\mymachine\A\B\C\D\music.mpg D c:\myfolder\folderD\folderE\4969-A.txt folderE
SQL> ed Wrote file afiedt.buf 1 WITH test_data AS ( 2 SELECT 'c:\temp\folderA\fileA.txt' t FROM DUAL UNION ALL 3 SELECT 'c:\temp\fileA.txt' t FROM DUAL UNION ALL 4 SELECT '\\mymachine\A\fileB.txt' t FROM DUAL UNION ALL 5 SELECT '\\mymachine\A\B\fileB.txt' t FROM DUAL UNION ALL 6 SELECT '\\mymachine\A\B\C\image.jpg' t FROM DUAL UNION ALL 7 SELECT '\\mymachine\A\B\C\D\music.mpg' t FROM DUAL UNION ALL 8 SELECT 'c:\myfolder\folderD\folderE\4969-A.txt' t FROM DUAL 9 ) 10 select regexp_replace(t, '^.*[\]([^\]*)[\][^\]*$','\1') 11* from test_data SQL> / REGEXP_REPLACE(T,'^.*[\]([^\]*)[\][^\]*$','\1') ------------------------------------------------------------------ folderA temp A B C D folderE 7 rows selected. SQL>
col str for a20 WITH test_data AS ( SELECT 'c:\temp\folderA\fileA.txt' t FROM DUAL UNION ALL SELECT 'c:\temp\fileA.txt' t FROM DUAL UNION ALL SELECT '\\mymachine\A\fileB.txt' t FROM DUAL UNION ALL SELECT '\\mymachine\A\B\fileB.txt' t FROM DUAL UNION ALL SELECT '\\mymachine\A\B\C\image.jpg' t FROM DUAL UNION ALL SELECT '\\mymachine\A\B\C\D\music.mpg' t FROM DUAL UNION ALL SELECT 'c:\myfolder\folderD\folderE\4969-A.txt' t FROM DUAL) select t,RegExp_replace(t,'^.*?([^\]+)\\[^\]+$','\1') as str from test_data order by t; T STR -------------------------------------- ------- \\mymachine\A\B\C\D\music.mpg D \\mymachine\A\B\C\image.jpg C \\mymachine\A\B\fileB.txt B \\mymachine\A\fileB.txt A c:\myfolder\folderD\folderE\4969-A.txt folderE c:\temp\fileA.txt temp c:\temp\folderA\fileA.txt folderA
select t,RegExp_substr(t,'[^\]+',1,-1+regexp_count(t,'[^\]+')) as str from test_data order by t;