Can't you just use regular expressions to split it up? Like this for example https://www.oreilly.com/library/view/scala-cookbook/9781449340292/ch01s09.html
Colin On Sun, 4 Nov 2018 at 21:18, fugee ohu <[email protected]> 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 > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/rubyonrails-talk/f201139b-f56b-4909-af53-5144e79dbef3%40googlegroups.com. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAL%3D0gLu%3D5A7xOmSrHS0QuH-Sy6tcfi3kfO%3D2pQ%3DABLTqC81y8A%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
