Google Sheets REGEXREPLACE... after Nth occurrence
I have a list of URLs like
https://www.example.com/inn/abc_name_of_the_product_w/o_additional_information.132.jpeg
I don´t know how they include a slash in the file name... and it could be more than one time in the same file name!
I need to perform a REGEXREPLACE to replace any slash (/) in the filename by a dash (-), but not those in the URL... so it should keep up to the 4th slash in the string.
So given example should look like:
https://www.example.com/inn/abc_name_of_the_product_w-o_additional_information.132.jpeg
And a basic REGEXREPLACE(A2,"/","-") replaces ALL the slashes in the string, that is not what I want.
I've tried many alternatives, but my knowledge has a very low limit on the regex syntax, that I cannot fully understand, no matter how many references and tutorials I read about it. =(
Any help would be appreciated! =)
Use REGEXEXTRACT() then SUBSTITUTE()`
=REGEXEXTRACT(A1, "^(?:[^/]*/){4}") & SUBSTITUTE(REGEXEXTRACT(A1, "^(?:[^/]*/){4}(.+)"),"/","_")
- Regex wordwrap with UTF8 characters in JS
- Regex to exclude a range of numbers
- Finding Plus Sign in Regular Expression
- Rename files using regular expression in linux
- regex negative lookahead how to find a string that ends with a series of digits and a parenthesis?
- c# Regex to match all Sri Lankan phone numbers
- What do 'lazy' and 'greedy' mean in the context of regular expressions?
- Regex to find methods that have an 'inner' method
- DomDocument fetch h1 tag
- How to use start of line/end of line signs (^ or $) in different contexts?
- Incrementally replace number numeric pattern?
- JavaScript regular expressions and sub-matches
- How can I use regex to get a list of all values in double quotes and true and false which dont have quotes?
- gawk hangs when using a regex for RS combined with reading a continuous stream from stdin
- cmake how to exclude ._ files in macos in FILE(GLOB ) directive
- Regular Expression to match word ending with either y or z, but noth both together
- regex and exclude specific text from the capturing group
- How to regex scrape HTML and ignore whitespace and newlines in code?
- Replace substring in string using list or dict in polars python
- Why do Unicode emoji property escapes match numbers?
- scraping text from a file to view - with non standard format - php
- Pulling out some text from a giant HTML file using Nokogiri/xpath
- Indian pincode validation regex - Only six digits, shouldn't start with `0`
- Parse email string with metadata and get the From and Cc values
- preg_match() not matching start of line after splitting nl2br() string by <br />
- Validate that an input string contains only letters, numbers and underscores
- is there a function to escape special characters in a regex string?
- Get all integers which follow certain symbols in a string with multiple delimiters
- regex extract email from strings
- notepad++ regex mode: insert new line to some hex code