regexlooker-studiore2
Looker Studio rename output of city metric
Some city data is being returned with "(not set)" which I've figured out how to filter out via regex BUT I would instead like to change it to something else eg "(Unset Location)" or similar. Is this a possibility?
Solution
Pretty straight forward, as I'd originally hoped. I created a custom dimension and used the following for the formula input.
REGEXP_REPLACE(City, '^\\(not set\\)$','Undetermined')
Steps:
- Select "Add dimension"
- Select "CREATE FIELD"
- Insert Formula
- Replace all image urls with <img> tags
- Regex Greedy from right to left
- gawk hangs when using a regex for RS combined with reading a continuous stream from stdin
- Get all integers which follow certain symbols in a string with multiple delimiters
- How do I check if a filename matches some wildcard pattern?
- Replace named captured groups with arbitrary values in Python
- .htaccess redirect from site root to public folder, hiding "public" in URL?
- Program to generate regex easily?
- What's the regular expression that matches a square bracket?
- Add a new class to img tag's class list
- Wrap <img> tag in a new tag and add alt attribute to the <img>
- Remove non-<img> tags from string
- Remove excess newlines/whitespace from multi-line <img> tag in HTML string
- Get whole img tag including its attribute declarations from a string
- regex for match all <img> tag and extract the "src" attribute
- Trying to match src part of HTML <img> tag Regular Expression
- Find and kill a process in one line using bash and regex
- RegEx problem or maybe another solution altogether?
- Regex split where \# splits and \\# does not
- textfield text (one or more than one) regex check Swift UIKit
- Get the src value from all img tags
- How to extract img src, title and alt from html using php?
- Regular Expression to validate a CAGE Code
- Get telephone number from a string containing labelled contact details
- String matches method - forward slash not working
- How to make a REGEX pattern in mysql for 3 or more digits that are in sequence?
- Regex pattern with optional segments failing to match slash-delimited string
- Validate that a string is wholly alphanumeric and has a qualifying length
- Validate password with minimum length and whitelisted characters
- Parse the lines of a predictably formatted text file