[Kst] Date and time in csv

[Berse, Matthias]

Hi Gunter,

I think you need to get rid of the "," in your CSV in order to make it work with tabs. Otherwise the , would still be interpreted as part of the number and yield strange results.

Is it live data, or can you preprocess it? A quick sed session could easily transform your CSV into something KST will understand.

Thanks,

Matthias
-----------------------------------------------------------------------
Raith GmbH
Matthias Berse
Development Engineer - R & D

email: mailto:Matthias.Berse at raith.de
phone: +49 (231) 95004 351
fax: +49 (231) 95004 460 
web: http://www.raith.com
-----------------------------------------------------------------------
Raith GmbH - Konrad-Adenauer-Allee 8 - 44263 Dortmund - Deutschland / Germany
Geschaeftsfuehrer / managing director: Dr. Ralf Jede // Handelsregister / trade register: Dortmund HRB 8984
Steuer-Nr. / tax number: 315/5765/0135 // Ust.-IdNr. / VAT number: DE 124 727 617

-----Urspruengliche Nachricht-----
Von: Gunter Koenigsmann [mailto:Gunter.Koenigsmann at semikron.com] 
Gesendet: Mittwoch, 25. Februar 2015 09:43
An: kst at kde.org
Betreff: [Kst] Date and time in csv

Dear list,

Is there a way to read in csv data where the lines have the following
format:

"","2015/02/24","15:36:56",	   0.100,  	  1225.8,   	1001.5,	
   445.2

Theoretically the lines are comma separated values, but they contain two date-format lines. ...or they could be read as tab-separated values with a cell with a date in a weird format but it nearly looks like kst does not discern between tabs and spaces.

Thanks a lot,
and kind regards,

     Gunter.

Gunter Koenigsmann
R&D

Tel:     +49 911-6559-6025
Fax:    +49 911-6559-776747

www.semikron.com
gunter.koenigsmann at semikron.com 

SEMIKRON Elektronik GmbH & Co. KG
Sigmundstrasse 200, 90431 Nuernberg, Germany Amtsgericht Nuernberg HRA 13650
Komplementaer:
SEMIKRON Elektronik Verwaltungs GmbH
Amtsgericht Nuernberg HRB 21338
Geschaeftsfuehrer: 
Harald Jaeger
Christian Mueller
Peter Sontheimer


IMPORTANT NOTICE - The contents of this email and attachments are confidential. If you are not the intended recipient you must not use, copy, distribute or rely on this email and should please return it immediately or notify us by telephone. While we take every reasonable precaution to screen out computer viruses from emails, attachments to this email may contain such viruses. We cannot accept liability for loss or damage resulting from such viruses.  The integrity of email across the Internet cannot be guaranteed and SEMIKRON will not accept liability for any claims arising as a result of the use of this medium for transmissions by or to SEMIKRON.

______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
______________________________________________________________________
_______________________________________________
Kst mailing list
Kst at kde.org
https://mail.kde.org/mailman/listinfo/kst