[Kst] Antw: Re: Date and time in csv

Wed Feb 25 13:48:17 UTC 2015

Dear Matthias,

It is no live data => sed is an option. But did want to make sure that
I don't start re-inventing wheels again.
Thanks a lot for the quick answer,

   Gunter.

Gunter Königsmann
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 Nürnberg, Germany 
Amtsgericht Nürnberg HRA 13650
Komplementär:
SEMIKRON Elektronik Verwaltungs GmbH
Amtsgericht Nürnberg HRB 21338
Geschäftsführer: 
Harald Jäger
Christian Müller
Peter Sontheimer

>>> "Berse, Matthias" <Matthias.Berse at raith.de> 25.02.2015 13:37 >>>
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 

_______________________________________________
Kst mailing list
Kst at kde.org 
https://mail.kde.org/mailman/listinfo/kst

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.
______________________________________________________________________