I've bumped into a odd situation. Not sure where to turn.
The database code creates some tables specifically for the purpose of being in the correct layout format to be exported to CSV, for import into another application. the Transfertext command has been used for this for some years without fail.
This week, it began duplicating just a few records. The source table has 6,362 records (and no dups - i checked). The resulting csv export file has 6,373. I found the 11 duplicates. They are in the upper middle of the export file, 11 contiguous records that are simply repeated as in A, B, C, D, D, E, E, F, F, G, G,... and then it continues with the rest of the file correctly after those 11 records.
I copied/ pasted the dups to Word and the character count is exactly the same, so each set of two records is identical.
The 11 records are not new to the database, although one or more of the fields within those records may have changed in the past week. Could some hidden character somehow trigger a transfertext command to duplicate the record?? I was thinking of shaving off characters from the dup'd records to see if the issue disappeared. Is that idea folly?
Any ideas??? Thank you.