search for: abc_def

...Server]Login failed for user '******'.?How to modify the code (see below) to access second MSSQL server? con <- dbConnect(odbc(),? ? ? ? ? ? ? ? ?Driver? ?= "ODBC Driver 17 for SQL Server",? ? ? ? ? ? ? ? ?Server? ?= "abcdefghijklmn",? ? ? ? ? ? ? ? ?Database = "abc_def") Thank you,Kai [[alternative HTML version deleted]]

...39;t familiar with regex's, maybe the stringr package may provide a gentler interface than using R's raw regex functionality. Or maybe someone else can suggest a better approach (which is another reason why you should reply to the list, not just me). z <- c("abc", "abc_def", "abc.def", "abc def", "abcd_ef", "abcd", "e","f") pats <- unique(sub("^(.+)[. _]+.*", "\\1", z)) ## gives: > pats [1] "abc" "abcd" "e" &...

...39;t familiar with regex's, maybe the stringr package may provide a gentler interface than using R's raw regex functionality. Or maybe someone else can suggest a better approach (which is another reason why you should reply to the list, not just me). z <- c("abc", "abc_def", "abc.def", "abc def", "abcd_ef", "abcd", "e","f") pats <- unique(sub("^(.+)[. _]+.*", "\\1 <file://1> ", z)) ## gives: > pats [1] "abc" "abcd"...