ArchiveUser
6 years agoQrew Captain
Re: View only the last 4 lines in a data field?
Hi, Thank you for the code. We tried using this code and we get a formula error.
A formula may not contain a reference to itself directly or indirectly through another formula.
Here's the updated code I used.
var text StepOne = SearchAndReplace([Long Text Formula],"MST","|");
var text Message = Right($StepOne,"|");
var text RestOfMessage = NotRight($StepOne,"|");
var text DateStamp = Right($RestOfMessage,"\n");
Trim($DateStamp & " MST " & $Message)
Thanks!
A formula may not contain a reference to itself directly or indirectly through another formula.
Here's the updated code I used.
var text StepOne = SearchAndReplace([Long Text Formula],"MST","|");
var text Message = Right($StepOne,"|");
var text RestOfMessage = NotRight($StepOne,"|");
var text DateStamp = Right($RestOfMessage,"\n");
Trim($DateStamp & " MST " & $Message)
Thanks!