str_sub and str_replace

[PeterHui]

Hi, just trying to figure out str_sub and str_replace. The instructions seemed pretty straightforward but when I tried it, it gave me strange behavior.

Column = c("2020-11-02-09.39.40.000000", "2020-11-02-13.06.25.000000")
str_replace(Column, ".",":") //not sure why it replaced 2 with .

Column2 = str_sub(Column,1,14) <- ":"
Column2 //not sure why nothing showed up other than the :

using str_replace, it replaced 2020 with :0202
using str_sub, it replaced the vector with :

odd

[andresrcs]

str_* functions use "regular expressions" (regex) and in regex, . is a metacharacter that matches "any character", if you want to replace a literall ".", you have to scape the metacharacter with \\. try

str_replace_all(Column, "\\.",":")

[PeterHui]

worked like a charm.

Thank you my friend!

@andresrcs

str_replace_all(Column, "\\.",":")