Grouping data from a text file

[cobweb]

Hi guys:
here is a puzzler: I am importing a text file for units. Every line represents a unit, so I can have 10 identical lines, each with a unit of 1. Is there any way of converting these 10 lines of 1 unit to a single line, quantity 10? A line has over 15 fields but I may be able to reduce the number that uniquely define an identical unit (say height, width, colour,etc). Note also that the imported file does not just have the 15 identical units - there could be lots of lines, not all of which are identical.

 

[TonyMcGuire]

It sounds like you need to first bring the data in, then break it up into multiple tables with linking key fields.

Which kinda defines an RDBMS, like Paradox.

But you need to bring the data in, and then start analyzing the contents and separating the data.

Tony McGuire

http://www.thedbcommunity.com

"It's not about having enough time. It's about priorities