Regular expression

[Learning]

Hi,

I have the following list:

[1] "Name:  [00:00:01] My name is Antonio Margareeete."

[2] "Name2: [00:00:10] Can you repeat please?"

[3] "Name :  [00:00:14]  Margareeeeeete."

I would like to split this in three pieces, such as:

     x1         x2                                           x3 
Name       00:00:01    "My name is Antonio Margareeete."
Name2      00:00:10      "Can you repeat please?"
Name      00:00:14         " Margareeeeeete."

I would appreciate some advice.

Thanks

[hichammoadsafhi]

Hi, you can split using brackets (supposing that the text will not include them), then bind the results and convert it to dataframe using:

as.data.frame(do.call(rbind, strsplit(mylist,"\\[|\\]")))

and later you can clean the first column by removing the dots.

[Learning]

Amazing. Thanks very much for this!