Sunday, May 17, 2015

yogi_Convert Entries While Importing CSV Into Their Numerics While Preserving The Header Row As Textual


                                           Google Spreadsheet   Post  #1959
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    May 15, 2015
question  by Bishkopt: 
https://productforums.google.com/forum/#!mydiscussions/docs/7LA0bBUpq1Q
Problem with importing CSV with semicolons (and commas as decimal marks)
Hi!
I'm looking for an elegant way to import and properly format CSV files delimited with semicolos and with commas as decimal marks.
I'm trying to do it in ONE sheet, with as little computation as possible needed.

I've figured out the following formula:

=arrayformula(substitute(importdata("http://www.noblefunds.pl/noblefunds/noblefunds_plugin/noblefunds/gencsv",";"), ",", "."))

(Note that there is an additional argument in IMPORTDATA fuction - it's not specified in the documentation, but it apparently works!).

It seems to do the work jus fine, but:

1) I cannot use functions such as "sum" (however I can add particular values)
2) I cannot get the date to be displayed in normal date format


Can you help, please?
-------------------------------------------------------------------------------------------


No comments:

Post a Comment