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.
