Go Back > Extra Stuff > Programming

Thread Tools
Old 2019-09-15, 08:04   #1
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 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:
pinhodecarlos is offline   Reply With Quote
Old 2019-09-15, 21:30   #2
hansl's Avatar
Apr 2019

5·41 Posts

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

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
Romulan Interpreter
LaurV's Avatar
"name field"
Jun 2011

231208 Posts

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

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.