Re: fixing an horrific formatted csv file.

2014-07-04 Thread F.R.
On 07/04/2014 12:28 PM, flebber wrote: On Friday, 4 July 2014 14:12:15 UTC+10, flebber wrote: I have taken the code and gone a little further, but I need to be able to protect myself against commas and single quotes in names. How is it the best to do this? so in my file I had on line 44

Re: fixing an horrific formatted csv file.

2014-07-02 Thread F.R.
On 07/02/2014 11:13 AM, flebber wrote: TM = TX.Table_Maker (headings = ('Meeting','Date','Race','Number','Name','Trainer','Location')) TM (race_table (your_csv_text)).write () Where do I find TX? Found this mention in the list, was it available in pip by any name?

Re: fixing an horrific formatted csv file.

2014-07-01 Thread F.R.
On 07/01/2014 04:04 PM, flebber wrote: What I am trying to do is to reformat a csv file into something more usable. currently the file has no headers, multiple lines with varying columns that are not related. This is a sample Meeting,05/07/14,RHIL,Rosehill Gardens,Weights,TAB,+3m Entire

Re: Storing the state of script between steps

2014-02-22 Thread F.R.
On 02/21/2014 09:59 PM, Denis Usanov wrote: Good evening. First of all I would like to apologize for the name of topic. I really didn't know how to name it more correctly. I mostly develop on Python some automation scripts such as deployment (it's not about fabric and may be not ssh at all),

Puzzling PDF

2014-02-16 Thread F.R.
Hi all, Struggling to parse bank statements unavailable in sensible data-transfer formats, I use pdftotext, which solves part of the problem. The other day I encountered a strange thing, when one single figure out of many erroneously converted into letters. Adobe Reader displays the figure

Re: Puzzling PDF

2014-02-16 Thread F.R.
On 02/16/2014 05:29 PM, Emile van Sebille wrote: You On 2/16/2014 6:00 AM, F.R. wrote: Hi all, Struggling to parse bank statements unavailable in sensible data-transfer formats, I use pdftotext, which solves part of the problem. The other day I encountered a strange thing, when one single

Re: Where does MySQLdb put inserted data?

2013-10-05 Thread F.R.
On 10/05/2013 12:55 AM, Dennis Lee Bieber wrote: On Fri, 04 Oct 2013 09:38:41 +0200, F.R. anthra.nor...@bluewin.ch declaimed the following: snip convoluted unformatted stuff MySQLdb, as with all DB-API compliant adapters, does NOT do auto-commit -- you MUST execute a con.commit() after

Where does MySQLdb put inserted data?

2013-10-04 Thread F.R.
Hi, As of late clipboard pasting into a terminal sometimes fails (a known bug, apparently), I use MySQLdb to access MySQL tables. In general this works just fine. But now I fail filling a new table. The table exists. mysqlEXPLAIN new_table; explains and root@blackbox-one:/# sudo/find /

Re: Where does MySQLdb put inserted data?

2013-10-04 Thread F.R.
On 10/04/2013 09:38 AM, F.R. wrote: Hi, As of late clipboard pasting into a terminal sometimes fails (a known bug, apparently), I use MySQLdb to access MySQL tables. In general this works just fine. But now I fail filling a new table. The table exists. mysqlEXPLAIN new_table; explains

Re: Where does MySQLdb put inserted data?

2013-10-04 Thread F.R.
On 10/04/2013 12:11 PM, Chris Angelico wrote: On Fri, Oct 4, 2013 at 8:05 PM, F.R. anthra.nor...@bluewin.ch wrote: Off list? MySQL is. MySQLdb is not. Before I know which of the two is the culprit, I don't know whether I'm off list or not and take the risk, prepared to beg pardon if I am

Re: A data transformation framework. A presentation inviting commentary.

2013-08-22 Thread F.R.
On 08/21/2013 06:29 PM, F.R. wrote: Hi all, In an effort to do some serious cleaning up of a hopelessly cluttered working environment, I developed a modular data transformation system that pretty much stands. I am very . . . etc Chris, Terry, Dieter, thanks for your suggestions. Chris

