Import question

Don Coleman dcoleman at dgcreact.com
Mon Mar 20 12:36:08 PST 2006


I have an import process that imports a text file via Windows Task scheduler
every 4 minutes.  Following is the beginning of one line copied from that
text file which will not import.

06914995:02:47:42 PM: :SMC:	(copied/pasted from the imported text file)

This is a colon field-delimited file.  My filePro import process stops
reading data after the apparent blank space after the "PM:".  My hex editor
says this field contains a hex 00 NUL and each variable after this field
shows as a blank value.  The import process then continues as expected
beginning with the next record (NL).  This problem arose after a software
update to the alien application creating the file.  They have been unable to
explain or correct the issue on their end so it looks like I have to program
around it.  This happens in a limited number of random records (1-10/day)
out of up to 25,000 records in the file.  Any suggestions on how to program
around this so the file does not have to be manually edited.  In order to
fix presently you must open the file with a text editor and delete that
"invisible" character.  It then imports correctly.  

Thanks you for any advice

Don Coleman
Donald G. Coleman, Consultant
402 Andrew Circle
Indiana, PA 15701
dcoleman at dgcreact.com
(724) 349-6302





More information about the Filepro-list mailing list