Unfortunately, the files are too large for a strtran.
>If file is not to big, you can STRTRAN empty dates to nulls.
STRTOFILE( STRTRAN( FILETOSTR("test.txt"), "/ / : :", "Null"), "Testnull.txt")
>
>>We are using the following command to create the text file for a SQL bulk insert:
>>
>>
>>Copy To < filename > Delimited With "" With Character "|"
>>
>>
>>We need to be able to propagate nulls for datetime into the SQL but these are being converted to empty datetimes in the text file.
>>
>>We can change nulls to a bogus date like {12/31/9999 12:00:00 AM} and reconvert to null once the data is brought into SQL.
>>
>>Is there a way to preserve the null values as part of the copy to?
>>
>>TIA