-3

I am downloading .csv files in remote server. It is taking the thousand separator as . instead of ,. How I can rectify this?

Adriaan
  • 17,741
  • 7
  • 42
  • 75
priyanka
  • 1
  • 1
  • Well, a *comma* separates values, which is why it is called a *Comma Separated Values* document... – Adriaan Oct 04 '17 at 11:42
  • This is just for displaying purposes, right? 'Cause the stored values should contain neither of these signs. – loki Oct 04 '17 at 11:45

1 Answers1

0

First, I would suggest looking at these two questions that have already been answered:

How to read data when some numbers contain commas as thousand separator?

Dealing with commas in a CSV file

I am not sure what you are doing with the exported file, but another option would be to remove the "thousand separator" on the file before exporting it as csv, then reformatting it after you have performed your action.

esion
  • 198
  • 1
  • 8