>>I have a text file that is being created by VFP, and it has some blank dates in it - so when they do the export it looks like this:
>>
>>|01/15/2017|/ /|02/17/2016
>>
>>..the problem is that part where it says "/ /" -- well I need that to be completely blank with no spaces or anything -- so that the line in the file ends up looking like this:
>>
>>|01/15/2017||02/17/2016
>>
>>Anyone know of an easy way to do this? Or maybe a tweek to the COPY TO command that's creating the file to being with???
>>
>>Thanks :)
>
>
>select cFld, evl(dFld, .null.), etc. from source into cursor xx
>set nulldisplay to ''
>copy to…
>
Well this seems to work
SET NULLDSIPLAY TO ''
SELECT DTOC(evl(myDateField, .null.)) FROM myTable
COPY to myfile.txt delimited with "" with character '|'
If I don't have the DTOC in there then I still end up with the / / stuff in the text file. This will get me what I need ---- thanks guys!!!
ICQ 10556 (ya), 254117