> On Feb 19, 2017, at 3:50 AM, Brad Barnett wrote:
>
> SUBSTRING_INDEX
Thanks a million, Brad! That works perfectly. SUBSTRING_INDEX didn’t
come up in my searches so this is the first I’ve heard of it.
Also, as you could see, it wasn’t a true timestamp. It is only used
for
I’ve been asked to post a question here for a friend.
Is there a formula to change the format of the data in a single field
in every record of a table? She has a "timestamp” in a text field formatted as
2017|02|16|04|58|42 and she wants to convert it to a more human readable for
