maybe more windows friendly...if you have notepad++ installed you can do an extended search for things like line breaks (nr or the opposite, you can view all characters and do a search to figure out which), then just replace the line breaks. You'd still have to do line 1 though. I do this all the time and find it more convenient since I use notead++ as my primary editor...it can also do regex, but I spend more time on the syntax :)

Example: when viewing your file with all characters on it will look like this: col1,col2,col3CRLF

with extended search on do a find and replace Find: nr Replace with: nrIsle of Wight, Results in: col1,col2,col3CRLF Isle of Wight,col1,col2,col3CRLF

Just for reference, my quick and dirty, no-error-checking approach to doing this in Ruby would be something like:

 Dir.glob("*/*.csv").each {|f|
     data=File.open(f).readlines
     m=f.match /(.*)\\/(.*)\\.csv/
     council=m[1]
     ofile=m[1] + "/" + m[2] + "_edit.csv"
     g=File.open(ofile,"w")
     lineno=0
     data.each {|r|
      if lineno==0
       g.write("Council, #{r}")
       lineno += 1
      else
       g.write("\\"#{council}\\",#{r}")
      end
     }
     g.close
    }

Which could be done more succinctly, but I think it handles the multi-file thing quite nicely. Name the folders with council files with the name of the council. Obviously it would be better if it took command line arguments and allowed for the insertion in a different column etc etc, but it is a starting place (oh, and it used Unix style file separators, not Windows ones - I should use File.join or some function like that but I can never remember it!)

In python it's like this:

import csv
fileobj = open('path-to-file')
outobj = open('outfilepath', 'w')
for count,row in enumerate(csv.reader(fileobj)):
     # row is a list [col1, col2, ...]
     if count == 0: # first row is headings
          newval = 'Name of Council'
     else:
          newval = 'nameofcouncil'
     row.append(newval)
     writer.write_row(row)

In Google Refine, start a new project with your council csv file. Once open, do the following:

1. Go to the 'undo/redo' tab
2. Click the 'apply' button

3. Paste the following code in there (and replace "isle of wight council" with whatever council's name you're dealing with, and "x" with whatever your current first column is called)

   [{ "op":"core/column-addition", "description":"Create column council at index 0 based on column data.gov.uk uri using expression grel:"isle of wight council"", "engineConfig":{ "facets":[], "mode":"record-based" }, "newColumnName":"council", "columnInsertIndex":0, "baseColumnName":"x", "expression":"grel:"isle of wight council"", "onError":"set-to-blank" } ]

4. Click "perform operations"

5. Done

Open up the csv file in Jedit or any other text editor with regular expressions.

Select Find/replace, switch 'regular expressions' on

Find: ^

Replace: Isle of Wight Council,

Hit "replace all"

Done

also give Google Refine a look, great tool for data munging in many formats...

The Nike Air Classic BW has been popping up Nike Requin en masse it seems and the latest Nike Tn colorway is this one that Nike TN Chaussures makes use of a healthy dose Nike Tn Pas Cher of team orange. The hard to Nike Chaussures deny colorway Tn Pas Cher features a white leather and mesh Nike Tn upper trimmed in black with a hint of grey Tn Requin around its rim while team orange highlights the entire affair. The leather takes these FiveFingers to Vibram 5 Fingers the next level by making them Five Finger Shoes both super durable, Vibram Five Fingers a bit warmer, and a bit classier.? Five Finger Shoes They look great with jeans, too.? 5 Five Shoes While I'm sure you could run or Vibram 5 Fingers hike in the Trek LS, I'm not sure you're going to want to Vibram 5 Fingers as these are just nice and meant more Vibram Shoes for everyday wear though the leather Vibram Five Fingers can assuredly take a beating. Honestly, can totally designer handbags evening show Coach Outlet Store Online your individual style Coach Factory Outlet and originality. If you are an attractive focal point in the game, Coach Outlet Online then you should better choose a Coach Outlet handbag latest collection of exquisite.