Convert character to integer type - R

Question

Hi, I'm using superstore dataset for visualizations.

I want to use sales and profit values, but they have currency along with digits.

Like this below

How to use the values now? Can someone help me to use the values from dataset?

Answer 1

Use substring() function to extract value from 2nd position and load it into the same field.

df$sales = as.numeric(substring(ds$sales, 2))