1

I'm trying to create a formula that uses either =REGEXEXTRACT or =REGEXREPLACE to remove all characters not inside [brackets] but leaving the ,,, commas where they are.

For example...

➜ Text to Regex:

Checkbox 1, Checkbox 2, Checkbox 3[checked], Checkbox 4[disabled]

✔ Expected Result:

, , checked, disabled



My broken formula so far is...

=REGEXEXTRACT (J2, "\[([A-Za-z]+)\]")

✖ Current Result:

checked


Does anyone know the correct way to achieve this?


UPDATE

I created this Google Sheet to show the current work: https://docs.google.com/spreadsheets/d/1UEO22NB9O6hvbTQzIa2YlMys1GF7ZBpe8aVzmX7dOnk/edit#gid=0

  • 1
    ,,,,,,,,, Done. – Oneezy Mar 10 '18 at 8:50
  • 1
    It's a part of the Google Font directory I believe. One of my favorite fonts – Oneezy Mar 10 '18 at 9:51
  • Can you please also update the Google Forum Post, to have this answer? – Jacob Jan Tuinstra Mar 13 '18 at 12:21
  • 1
    Done. @JacobJanTuinstra – Oneezy Mar 23 '18 at 3:57
2
+200

Try

=REGEXREPLACE(A2,"\w+\s*\d*\[?(\b\S+\b)?\]?(,?)(\s*|$)","$1$2")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.