Format a text file into a table

Anonymous — Sat, 16 Nov 2024 08:11:05 GMT

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.

Re: Format a text file into a table

TRF — Thu, 31 May 2018 08:14:24 GMT

"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/53016

Re: Format a text file into a table

TRF — Fri, 01 Jun 2018 13:55:58 GMT

Did this help?

If so, thank's to mark your case as solved (Kudos also accepted).

topic Format a text file into a table in Talend Studio

Format a text file into a table

Re: Format a text file into a table

Re: Format a text file into a table