>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


Import it in a cursor, then SELECT DISTINCT and export it back as text file :-)