Hello, I have a text log file that looks something like this:
Fri Mar 15 23:58:50 CET 2013 (tinasetiawati2) malesss Fri Mar 15 23:58:50 CET 2013 (AyeSheBall) RT @TRz_simba: He started to ignore you.
He got bored.
He stopped showing he cared.
He left.
You still miss him.
Right? Fri Mar 15 23:58:50 CET 2013 (hanojepreel) ً. Fri Mar 15 23:58:50 CET 2013 (xxchi1xx) 撮れた！！！撮れたよパンチラ！撮れた！！！ http://t.co/ejD5SywJxs Fri Mar 15 23:58:50 CET 2013 (poyostar0621) #朝からりょんぐで爽やかな朝を http://t.co/bM6uu8l29b Fri Mar 15 23:58:50 CET 2013 (keatsmycalling) RT @lorenzafin: noite d sexta feira bombando com essa programaçao otima da net Fri Mar 15 23:58:51 CET 2013 (teenshop_indo) RT @CahyaCayy: Bisaa syg 🙂 di mutasi rekening 🙂 @ForumOnlineShop @teenshop_indo Fri Mar 15 23:58:51 CET 2013 (sakusaku858) 今回の曲はGUMIさんの苦手な「だぢづでど」を連発するマジキチな曲だったのね Fri Mar 15 23:58:51 CET 2013 (hehasthekey) RT @JessieJ: Isn't it weird how one day that feeling you had for someone for so long just goes?.... Fri Mar 15 23:58:51 CET 2013 (MohamedKhiyari) لو انت رومانسي مكانك هنا لو عايز تصميم علي الفوتو شوب مكانك هنا لو عايز اخر اخبار الرياضة مكانك هنا لو عايز اجمل... http://t.co/BujnF7GMcY Fri Mar 15 23:58:51 CET 2013 (RaiiJz) RT @ChisteSorpresa: —¡Besémonos! —¡¿Qué?! —Que ayer fui al zoológico y besé monos. Fri Mar 15 23:58:51 CET 2013 (gracehansen_) Some couples are insane Fri Mar 15 23:58:51 CET 2013 (CiberladyMx) La ex
I am trying to format it to be in a table with the help of Talend in this format: Datetime | Username | Message
The problem is that some of the messages are on a new line, please help me.
"The problem is that some of the messages are on a new line, please help me", so I assume the rest is not a problem for you and you just need a solution to manage multiple-lines records.
For your usecase, you have to consider that as soon a record doesn't begin with a Date, it is a new part of the previous record.
