[R] Extracting numeric part from a string

[Marc Schwartz]

> On Aug 2, 2017, at 6:59 PM, Christofer Bogaso <bogaso.christofer at gmail.com> wrote:
> 
> Hi again,
> 
> I am struggling to extract the number part from below string :
> 
> "\"cm_ffm\":\"563.77\""
> 
> Basically, I need to extract 563.77 from above. The underlying number
> can be a whole number, and there could be comma separator as well.
> 
> So far I tried below :
> 
>> library(stringr)
> 
>> str_extract("\"cm_ffm\":\"563.77\"", "[[:digit:]]+")
> 
> [1] "563"
> 
>> 
> 
> However, above code is only extracting the integer part.
> 
> Could you please help how to achieve that. Thanks,


Using ?gsub:

X <- "\"cm_ffm\":\"563.77\""

> gsub("[^0-9.]", "",  X)
[1] "563.77"

or

> gsub("[^[:digit:].]", "",  X)
[1] "563.77"


Basically, remove any characters that are not digits or the decimal point, presuming your pattern is consistent across your data.

Regards,

Marc Schwartz


	[[alternative HTML version deleted]]