I have a monstruous amount of data, in several folders and subfolders, stored in CSV format. Unfortunately, these CSVs are in ISO standard for punctuation:
. for separating three digits
, to separate the integer and the fraction
; to separate between values
I need to transform all of them to the american standard
no separation between three digits
. to separate the integer and the fraction
, to separate between values
I cannot reconfigure the international config on the computer which will read the data, it needs to be in the american standard to run matlab's interface with excel.
So far, i have been handling this by opening the individual CSVs in word and substituting the relevant chars with macros, then saving and going back to excel Im in a desperate need of a more efficient manner to batch convert all CSVs to american standard.
Bookmarks