converting the 13-,4- to -13,-4 using regular expression?

Question

So I have a text column in data frame:

stocksavailable

140,13-,3-,40-,2-

The numbers 13-, 2- and 3- are incorrect while extracting, can we get something like this using R code?

stocksavailable
140,-13,-3,-40,-2

What have you tried?. also if you want an answer in R please tag it to your question to attract more accurate attention — , Sep 30 '18 at 20:12
have you tried any thing, so please share your result so anyone can suggest based on it. — Arif Rathod, Oct 01 '18 at 04:59

score -1 · Accepted Answer · answered Oct 01 '18 at 13:28

-1

Assuming the numbers are integers, try: (\d+)(\-)?

You should be able to use the gsub method like this

answered Oct 01 '18 at 13:28

Matt.G

It worked : in R I did this ptn<- "(\\d+)(\\-)?" string = "140,13-,3-,40-,2-" subst = "\\2\\1" gsub(ptn,subst,string) – TheGreatDolton Oct 03 '18 at 11:00

1 Answers1