This text is saved all in one column in database table. I want to take the time-stamp from the chat replies. Is there any command who can split the string and get the time-stamp. The chat starts from here:____________________________________________________________________________
Hi Guest 4878,
Thank you for chatting with us. Please find your chat transcript below.
Date: 2017-02-07
Name: Guest 4878 Email: Topic:
Chat reference number: 11701
| 07.02.2017 13:46:36 | Guest 4878: Anybody here?
| 07.02.2017 13:46:52 | Admin: Hello, how may I help you?
via Muharrem Smakiqi