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
Comments
Post a Comment