search

datopian / datapipes

Data Pipes for CSV
https://datapipes.okfnlabs.org/
MIT License
117 stars 16 forks source link

Not able to use "replace" for the column headers #121

Open MichaelUray opened 7 years ago

MichaelUray commented 7 years ago

I would like to change the text in the column headers but the "replace" did not work on the first row of the CSV file which contains the column header texts.

andylolz commented 7 years ago

Thanks for this, @MichaelUray! Could you send a URL with an example query?

I guess if you use csv -H it will work, but that might not be what you’re after…

MichaelUray commented 7 years ago

Hi Andy,

thanks for your response.

I would like to change the column header "Schlusskurs" to "Schluss". With the -H option which you proposed gets the column row removed and the header names are shown in the first row. I would like to import the data into a program which requires certain names in the header and on this way it unfortunatly does not work for me.

http://datapipes.okfnlabs.org/csv%20-t/replace%20Schlusskurs%20Schluss/html/?url=http%3A%2F%2Fwww.ariva.de%2Fquote%2Fhistoric%2Fhistoric.csv%3Fsecu%3D293%26boerse_id%3D6%26clean_split%3D1%26clean_payout%3D0%26clean_bezug%3D1%26min_time%3D1.1.2010%26max_time%3D16.1.2017%26trenner%3D%2509%26go%3DDownload

Is there any other way to take influence on the header names?