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.
You still miss him.
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.
This link may help you to solve your case https://community.talend.com/t5/Design-and-Development/Merge-two-subsequent-rows-in-one-file/m-p/530...
The first 100 community members completing the Open Studio survey win a $10 gift voucher.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences
Take a look at this video about Talend Integration with Databricks