Copy csv file to excel with decimal problem after decimal point

Soudios · October 5, 2021, 3:28pm

@J0ska
i have any problem if the number have 2 decimal ==> example 120,05
but if the number is 120,503 it doesnt work

Gokul001 · October 5, 2021, 3:36pm

Refer the thread

Regards
Gokul

Soudios · October 5, 2021, 4:17pm

@Gokul001
it doesnt work

J0ska · October 5, 2021, 5:14pm

Sure, bcause it is thousands separator.

Soudios · October 5, 2021, 5:35pm

i need to keep this configuration system in my computer

Gokul001 · October 6, 2021, 5:09am

It’s Working Check the screenshot.

Regards
Gokul

Soudios · October 6, 2021, 7:25am

Its working with a specific number i need it to work with a hole csv file

Gokul001 · October 6, 2021, 7:25am

Share the CSV file

Soudios · October 6, 2021, 7:42am

@Gokul001
I can’t share it with you, what do you need to know about the csv file ?

Gokul001 · October 6, 2021, 7:43am

Can you share a dummy CSV file and error screenshot

J0ska · October 6, 2021, 7:49am

As stated before it seems to be locale settgins conflict:

I recommend you to resolve it by replacing “,” by “.” in your number, e.g.
MyNumber = “123,456”
MyNumber = MyNumber.replace(“,”,“.”)

This is a dummy solution but should work.

Cheers

Soudios · October 6, 2021, 7:59am

Gokul001 · October 6, 2021, 8:01am

Can you share the Dummy CSV file?
Otherwise, I cant help you…

Soudios · October 6, 2021, 8:08am

Here an example of numbers with 2 decimal after coma

Soudios · October 6, 2021, 8:12am

in your code i need to replace “MyNumber” by a csv file

J0ska · October 6, 2021, 8:13am

The solution proposed by @ppr before works well for all variants:
1 234,56 → 1234.56
234,56 → 234.56
234,567 → 234.567
1 234,567 → 1234.567

MyNumber = “1 234,56”
MyNumber = Double.Parse(MyNumber, System.Globalization.CultureInfo.CreateSpecificCulture(“fr-FR”)).ToString

Howgh

Soudios · October 6, 2021, 8:16am

I have 200000 row in this file, did a need to add MyNumber= “1 234,56” 200000 times ?

J0ska · October 6, 2021, 8:31am

This is a different story - you read CSV into a datatable and seems you do not know how to apply the formula to the datatable.

Cheers

Soudios · October 6, 2021, 8:39am

How can i do that ?

J0ska · October 6, 2021, 8:58am

This is quite common topic. Many resources about this topic in this forum and Internet.
Search pls.

Cheers