How to split a string into multiple columns by a given pattern?

Question

I have text data as given below:

\r\n    \r\n        How to get a confirm ticket?\r\n        \r\n            I want to get a tatkal ticket confirm ...

How to extract two columns from this data?

I have tried str_split_fixed() which divide into four columns and after those four column, two column can be retrieved ... But I want that straight forward it gives only two columns.

x <- "\r\n    \r\n        How to get a confirm ticket?\r\n        \r\n            I want to get a tatkal ticket confirm ..."
str_split_fixed(x, "\r\n", 4)
#>      [,1] [,2]   [,3]                                   [,4]                                                               
#> [1,] ""   "    " "        How to get a confirm ticket?" "        \r\n            I want to get a tatkal ticket confirm ..."
str_split_fixed(x, "\r\n", 4)[1, 3]
#> [1] "        How to get a confirm ticket?"

hplieninger · Accepted Answer · 2019-05-03 10:10:08Z

1

If the strings are always in that same format, the following regular expression should work well:

library(stringr)
x <- "\r\n    \r\n        How to get a confirm ticket?\r\n        \r\n            I want to get a tatkal ticket confirm ..."
str_split(x, "(\r\n\\s*)+", simplify = TRUE)[, -1, drop = FALSE]
     [,1]                           [,2]                                       
[1,] "How to get a confirm ticket?" "I want to get a tatkal ticket confirm ..."

If your data actually comes from a table in a text file or from a web page, there are probably more convenient options.

answered May 3, 2019 at 10:10

hplieninger

3,55432 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

mohitji Over a year ago

Thank you. I have another string : 500words\n \n \n \n \n \n Author\n \n

mohitji Over a year ago

how to do for this

hplieninger Over a year ago

I would recommend learning regular expressions (e.g., link). Here, the pattern separating the strings seems to be something like "(\n\\s*)+"?!?

Collectives™ on Stack Overflow

How to split a string into multiple columns by a given pattern?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related