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