Given:
"kuku": "kdfjsfgsljfddnlfdsf"
"bubu": "slfjsdjlkfndvsdl;nsdf;vlankvdfs;lkndkfv"
"title": "dflkbjvndjlvbdknbdlkbvjndlkfdnbdlkbjdnb"
"tutu": "svfrol"
"lala": "dbd4431"
"title": "dfvbdfv"
I want to extract all the rows starting with "title".
Please advise how can I do this (I am using R and want a regex).
I am trying this:
(["'])(title)\1:
and trying to play with it.
One option is to read the text file as dataframe in R
df <- read.table(text = '"kuku": "kdfjsfgsljfddnlfdsf"
"bubu": "slfjsdjlkfndvsdl;nsdf;vlankvdfs;lkndkfv"
"title": "dflkbjvndjlvbdknbdlkbvjndlkfdnbdlkbjdnb"
"tutu": "svfrol"
"lala": "dbd4431"
"title": "dfvbdfv"', sep = ":", stringsAsFactors = FALSE, strip.white = TRUE)
and then select rows which has first column starting with "title"
df[grepl("^title", df$V1), ]
# V1 V2
#3 title dflkbjvndjlvbdknbdlkbvjndlkfdnbdlkbjdnb
#6 title dfvbdfv
If you want it as original string and not different columns then you can paste them back
do.call(paste, c(df[grepl("^title", df$V1), ], sep = ":"))
#[1] "title:dflkbjvndjlvbdknbdlkbvjndlkfdnbdlkbjdnb" "title:dfvbdfv"
paste so that we get two strings separated by :.do.call any additional arguments to the function which you are running can be passed in c(). Similar to sep, you can also do it with collapse like do.call(paste, c(df[grepl("^title", df$V1), ], collapse = ":"))?do.call Check #Examples section ## if we already have a list (e.g., a data frame) ## we need c() to add further argumentsYou can use something like:
^"title":.*$
With your input using https://regex101.com it looks like this:
Explanation:
^ means start of line
"title": is just take literally
. means an arbitrary character
* means it can happen zero or more times
$ means end of line
dput