Ruby on Rails

On Mon, Nov 5, 2018 at 5:18 AM fugee ohu <fuge...@gmail.com> wrote:

I'm trying to split on spaces but one of the data columns has spaces in it and no quotes around it It's sms exported from my phone  I wanna save them to a table Each line looks like the line below The first is the phone number then the date and time, then the body of the sms message and then a single digit 1 or 2 to indicate if the message was sent or received Looks like between time and message body there's a tab delimeter but the other delimeters are single spaces but then the message body contains single spaces and so does the date and time column How can I split this? 

+2124914028 06/09/2017 12:21:56 Are we meeting up for breakfast today? 1

just split it by parts (simpler for me).

eg,

> s="+2124914028 06/09/2017 12:21:56 Are we meeting up for breakfast today? 1"
=> "+2124914028 06/09/2017 12:21:56 Are we meeting up for breakfast today? 1"
> phone,date,time,remaining=s.split(/\s/,4)
=> ["+2124914028", "06/09/2017", "12:21:56", "Are we meeting up for breakfast today? 1"]

the remaining part is similar.

best regards

--botp