Regex help please – Parsing a big text area

Yep, what @Qiu did with the text to Columns is exactly what I would have done.

Pre-empting the next question, I imagine you then want to do something with the data below each title. You can do that many different ways. I like to tag the rows as it lets me play with the data a bit more. I would do this with 2 x Multi-row formulas. Some may use Tile in there.

Then decide what you want to do with it. 

Multi-row 1: 

Field: Category

Type: VWString

Expression: IF Right([Field__c],3) == “POC” THEN [Field__c] ELSE [Row-1:Category] ENDIF

Multi-row 2:

Field: CategoryLine

Type: Int32

Grouping: [Category]

Expression: [Row-1:CategoryLine]+1