Summary grid

2016-06-22 Thread Jignesh Sutar
Say I have list of data as given in the example code below, I want to find all the unique categories (alphabetic letters) and unique IDs (numbers) and then produce a summary grid as manually entered in the "results". How could I code this? Many thanks in advance, Jignesh data= ["A.1", "A.2", "A.

Extracting parts of string between anchor points

2014-02-27 Thread Jignesh Sutar
I've kind of got this working but my code is very ugly. I'm sure it's regular expression I need to achieve this more but not very familiar with use regex, particularly retaining part of the string that is being searched/matched for. Notes and code below to demonstrate what I am trying to achieve.

Find and replace multiple RegEx search expressions

2014-03-18 Thread Jignesh Sutar
Hi, I'm trying to delete contents of a .txt log file, matching on multiple re.sub criteria but not sure how to achieve this. Below is an illustration of what I am trying to achieve (of course in this example I can combine the 3 re.sub into a single re expression but my actual code will have a doz