@BozJ3 wrote:
I appreciate the reply.
I deleted the character in the file, and everything loaded correctly. However, this is a program that is going to be used on new data per a monthly basis, so is there anything that can be done on the programming side to avoid the issue? I would like to avoid manually deleting a few characters every time that new data is pulled.
If the data field corresponds to something that users enter free-form text into, such as a comment box, case notes or similar this may be an issue that doesn't occur often. It may be that letting the source of the file know that "unexpected" characters are appearing in one or more fields may help them adjust the creation of the extract to exclude such or filter at an earlier stage of processing.
If the field is the result of some operation then it may help to file provider clean up a process.
And sometimes files get corrupted from any number of causes. You might verify file size, number of records and bytes both with the file provider to see if what you see is what was intended.
... View more
