How do I only show the last entry in a notes field (log entries)?

Hello, I am using your formula for the same purpose only that I would like to see only the first entry, can you help me with that 

Can you post an example of what the data looks like in that Append field.

SURE.....

Specific: (FIELD NAME)
[JAN-09-19 Data System Specialist (Administrator)] come to school

[JAN-09-19 Data System Specialist (Administrator)] To learn more and move up a level to get soon my GED also gets perfect attendance. I have to come to school Monday to Friday at 9:00 am to be part of the ideal attendance  student weekly list

[JAN-28-19 Data System Specialist (Administrator)] Testing

Thank you so much in advance for your help

Try this . I had it in my notes but did not retest it

var text LogField = [Log changes append only at the top];

If(Trim($logField)<>"", 
"[" & Left(NotLeft($LogField,"["),"["))

It workedddddddddd!!!!    I'm so happy, thank you so much

Hello -
I realize this is an old thread and many thanks for the response. Instead of displaying only the newest (latest) entry is it possible to display a finite number of the latest? I am interested in seeing the two latest entries.

FYI - my reference append field is prepending, and in my new formula text field I am using Part([appendfieldname],2,"[") which gets me only the newest entry.

Is there a way to edit this formula and get the two latest entries instead? Or does it have to be an entirely different approach?

------------------------------
Gerald Vartanian
------------------------------