Re: Need to compare two datagrids

Easier to work with SQL. Dump your data into two memory resident sqLITE databases and use SQL for your comparisons. I did mention quite a while ago how nice it would have been to get a single column of data from a data grid. But it would not be too difficult to get into the library and write the

Re: Need to compare two datagrids

Peter and Phil, thank you so much... it worked perfectly! On Mon, May 5, 2014 at 6:12 PM, Peter Haworth wrote: > On Mon, May 5, 2014 at 2:53 PM, Peter Haworth wrote: > > > filter lines of tdg2Text matching tRegexp into tTemp > > > And yet another correction to the filter syntax: > > filter lin

Re: Need to compare two datagrids

On Mon, May 5, 2014 at 2:53 PM, Peter Haworth wrote: > filter lines of tdg2Text matching tRegexp into tTemp And yet another correction to the filter syntax: filter lines of tdg2Text with regex pattern tRegexp into tTemp I tested the code this time and it seems to work. Pete lcSQL Software

Re: Need to compare two datagrids

On Mon, May 5, 2014 at 2:42 PM, Peter Haworth wrote: > filter lines of tdg2Text with item 1 of of rLine into tTemp I think that line should be: filter lines of tdg2Text with (item 1 of rLine & tab) into tTemp That should work as long as item 1 doesn't appear in anything other than the first

Re: Need to compare two datagrids

Hi Skip, Following Phil's suggestion, I think you could do this using the filter command, something like this: put the dgText of group dg1 into tdg1Text put the dgText of group dg2 into tdg2Text set the itemdelimiter to tab repeat for each line rLine in tdg1Text filter lines of tdg2Text with it

Re: Need to compare two datagrids

Hi Skip, If it would make it easier (as in "doable"), why not put the dgText of the data grids into variables and work with the data in that form? That's probably what I would do. Then update each data grid with its updated dgText list at the end. Or if you're an "array person" you might pre

Need to compare two datagrids

I have two datagrids that I need to compare column 1. I then need to separate these two lists out into additional datagrids. For instance, datagrid 1 contains three columns: 1234, ItemA, ItemDetails 1235, ItemB, ItemDetails 1236, ItemC, ItemDetails Datagrid 2 contains three columns: 1234, ItemA,