>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?
