From: John T. <ma...@dc...> - 2004-05-04 02:47:13
|
Hi to all, I'm trying to compare two files, containing share price quotes, using = only the first part of each line (ie, the exchange Code). I'm not = interested in the differences in quotes, but am trying to determine = which Codes appear in one file but not in the second file. I realise = that I need to use Regular Expression(s) but I'm not having any luck and = would appreciate some help. The original data lists look like this: BAR,20031126,0.062,0.065 = BANIYD,20031126,212.73,212.73BAROA,20031126,0.00,0.00 = BAR,20031126,0.062,0.065BGDOA,20031126,0.033,0.033 = BGD,20031126,0.185,0.185BGF,20031126,0.115,0.115 = BGDOA,20031126,0.033,0.033BGN,20031126,0.275,0.28 = BGF,20031126,0.115,0.115BHL,20031126,0.00,0.00 = BGN,20031126,0.275,0.28BHP,20031126,11.10,11.11 = BHFHA,20031126,112.704,112.704BHPDMF,20031126,0.00,0.00 = BHL,20031126,4.85,4.85 = BHP,20031126,11.1,11.11 = BHPDMF,20031126,5.25,5.25I would like the result, after applying a = Regular Expression to the compare, to look like this: BANIYD,20031126,212.73,212.73 BAR,20031126,0.062,0.065 BAR,20031126,0.062,0.065 BAROA,20031126,0.00,0.00 BAROA,20031126,0.02,0.02 BGDOA,20031126,0.033,0.033 BGDOA,20031126,0.033,0.033 BGF,20031126,0.115,0.115 BGF,20031126,0.115,0.115 BGN,20031126,0.275,0.28 BGN,20031126,0.275,0.28 BHFHA,20031126,112.704,112.704 BHL,20031126,0.00,0.00 BHL,20031126,4.85,4.85 BHP,20031126,11.10,11.11 BHP,20031126,11.1,11.11 BHPDMF,20031126,0.00,0.00 BHPDMF,20031126,5.25,5.25 TIA Cheers, John |