Forum Discussion

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!
No RepliesBe the first to reply