mersenneforum.org  

Go Back   mersenneforum.org > Extra Stuff > Programming

Reply
 
Thread Tools
Old 2019-09-15, 08:04   #1
pinhodecarlos
 
pinhodecarlos's Avatar
 
"Carlos Pinho"
Oct 2011
Milton Keynes, UK

498910 Posts
Default Parse data

Hi all,

Whilst enjoying the sunny Crete I was thinking about work, this is my last day...lol. What’s the best programming language to parse data and send back to a FTP server. If I am not mistaken the third party company we use for our energy management system uses python.

What I’m looking for is how to parse the half hourly data from my clients energy data onto the format we use in our energy management system. I easily made a few examples on excel just not yet on VB a way to stream onto a FTP server. The input and outputs can be all sort of formats from data in rows or columns, etc etc. I suppose the big thing here is the ability of the third party to host a server where they can link and run a script to interface between client energy supplier - third party server - my EMS.

Available formats can be found here: https://support.dexma.com/hc/en-gb/a.../360007967433-
pinhodecarlos is offline   Reply With Quote
Old 2019-09-15, 21:30   #2
hansl
 
hansl's Avatar
 
Apr 2019

5·41 Posts
Default

Looks like 90% or so of those files are some form of CSV. IF you want to use python, there's a csv api in the standard library https://docs.python.org/2.7/library/csv.html

I think I saw one that said xml, Beautiful Soup is a good library for that.

Last fiddled with by hansl on 2019-09-15 at 21:30
hansl is offline   Reply With Quote
Old 2019-09-16, 05:55   #3
LaurV
Romulan Interpreter
 
LaurV's Avatar
 
"name field"
Jun 2011
Thailand

231208 Posts
Default

Quote:
Originally Posted by pinhodecarlos View Post
the best programming language to parse data
mmm... Perl? (or or any regex aware language, but nothing beats Perl here).
LaurV is offline   Reply With Quote
Reply

Thread Tools


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't get manual page to parse a result Siegmund PrimeNet 6 2017-01-08 22:22
Corrupted data? Oops! Information & Answers 2 2013-10-22 03:48
GPU TF vs DC/LL data bcp19 GPU to 72 0 2011-12-02 16:41
Data available? Prime95 LMH > 100M 10 2007-06-22 23:55
Anyone have a program to parse out benchmarks? crash893 Software 0 2005-12-21 03:46

All times are UTC. The time now is 19:31.


Sun Dec 5 19:31:46 UTC 2021 up 135 days, 14 hrs, 1 user, load averages: 1.33, 1.32, 1.37

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.

This forum has received and complied with 0 (zero) government requests for information.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.2 or any later version published by the Free Software Foundation.
A copy of the license is included in the FAQ.