A data transformation framework. A presentation inviting commentary.

2013-08-21 Thread F.R.
Hi all, In an effort to do some serious cleaning up of a hopelessly cluttered working environment, I developed a modular data transformation system that pretty much stands. I am very pleased with it. I expect huge time savings. I would share it, if had a sense that there is an interest out

ElementTree: can't figure out a mismached-tag error

2013-07-11 Thread F.R.
Hi all, I haven't been able to get up to speed with XML. I do examples from the tutorials and experiment with variations. Time and time again I fail with errors messages I can't make sense of. Here's the latest one. The url is http://finance.yahoo.com/q?s=XIDEQql=0;. Ubuntu 12.04 LTS, Python

Re: ElementTree: can't figure out a mismached-tag error

2013-07-11 Thread F.R.
On 07/11/2013 10:59 AM, F.R. wrote: Hi all, I haven't been able to get up to speed with XML. I do examples from the tutorials and experiment with variations. Time and time again I fail with errors messages I can't make sense of. Here's the latest one. The url is http://finance.yahoo.com/q?s

Re: draw a line if the color of points of beginning and end are différent from white

2013-03-06 Thread F.R.
On 03/06/2013 06:46 PM, olsr.ka...@gmail.com wrote: how can i draw a line if the point of the begining and the end if those points are différent from the white in other exepretion how can i get the color of two points of the begining and the end? please help me This should get you

MySQL - create table creates malfunctioning tables

2013-01-24 Thread F.R.
The other day, for unfathomable reasons, I lost control over tables which I create. There was no concurrent change of anything on the machine, such as an update. So I have no suspect. Does the following action log suggest any recommendation to experienced SQL programmers? 1. A table: mysql

Strange object identity problem

2012-11-12 Thread F.R.
Hi all, Once in a while I write simple routine stuff and spend the next few hours trying to understand why it doesn't behave as I expect. Here is an example holding me up: I have a module st with a class runs. In a loop I repeatedly create an object ba and call the method ba.run () which

Re: Strange object identity problem

2012-11-12 Thread F.R.
On 11/12/2012 02:27 PM, Robert Franke wrote: Hi Frederic, [...] bas = {} for year in range (2010, 2013): ba = st.runs ('BA', '%d-01-01' % year, '%d-12-31' % year) ba.run () print year, id (ba) bas [year] = ba 2010 150289932 2011 150835852 2012 149727788 for y in sorted

Re: Strange object identity problem

2012-11-12 Thread F.R.
On 11/12/2012 06:02 PM, duncan smith wrote: On 12/11/12 13:40, F.R. wrote: On 11/12/2012 02:27 PM, Robert Franke wrote: Hi Frederic, [...] bas = {} for year in range (2010, 2013): ba = st.runs ('BA', '%d-01-01' % year, '%d-12-31' % year) ba.run () print year, id (ba) bas

Re: [Gimp-user] export to non xcf

2012-10-29 Thread F.R.
On 10/28/2012 09:09 PM, Michael Schumacher wrote: Von: Donald Miller damill...@gmail.com Can't directly save to jpg, so exported. Export to jpg made png. Same for psd. Shouldn't name track chosen format, so no manual override needed? Maybe you had set the file-type chooser to this format? The

Re: attaching names to subexpressions

2012-10-28 Thread F.R.
On 10/28/2012 06:57 AM, Devin Jeanpierre wrote: line = function(x, y, z) while line: do something with(line) line = function(x, y, z) How about: line = True while line: line = function(x, y, z) do something with(line) ? Frederic --

Re: Regex help needed!

2009-12-24 Thread F.R.
On 21.12.2009 12:38, Oltmans wrote: Hello,. everyone. I've a string that looks something like lksjdflsdiv id ='amazon_345343' kdjff lsdfs/div sdjflsdiv id = amazon_35343433sdfsd/divdiv id='amazon_8898'welcome/div From above string I need the digits within the ID attribute. For