Regex to individuate entries separate by specific character

Andre Piazza 0
Viewed 22

I'm using Google Sheets and attempting to individuate the entries separated by [char10] >

Sample content from a cell:

> low confidence registrar [char10] > No SSL certificate [char10] > Malicious intent [char10] > Complete sentence #4 [char10]

Closest I got so far was using the following Regex:

"> (.*?) !"

which only yields the first entry.

How do I fix my regex to yield the many groups and separate them into different columns?

Example: REGEXEXTRACT(H15:H,"> (.*?) !")

regex-greedy regex-group google-sheets-formula google-sheets regex
1 Answers

use:

=INDEX(SPLIT(SUBSTITUTE(H15:H, "> ", ), CHAR(10)))

enter image description here

player00
Related