Format a text file into a table

Four Stars

Format a text file into a table

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.

Fifteen Stars TRF
Fifteen Stars

Re: Format a text file into a table

"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...


TRF
Fifteen Stars TRF
Fifteen Stars

Re: Format a text file into a table

Did this help?

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


TRF

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now