regex - need to parse up to 3rd / in a string by using regexp in sql -


when trying extract through regexp below source using \|(.*?),1,2 this, getting end need 3rd / only. when use \|(.*/){1,3},1,2 giving http://localhost:6148372/content/bdsajf , stuck @ ending search position. please me on this.

u=https://www.abcdf.com/aecb/app/login|http://llcwokhfkdvc.webs.com/sajc-services u=http://localhost:7438/en.html|http://localhost:6148372/content/bdsajf/en/kjf-lkjf/fjksf-cbxjs.html 

o/p should # http://llcwokhfkdvc.webs.com , http://localhost:6148372

thanks

try following expression:

\|([^/]*/*[^/]*) 

see live demo


Comments

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

rewrite - Trouble with Wordpress multiple custom querystrings -