Cool, didn't know that - I'll run it under the microscope and see what's there.

Thanks!


>PMFJI, but VFP ships with a nice little Hex Editor

>Do (Home(1)+'tools\hexedit\hexedit.app')

>
>>Well, I swear I've used tab delimited just fine before, which is what's puzzled me about this particular file. I may have to take a look at it with a low-level tool to see if there's a character embedded that Word & VFP don't see. In any case, it did work to pull the file into a memo field, do a strtran for two tabs in a row, inserting a "0" in between them, then dumping the file back out. With that, it imports just fine and I just ignore the zeroes in the pertinent fields. So, I'm good to go until I get the next one from the client that has something else strange :-)
>>
>>Yes, I agree, your file and the one I have should both work fine. go figure.
>>
>>Thanks!
>>
>>>Works fine for me in a simple test below. What is different in your case?
>>>

>>>#DEFINE ccTAB CHR(9)
>>>
>>>CREATE CURSOR Test (pk i, cf1 C(10), cf2 C(10), cf3 C(10), cf4 C(10), cf5 C(10))
>>>
>>>TEXT TO lcStr TEXTMERGE NOSHOW
>>>1<<ccTAB>>11<<ccTAB>>12<<ccTAB>>13<<ccTAB>>14<<ccTAB>>15 
>>>2<<ccTAB>>21<<ccTAB>>22<<ccTAB>>23<<ccTAB>>24<<ccTAB>>25 
>>>3<<ccTAB>>31<<ccTAB>><<ccTAB>>33<<ccTAB>><<ccTAB>>35 
>>>4<<ccTAB>>41<<ccTAB>><<ccTAB>><<ccTAB>><<ccTAB>>45 
>>>ENDTEXT
>>>
>>>lcFile = "Temp.txt"
>>>STRTOFILE(lcStr, lcFile)
>>>
>>>APPEND FROM (lcFile) TYPE DELIMITED WITH TAB
>>>

>>>
>>>>Has anyone run into a problem with VFP "skipping" empty tab-delimited fields when using an append from command? I have a file where just a few records are not importing properly and see that the file has three empty tabs in a row and VFP simply moves to the next populated field and starts populating away from there!
>>>>
>>>>There is another instance in the file where there are three similar blank fields (toward the end of a record) and it imports just fine with empty fields. I've looked at the file with the "show whitespace" and also with Word in show formatting codes mode. I see no difference in the file points that work with the ones that dont.
>>>>
>>>>I suppose I can scan down the file looking for two simultaneous tabs, inserting a space between them (hopefully that will work), but seems like such an obvious thing that should just work.
>>>>
>>>>Has anyone else run into this problem?