New answers tagged regex
0
EDIT
(following OP's comment
I need exactly all criteria . If disposition is "consultation " AND primary is either "Ob"or"surgical" And consultation contains eithe" IM"or "cardio"....
You can easily alter the formula with something like the following
=ArrayFormula(sum(
N(REGEXMATCH({...
1
You can address your issue by using 2 similar formulas as shown in the tab I have created in your spreadsheet.
The most challenging of the two is in cell P4 where we calculate the times
=INDEX(IFERROR(REGEXREPLACE(FLATTEN(
SPLIT(QUERY({C4:C&"@"},"where Col1 is not null",0)
,CHAR(10))),"@"," ...
2
Addressing strictly what you've requested in your post, I added a sheet ("Erik Help") with a custom conditional formatting rule applied to Column A:
=AND(LEN(A1),ISERROR(REGEXEXTRACT(A1,"^\d{4}\s\d{3}\s\d{3}$")))
This will highlight any entries in Column A that are not in the format "#### ### ###".
You can view this rule by ...
3
You mentioned
How can I use a filter or conditional formatting to find all numbers that are NOT in this format (#### ### ###).
Please use the following conditional-formatting rule
=IF(A1<>"",(IF(ISNUMBER(A1),TRUE,NOT(REGEXMATCH(A1,"^\d{4} \d{3} \d{3}$")))))
2
First substitute the white space. Paste this to Cell B2: =SUBSTITUTE(A2, " ", "")
After that make your number to exactly 10 digit. Paste this to Cell C2:
=IF(LEN(B2)=9,"0"&B2, IF(LEN(B2)=8,"00"&B2, IF(LEN(B2)=10,B2)))
Lastly add the space back to the right place.Paste this to Cell D2:
=LEFT(C2,4)&" &...
Top 50 recent answers are included
Related Tags
regex × 143google-sheets × 118
formulas × 81
google-sheets-arrayformula × 53
google-sheets-query × 32
regexextract × 15
concatenate × 8
conditional-formatting × 7
google-apps-script × 5
search × 5
filter × 5
google-docs × 4
google-search × 4
vlookup × 4
google-sheets-dates × 4
gmail × 3
google-forms × 3
mediawiki × 3
sorting × 3
google-analytics × 2
importxml × 2
text-formatting × 2
search-engine × 2
google-sheets-data-validation × 2
regexplace × 2