1st, i use a tab spaced text file to import.
the 1st and 3rd tabbed areas are fine. Its the 2nd tabbed area that i need help with.
Is there anyway i can run a simple script against the text file or any other way to do this.
1 <TAB> anyplace 123 <TAB> state
1 <TAB> anyplace 133 <TAB> state
1 <TAB> anyplace 233 <TAB> state
1 <TAB> anyplace 155 <TAB> state
1 <TAB> anyplace 555 <TAB> state
basically, i only want to keep the first line. So i want to be able to look at the 2nd tab and if the first (estimate) 6 letters are the same, it will delete the whole line or not import it.
Exact dupes are already not imported. But partials are imported and i want to stop that.
Thanks guys