How can i remove "."

[Busra1 (Büşra)]

Hi everyone, How can i remove “.”
I guess I can’t average these numbers because of “.”

Thanks…

[william.coulson (Will Coulson)]

Hi @Busra1,

Try StringVar = StringVar.Replace(".",""). This will replace all instances of . in the variable you’re using the function on

[Jobin_Joy]

Hi @Busra1

If your requirement is to get the price of a product correctly from an unformatted excel columns, you can simply use the below.

Double.Parse(“1.500”,System.Globalization.CultureInfo.CreateSpecificCulture(“de-DE”)).toString(“F2”)

Please refer the inline screenshot.

Hope this will help you. Thank you.

[Busra1 (Büşra)]

Thanks for replying
Do i use this with assign??

[william.coulson (Will Coulson)]

Hi @Busra1,

Yes, you would need to do this in an assign

[Jobin_Joy]

Hi @Busra1 ,

You can assign the value to variable as in the below inline screenshot.

Where,
CurrentRow(“Price”).ToString is the value you are getting from excel file through data table.
Price is the variable which storing the formatted double value as per your requirement.

Hope this clarified your question. If this works, please mark this issue as ‘Resolved’

Thank you.

[william.coulson (Will Coulson)]

@Busra1,

You have already posted a topic for this issue?

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

Just use the same code that @Srini84 suggested and replace $ with .