Inserting Regular Expressions into OpenRefine facets
Working in OpenRefine I want to find word pairs where the second word is 'Street'.
I have a python regular expression which works for this but I can't get it to work in OpenRefine.
https://regex101.com/r/igjCuo/94 show the regex working
\w+(\s+Street)
My issue is that I am obviously not inserting the regex into OpenRefine correctly.
Testing
If I try
value.find("Street")
then all cells which contain the word correctly return.
However putting the regular expression into the same query doesn't work
I know that this is something basic about formatting the query but I am at a loss and would really appreciate some help.
You did not form a correct regex literal/string pattern and added extra double quotation marks.
You may use
value.find("\\w+\\s+Street")
value.find(/\w+\s+Street/)
Note you do not need a capturing group as you need to get whole matches.
NOTE: If
pis a String then we compile it into a regex pattern, otherwise, Ifpis already a regex, then we just use that regex pattern. NOTE: When supplying the regex pattern in string quotes, you will need to use escaping (double slashes)
- Perl Regex fails to compile looking for \object
- Test if elements in a character string could be numeric
- How to remove all but emojis in a (Javascript) string?
- How to remove all characters from string apart from emoji
- How can I find all matches to a regular expression in Python?
- Zip code validation to exclude some formats
- How to allow specific words using javax.validation.constraints.Pattern?
- Create array of regex matches
- Handling complex parentheses structures to get the expected data
- Catching optional content just after a new line
- Regex to compare strings with Umlaut and non-Umlaut variations
- How can I check when there are only opening or closing quotes in PHP to make replacements?
- Regular Expression | Leap Years and More
- Regex date format validation on Java
- How can I replace every instance of a character from 3 groups of characters with just 3 different characters respectively?
- Regex to match 1 or less occurrence of string?
- Getting parts of a URL (Regex)
- Trim trailing spaces before newlines in a single multi-line string in JavaScript
- Only keep this String in Notepad++ (Regex)
- Redirect Youtube channel main page to videos section the proper way using regex
- Regular expression to validate repeating comma-separated groups without trailing comma
- Angular regex validator allows empty value, while the regex clause should demand at least one digit
- Parsing DeepDiff result
- Rewriting HTTP url to HTTPS using regular expression and javascript
- regex to match HTML <p ...> tag starting with a lowercase letter
- String.split() *not* on regular expression?
- How can I find the last occurance of a dot not preceding with a slash?
- How to extract table names and column names from sql query?
- How to use Rust regex on bytes (Vec<u8> or &[u8])?
- How to validate email by whitelist domain regex