Forum Discussion

aDummyWithaPC's avatar
aDummyWithaPC
Qrew Member
19 days ago

Parse Through Rich Text Field

Hello, I have a pipeline question and am hoping someone much smarter than I can help. I have read other discussions on this matter such as:

@markShnier_You and @KristofferKeen1 Collaboration: 
'Looping through field values in Pipeline | Qrew Discussions'

as well as @ChayceDuncan response:
'How to iterate through the fields of a single record in a Quickbase pipeline? | Qrew Discussions'

I am thinking this may be a combination of both?
I have a field called [FAILURE DETAILS] and it's formatted like this:
ps. I can change this to look however I need it to for this solution to work as it is just a rich text formula field consisting of if statements with html outputs to add underlining and line breaks. 

My question is, how would I have pipelines parse through a rich text field such as this and create a record per line, separating the title from the description. 
Example:

Table Name: Failures

[record id#]: 1
[Field Label]: TYPE OF PROVIDER
[Failure Description]:  MISSING

[record id#]: 2
[Field Label]: TYPE OF OWNERSHIP
[Failure Description]:  MISSING

Thank you in advance for any and all recommendations. I look forward to seeing what the community can come up with

    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend

      Well, I have never done it myself, I think this post here

      https://community.quickbase.com/discussions/quickbase-discussions/re-looping-through-field-values-in-pipeline/50679?MessageKey=7279a65e-2772-40b0-9d07-e4e310fe9cae&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer#bm7279a65e-2772-40b0-9d07-e4e310fe9cae

      gives a really clear explanation. You certainly could come up with a record per row. And then while no doubt there is a more elegant way to do it if we were both better at using Regex, once you have that row of data in Quickbase with the two components you could use two regular native Quickbase  formulas to parse those into two new separate fields. 

      • aDummyWithaPC's avatar
        aDummyWithaPC
        Qrew Member

        Hey Mark, good to hear from you! Yeah, initially I had linked the posts, but then when I went to submit it, some error codes popped up and wouldn't let me do so until I removed the hyperlinks. Maybe user-error, I'm not sure.

        You're work around is actually brilliant, I feel like that could work. 
        I'll give it a shot. Thanks Mark!