Forum Discussion
MarkShnier__You
Qrew Legend
3 years agoOK, not tested but try this as a formula Rich Text field
var text RawStepOne =
SearchAndReplace(ToText([EOD Combined Text Session Text for Combined Text Summary sorted]),"</div>","|");
var text RawStepTwo=
List("<br>•",
Right(Part($Raw,1,"|"),">"),
Right(Part($Raw,2,"|"),">"),
Right(Part($Raw,3,"|"),">"),
Right(Part($Raw,4,"|"),">"),
Right(Part($Raw,5,"|"),">"),
Right(Part($Raw,6,"|"),">"),
Right(Part($Raw,7,"|"),">"),
Right(Part($Raw,8,"|"),">"),
Right(Part($Raw,9,"|"),">"),
Right(Part($Raw,10,"|"),">"),
Right(Part($Raw,11,"|"),">"),
Right(Part($Raw,12,"|"),">"),
Right(Part($Raw,13,"|"),">"),
Right(Part($Raw,14,"|"),">"),
Right(Part($Raw,15,"|"),">"),
Right(Part($Raw,16,"|"),">"),
Right(Part($Raw,17,"|"),">"),
Right(Part($Raw,18,"|"),">"),
Right(Part($Raw,19,"|"),">"),
Right(Part($Raw,20,"|"),">"),
Right(Part($Raw,10,"|"),">"),
Right(Part($Raw,21,"|"),">"),
Right(Part($Raw,22,"|"),">"),
Right(Part($Raw,23,"|"),">"),
Right(Part($Raw,24,"|"),">"),
Right(Part($Raw,25,"|"),">"),
Right(Part($Raw,26,"|"),">"),
Right(Part($Raw,27,"|"),">"),
Right(Part($Raw,28,"|"),">"),
Right(Part($Raw,29,"|"),">"),
Right(Part($Raw,30,"|"),">"),
Right(Part($Raw,31,"|"),">"),
Right(Part($Raw,32,"|"),">"),
Right(Part($Raw,33,"|"),">"),
Right(Part($Raw,34,"|"),">"),
Right(Part($Raw,35,"|"),">"),
Right(Part($Raw,36,"|"),">"),
Right(Part($Raw,37,"|"),">"),
Right(Part($Raw,38,"|"),">"),
Right(Part($Raw,39,"|"),">"),
Right(Part($Raw,40,"|"),">"),
Right(Part($Raw,41,"|"),">"),
Right(Part($Raw,42,"|"),">"),
Right(Part($Raw,43,"|"),">"),
Right(Part($Raw,44,"|"),">"),
Right(Part($Raw,45,"|"),">"),
Right(Part($Raw,46,"|"),">"),
Right(Part($Raw,47,"|"),">"),
Right(Part($Raw,48,"|"),">"),
Right(Part($Raw,49,"|"),">"),
Right(Part($Raw,50,"|"),">"),
Right(Part($Raw,51,"|"),">"),
Right(Part($Raw,52,"|"),">"),
Right(Part($Raw,53,"|"),">"),
Right(Part($Raw,54,"|"),">"),
Right(Part($Raw,55,"|"),">"),
Right(Part($Raw,56,"|"),">"),
Right(Part($Raw,57,"|"),">"),
Right(Part($Raw,58,"|"),">"),
Right(Part($Raw,59,"|"),">"),
Right(Part($Raw,60,"|"),">"));
IF($RawStepTwo<>"",
"#8226" & $RawStepTwo)
LMK if it works!
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
var text RawStepOne =
SearchAndReplace(ToText([EOD Combined Text Session Text for Combined Text Summary sorted]),"</div>","|");
var text RawStepTwo=
List("<br>•",
Right(Part($Raw,1,"|"),">"),
Right(Part($Raw,2,"|"),">"),
Right(Part($Raw,3,"|"),">"),
Right(Part($Raw,4,"|"),">"),
Right(Part($Raw,5,"|"),">"),
Right(Part($Raw,6,"|"),">"),
Right(Part($Raw,7,"|"),">"),
Right(Part($Raw,8,"|"),">"),
Right(Part($Raw,9,"|"),">"),
Right(Part($Raw,10,"|"),">"),
Right(Part($Raw,11,"|"),">"),
Right(Part($Raw,12,"|"),">"),
Right(Part($Raw,13,"|"),">"),
Right(Part($Raw,14,"|"),">"),
Right(Part($Raw,15,"|"),">"),
Right(Part($Raw,16,"|"),">"),
Right(Part($Raw,17,"|"),">"),
Right(Part($Raw,18,"|"),">"),
Right(Part($Raw,19,"|"),">"),
Right(Part($Raw,20,"|"),">"),
Right(Part($Raw,10,"|"),">"),
Right(Part($Raw,21,"|"),">"),
Right(Part($Raw,22,"|"),">"),
Right(Part($Raw,23,"|"),">"),
Right(Part($Raw,24,"|"),">"),
Right(Part($Raw,25,"|"),">"),
Right(Part($Raw,26,"|"),">"),
Right(Part($Raw,27,"|"),">"),
Right(Part($Raw,28,"|"),">"),
Right(Part($Raw,29,"|"),">"),
Right(Part($Raw,30,"|"),">"),
Right(Part($Raw,31,"|"),">"),
Right(Part($Raw,32,"|"),">"),
Right(Part($Raw,33,"|"),">"),
Right(Part($Raw,34,"|"),">"),
Right(Part($Raw,35,"|"),">"),
Right(Part($Raw,36,"|"),">"),
Right(Part($Raw,37,"|"),">"),
Right(Part($Raw,38,"|"),">"),
Right(Part($Raw,39,"|"),">"),
Right(Part($Raw,40,"|"),">"),
Right(Part($Raw,41,"|"),">"),
Right(Part($Raw,42,"|"),">"),
Right(Part($Raw,43,"|"),">"),
Right(Part($Raw,44,"|"),">"),
Right(Part($Raw,45,"|"),">"),
Right(Part($Raw,46,"|"),">"),
Right(Part($Raw,47,"|"),">"),
Right(Part($Raw,48,"|"),">"),
Right(Part($Raw,49,"|"),">"),
Right(Part($Raw,50,"|"),">"),
Right(Part($Raw,51,"|"),">"),
Right(Part($Raw,52,"|"),">"),
Right(Part($Raw,53,"|"),">"),
Right(Part($Raw,54,"|"),">"),
Right(Part($Raw,55,"|"),">"),
Right(Part($Raw,56,"|"),">"),
Right(Part($Raw,57,"|"),">"),
Right(Part($Raw,58,"|"),">"),
Right(Part($Raw,59,"|"),">"),
Right(Part($Raw,60,"|"),">"));
IF($RawStepTwo<>"",
"#8226" & $RawStepTwo)
LMK if it works!
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
EstherSchonfeld
3 years agoQrew Member
Thank you!!
I'm getting the below error:
------------------------------
Esther Schonfeld
------------------------------
I'm getting the below error:
------------------------------
Esther Schonfeld
------------------------------
- MarkShnier__You3 years ago
Qrew Legend
change
var text RawStepOne =
to
var text Raw=
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------ - EstherSchonfeld3 years agoQrew MemberSorry for the bother, I have one final question. How can I get the first line to display a bullet?
var text Raw =
SearchAndReplace(ToText([EOD Combined Text Session Text for Combined Text Summary sorted]),"</div>","|");
var text RawStepTwo=
List("<br>•",
Right(Part($Raw,1,"|"),">"),
Right(Part($Raw,2,"|"),">"),
Right(Part($Raw,3,"|"),">"),
Right(Part($Raw,4,"|"),">"),
Right(Part($Raw,5,"|"),">"),
Right(Part($Raw,6,"|"),">"),
Right(Part($Raw,7,"|"),">"),
Right(Part($Raw,8,"|"),">"),
Right(Part($Raw,9,"|"),">"),
Right(Part($Raw,10,"|"),">"),
Right(Part($Raw,11,"|"),">"),
Right(Part($Raw,12,"|"),">"),
Right(Part($Raw,13,"|"),">"),
Right(Part($Raw,14,"|"),">"),
Right(Part($Raw,15,"|"),">"),
Right(Part($Raw,16,"|"),">"),
Right(Part($Raw,17,"|"),">"),
Right(Part($Raw,18,"|"),">"),
Right(Part($Raw,19,"|"),">"),
Right(Part($Raw,20,"|"),">"),
Right(Part($Raw,10,"|"),">"),
Right(Part($Raw,21,"|"),">"),
Right(Part($Raw,22,"|"),">"),
Right(Part($Raw,23,"|"),">"),
Right(Part($Raw,24,"|"),">"),
Right(Part($Raw,25,"|"),">"),
Right(Part($Raw,26,"|"),">"),
Right(Part($Raw,27,"|"),">"),
Right(Part($Raw,28,"|"),">"),
Right(Part($Raw,29,"|"),">"),
Right(Part($Raw,30,"|"),">"),
Right(Part($Raw,31,"|"),">"),
Right(Part($Raw,32,"|"),">"),
Right(Part($Raw,33,"|"),">"),
Right(Part($Raw,34,"|"),">"),
Right(Part($Raw,35,"|"),">"),
Right(Part($Raw,36,"|"),">"),
Right(Part($Raw,37,"|"),">"),
Right(Part($Raw,38,"|"),">"),
Right(Part($Raw,39,"|"),">"),
Right(Part($Raw,40,"|"),">"),
Right(Part($Raw,41,"|"),">"),
Right(Part($Raw,42,"|"),">"),
Right(Part($Raw,43,"|"),">"),
Right(Part($Raw,44,"|"),">"),
Right(Part($Raw,45,"|"),">"),
Right(Part($Raw,46,"|"),">"),
Right(Part($Raw,47,"|"),">"),
Right(Part($Raw,48,"|"),">"),
Right(Part($Raw,49,"|"),">"),
Right(Part($Raw,50,"|"),">"),
Right(Part($Raw,51,"|"),">"),
Right(Part($Raw,52,"|"),">"),
Right(Part($Raw,53,"|"),">"),
Right(Part($Raw,54,"|"),">"),
Right(Part($Raw,55,"|"),">"),
Right(Part($Raw,56,"|"),">"),
Right(Part($Raw,57,"|"),">"),
Right(Part($Raw,58,"|"),">"),
Right(Part($Raw,59,"|"),">"),
Right(Part($Raw,60,"|"),">"));
If($RawStepTwo<>"",
"#8226" & $RawStepTwo)
------------------------------
Esther Schonfeld
------------------------------ - MarkShnier__You3 years ago
Qrew Legend
I'm surprised that the formula above does not start with a bullet. Can you post a screenshot of what you are seeing as a result of the formula above?
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------ - EstherSchonfeld3 years agoQrew Member
------------------------------
Esther Schonfeld
------------------------------ - MarkShnier__You3 years ago
Qrew Legend
Thx for the screen shot. I had an "aha" moment seeing it.
Try changing this line to this. I was missing an &
IF($RawStepTwo<>"",
"•" & $RawStepTwo)
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------ - EstherSchonfeld3 years agoQrew MemberThat worked, thank you!!
------------------------------
Esther Schonfeld
------------------------------