Hello SMEs:
I need some assistance extracting everything between the 5th and 6th "/" from URLs like the one below.
Note: URLs may change.
https://notify.webproxy.com/https://www.elitetools.ca/en/
Your assistance would be appreciated!
The new value will be extracted to url field.
| rex field=<yourfield> "(?:[^\/]*\/){5}(?<url>[^\/]+)"
you can make use of same regex I shared above.
for example:
1. Everything between the 3rd and 4th "/" - lets call this "button_click"
for above: replace {5} with 4 and replace url with button_click
2. Everything between the 6th and 7th "/" - lets call this "domain_ref"
for above : replace {5} with 6 and replace url with domain_ref
The new value will be extracted to url field.
| rex field=<yourfield> "(?:[^\/]*\/){5}(?<url>[^\/]+)"
Thanks so much @thambisetty ! This worked well!
I was just wondering, what would the new rex's be for capturing 2 new fields:
1. Everything between the 3rd and 4th "/" - lets call this "button_click"
2. Everything between the 6th and 7th "/" - lets call this "domain_ref"
FROM:
https://notify.webproxy.com/User_Clicked_non-business/https://www.elitetools.ca/
Note: URLS and Button click types may change.
Thanks again for your quick turnaround!