How can i remove the $ signs

I’m saving the list of products on a website with data scraping into excel and I want to get the average of the integers in my price column in excel, but the prices come with a $ sign and I can’t get them as int. What should I do

@Busra1

Welcome to forums

Variable = Variable.Replace("$","")

Hope this may help you

Thanks

1 Like

thanks for replying
I’m very new to UIPath, where exactly do i write this

@Busra1

For Reference you can check below link

Reference

That will help you to understand how to use the for each loop

Inside that for each loop you can write the above logic in the If condition as

Row(“ColumnName”).ToString.Contains("$")

Assign activity as
DatatableVariable.Rows(Index).Item(“ColumnName”) = Row(“ColumnName”).ToString.Replace("$","")

Hope this may help you

Thanks

1 Like

I’ll check it thank you so much