>>Hi Gang!
>>
>>Question....
>>
>>Do you have any VFP code that will allow you to remove repetitious lines in a text file of data?
>>
>>For example.......
>>
>>

>>NHC01A78717871         1 1         diaganosis                                                                                                  2    20130409095657
>>NHC01A78717871         3 1         Lay off the Doritos                                                                                         2    20130409095657
>>NHC01A78717871         4 1         Activity                                                                                                    2    20130409095657
>>NHC01A78717871         5 1         Ancillary orders                                                                                            2    20130409095657
>>NHC01A78717871         6 1         dr orders                                                                                                   2    20130409095657
>>NHC01A78717871         7 1         rehabs                                                                                                      2    20130409095657
>>NHC01A78717871         8 1         >This annoyed me pretty much                                                                                2    NHC01A78717871         1 1         diaganosis                                                                                                  2    20130409095657
>>NHC01A78717871         3 1         Lay off the Doritos                                                                                         2    20130409095657
>>NHC01A78717871         4 1         Activity                                                                                                    2    20130409095657
>>NHC01A78717871         5 1         Ancillary orders                                                                                            2    20130409095657
>>NHC01A78717871         6 1         dr orders                                                                                                   2    20130409095657
>>NHC01A78717871         7 1         rehabs                                                                                                      2    20130409095657
>>NHC01A78717871         8 1         >This annoyed me pretty much                                                                                2    
>>
>>.... and so on........
>>
>>

>>
>>As you can see, the data repeats every so often....... in general, it won't be this nice, but there will be repeating lines of data in the text file.
>>
>>I'd like to just send over unique lines of text, since the other end receiving it does not want repeating rows of data, they only want unique data.
>>
>>Thanks for any help!!!
>>
>>Tommy
>
>How about pulling that data into a table (looks like it could be SDF format) and then do a select distinct query?

Sounds good........... Thanks!!