Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
select * group by part of a field
Sorry for being really unclear people! awesomeheero17 did manage to make sense of it and that's done the trick. For future reference I have fields: group = Iteration 1|ASL|2_01, Iteration 1|ASL|2_02...Iteration 1|ASL|2_27 (I have 2 iterations in this file and the 2_ can also be 1_) time = 0...- Mack1979
- Post #5
- Forum: Microsoft: FoxPro
-
select * group by part of a field
I have a standard (in that I can't change it) output file from a system. Unique rows are identified by the "group" and "time" columns, examples of these are: Iteration 1|ASL|NWPF|2_01, Iteration 1|ASL|NWPF|2_02 and time is just 0-480. I want to merge this output down (removing the final 01/02...- Mack1979
- Thread
- Replies: 4
- Forum: Microsoft: FoxPro
