Regex help please - Parsing a big text area

I am attempting to query for a big long text field from Salesforce and i want to put its contents in a table.

The title of each section ends with "POC" and should be field titles. The stuff below each area below the "POC" titles should be their values.

At this point, the only success we have had was parsing away the parts that ends with POC. The rest of the content in the text input doesn't reach the output. Please help.

poc piece for alt.yxmd

Workflow

Regex

Parse

Transformation

Salesforce

Accepted answers

Qiu

@uriah
I would use a Text to Column toos to break the text to each lines then filter out the rows ending with "POC".

poc piece for alt-r1.yxmd

KGT

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

All comments

Qiu

@uriah
I would use a Text to Column toos to break the text to each lines then filter out the rows ending with "POC".

poc piece for alt-r1.yxmd

KGT

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

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

caltang

Something fun for you - you can put this exact question into AI like ChatGPT or Co Pilot or Perplexity or POE AI to get the formula and resolve the Regex with a more robust answer as well to handle edge cases. Just be specific in the prompt to include that it is done in a Alteryx.

uriah

amazing. amazing. thanks so much. i owe you guys money . seriously

uriah

thanks so much. you gotta be one of the best users here. i owe you money. THANK YOU.

Qiu

@caltang
Just received the email that we can accept solutions even we are not the author.
thanks. 😁

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703