[StrongED] Re: Regular Search and Replace on a key?

[Barry E Allen <barry@xxxxxxxxxxxxx>]

In article <6f07aae150.old_coaster@old_coaster.yahoo.co.uk>, Tony Moore
<old_coaster@xxxxxxxxxxx> wrote:
> On 29 Jan 2010, Barry E Allen <barry@xxxxxxxxxxxxx> wrote:

> > I regularly wish to turn a 'TAB' separated document into a Comma
> > Separated Value document. I do this by searching for a TAB (/t) and
> > replacing with a comma (",").

> But, in general, that will not work if one or more of the data fields
> already contains a comma. It would be safer to replace each tab with
> "," (ie three characters), then add " to the start, and end, of each
> line.

I think for the specific documents I have in mind it would always work.

All I want to do is put the search and replace on a single key so that
I don't have to keep typing it in.

All the TSV documents are similar to the extract below:-

Sat 05th Sep 2009{TAB}West Park 2{TAB}Wilmslow 2{TAB}29 - 18
Sat 05th Sep 2009{TAB}Vale of Lune 2{TAB}Leigh 3{TAB}86 - 0
Sat 05th Sep 2009{TAB}Wigan 2{TAB}Blackburn 2{TAB}17 - 13
Sat 05th Sep 2009{TAB}Preston Grasshoppers 3{TAB}Fylde 3{TAB}3 - 5

Which I turn into:-

Sat 05th Sep 2009,West Park 2,Wilmslow 2,29 - 18
Sat 05th Sep 2009,Vale of Lune 2,Leigh 3,86 - 0
Sat 05th Sep 2009,Wigan 2,Blackburn 2,17 - 13
Sat 05th Sep 2009,Preston Grasshoppers 3,Fylde 3,3 - 5

-- 
Barry A.

-- 
To unsubscribe send a mail to StrongED+unsubscribe@xxxxxxxxxxxxxx