Forum Discussion

StephanieB's avatar
StephanieB
Qrew Trainee
6 days ago

Help extracting text between unique character

Hoping someone can help me out. I feel like I'm almost there, but not quite!

I basically want to strip everything out of my comments to get the first comment without a datetime stamp and stopping when it gets to the second comment [ date time stamp.

My formula:

Trim(NotLeft(NotRight([Comments],"["),"]"))

What my Comments field looks like:

[FEB-14-25 12:31 PM  Stephanie] in aliqua irure Lorem ex ea adipisicing laboris eu non minim voluptate enim pariatur veniam cillum sint nisi dolor mollit cupidatat do sunt incididunt velit sit mollit aliquip ipsum quis exercitation et id in laboris deserunt ullamco
[FEB-04-25  3:38 PM  Quickbase Administrator 2] 12341
[DEC-02-24  4:47 AM  Quickbase Administrator] New Record

What the formula returned:

in aliqua irure Lorem ex ea adipisicing laboris eu non minim voluptate enim pariatur veniam cillum sint nisi dolor mollit cupidatat do sunt incididunt velit sit mollit aliquip ipsum quis exercitation et id in laboris deserunt ullamco
[FEB-04-25  3:38 PM  Quickbase Administrator 2] 12341

What I want returned:

in aliqua irure Lorem ex ea adipisicing laboris eu non minim voluptate enim pariatur veniam cillum sint nisi dolor mollit cupidatat do sunt incididunt velit sit mollit aliquip ipsum quis exercitation et id in laboris deserunt ullamco

formulas
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 days ago

    Here are my cheat notes for logged fields where the newest entries are at the top

     

    Most Recent  Entry
    Trim(Right(Part(NotLeft([append at top],1),1, "["),"]"))

    Date of Most Recent Entry
    ToDate(NotLeft(Left([append at top], " "),1))

    Name who did the most recent entry

    NotLeft(Left([append at top], "]"),11)