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)
- JS Regex MatchAll with combination of Comma & Semicolon
- Symfony Routing Host Regular Expression
- Regular Expression to parse Common Name from Distinguished Name
- Add a value and sum it up using Notepad++
- Regex for Number "05XXXXXXXX"
- Replace one character but not two in a string
- how to escape hyphen in regex character group in c
- Why do some regex engines match .* twice in a single input string?
- What do 'lazy' and 'greedy' mean in the context of regular expressions?
- How to test if a RegExp contains capturing groups in its definition?
- create regex to match format of 00:00:00 for duration (not time)
- regex for expression with one separator hyphen
- Remove special character and units form Pandas column name with Python
- Replace variables in a formula with their definitions
- RegEx to differentiate chemical compound names from pattern
- Replace letters inside words that start with and end with a specific letter not occurring anywhere else with the same amount of a specific character
- open vimeo url in colorbox using jQuery filter
- Split address and numbers
- Pyspark Regular Expression add double quotes after comma
- In the regex world what's a flavor and which flavor does Java use?
- Problems with table extraction using pdfplumber - empty fields in large tables
- How do I pass a variable into regex with Node js?
- How do I use regex in a SQLite query?
- Python RegEx: match words in a string only if they are not preceded by a specific character
- Regular expression that ignores HTML entities
- Allow access to page only from certain referrer
- Regex to match string containing two names in any order
- Matching boot times from log using sed -E
- Validate Bangladeshi phone number with optional +88 or 01 preceeding 11 digits
- Using setCustomValidity stops input from validating