Forum Discussion

Qrew Cadet

5 years ago

Extract a date from the middle of a logged field

I'm trying to extract a date into a formula date field from a logged field that isn't necessarily on the top or bottom of the log. It could be, but it could also be in the middle. I need the date as...

Formulas and functions

MarkShnier__You

Icon for Qrew Legend rank

Qrew Legend

5 years ago

You will to use the SerachAndReplace function to replace "Living with" with say a "|". Then look for that | character for your formulas post back if you are stuck.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

TrishWehrle
Qrew Cadet
5 years ago
Thank you
thank you
thank you!

------------------------------
Trish Wehrle
------------------------------
TrishWehrle
Qrew Cadet
5 years ago
Sorry I'm stuck. Not sure I even know what search and replace is.

------------------------------
Trish Wehrle
------------------------------
- MarkShnier__You
  Qrew Legend
  5 years ago
  Can you post me the copy and paste of the data for some sample data in the field the field and I will make the formula for you.
  
  ------------------------------
  Mark Shnier (YQC)
  Quick Base Solution Provider
  Your Quick Base Coach
  http://QuickBaseCoach.com
  mark.shnier@gmail.com
  ------------------------------
  - TrishWehrle
    Qrew Cadet
    5 years ago
    Here's the logged field example that made me realize my formula was wrong. It returned the value of May-26.
    
    [MAY-12-20 8:54 PM Jason Khalaf] EE Contact with (close contact)
    
    [MAY-22-20 12:55 PM Adam Walters] Living with
    
    [MAY-26-20 8:58 AM Barry Smithley] EE positive
    
    Here's one example where the log has 'living with' as the latest entry:
    
    [APR-06-20 12:10 PM Trish Wehrle] EE Contact with (close contact)
    
    [MAY-26-20 10:18 AM Leah Schooling] Living with
    
    ------------------------------
    Trish Wehrle
    ------------------------------