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: 'L...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendCan you post the links to those previous discussions?
- MarkShnier__You
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.
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!- MarkShnier__You
Please post back with your progress and let us know if it works for you. I am a pack rat and save these tips, but I haven't had a chance to actually test that for myself yet.
