Excuse me, here is the vector:
TV_Precios2 <- c("S/. 2,499.00S/. 1,999.00", "S/. 2,299.00 S/.
1,599.00", "S/. 2,299.00 S/. 1,599.00",
"S 40\" FULL HD 40LF6350S/. 1,999.00S/. 1,699.00", "S/. 5,999.00S/. 4,799.00",
"S/. 3,499.00S/. 2,999.00", "S/. 4,799.00S/. 3,699.00", "S/. 599.00",
"S/. 1,299.00", "S/. 999.00 S/. 799.00", "S/. 1,999.00 S/. 1,699.00",
"S/. 999.00 S/. 849.00", "S/. 499.00 S/. 439.00", "S610S/. 1,899.00",
"S/. 1,799.00S/. 1,699.00", "S/. 2,299.00S/. 1,699.00", "S/.
8,999.00S/. 7,299.00",
"S9000S/. 10,999.00S/. 8,999.00", "S9000S/. 14,999.00S/. 12,999.00",
"S/. 6,999.00S/. 5,999.00", "S/. 2,799.00S/. 2,299.00", "S/.
2,999.00S/. 2,649.00",
"SMART 49LF5900S/. 2,399.00S/. 2,149.00", "S/. 2,299.00 S/. 1,599.00"
)
---------- Forwarded message ----------
From: Omar André Gonzáles Díaz <oma.gonza...@gmail.com>
Date: 2015-09-29 10:24 GMT-05:00
Subject: Regex: just keep the money and not the description
To: "r-help@R-project.org" <r-help@r-project.org>
Hi R users, I have a character vector with 2 numbers: old price, new
price. The problem is that some rows (4,23, for example) contain a
little description of the product, which I don't need.
I've tried a lot of thins, like this one:
TV_Precios3 <- gsub("^S ^[0-9]{2}\\$","",TV_Precios2)
Without result. Any help is welcome.
After that I want to separate them with colsplit (have this solved)
based on "S/.".
head(TV_Precios3,50)
[1] "S/. 2,499.00S/. 1,999.00"
[2] "S/. 2,299.00 S/. 1,599.00"
[3] "S/. 2,299.00 S/. 1,599.00"
[4] "S 40\" FULL HD 40LF6350S/. 1,999.00S/. 1,699.00"
[5] "S/. 5,999.00S/. 4,799.00"
[6] "S/. 3,499.00S/. 2,999.00"
[7] "S/. 4,799.00S/. 3,699.00"
[8] "S/. 599.00"
[9] "S/. 1,299.00"
[10] "S/. 999.00 S/. 799.00"
[11] "S/. 1,999.00 S/. 1,699.00"
[12] "S/. 999.00 S/. 849.00"
[13] "S/. 499.00 S/. 439.00"
[14] "S610S/. 1,899.00"
[15] "S/. 1,799.00S/. 1,699.00"
[16] "S/. 2,299.00S/. 1,699.00"
[17] "S/. 8,999.00S/. 7,299.00"
[18] "S9000S/. 10,999.00S/. 8,999.00"
[19] "S9000S/. 14,999.00S/. 12,999.00"
[20] "S/. 6,999.00S/. 5,999.00"
[21] "S/. 2,799.00S/. 2,299.00"
[22] "S/. 2,999.00S/. 2,649.00"
[23] "SMART 49LF5900S/. 2,399.00S/. 2,149.00"
[24] "S/. 2,299.00 S/. 1,599.00"
______________________________________________
R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
