Good suggestion, although I was hoping for something a bit more straightforward. Nonetheless, that may be the most practical way of doing it. I have experimented with importing various unprintable characters into the fields that I want emptied and that appears to work, at least when you look at the results. However, the characters are still in the fields (you can tell when you export again). If I can find the time, I will try using Batch, or maybe even ODBC.
Thanks,
Sean
Member for
22 years 7 months
Member for22 years7 months
Submitted by Joao Ribeiro on Tue, 2006-01-10 05:46
Member for
21 yearsRE: Importing Log Data
ODBC would certainly be my preferred option rather than batch.
Member for
24 years 4 monthsRE: Importing Log Data
Good suggestion, although I was hoping for something a bit more straightforward. Nonetheless, that may be the most practical way of doing it. I have experimented with importing various unprintable characters into the fields that I want emptied and that appears to work, at least when you look at the results. However, the characters are still in the fields (you can tell when you export again). If I can find the time, I will try using Batch, or maybe even ODBC.
Thanks,
Sean
Member for
22 years 7 monthsRE: Importing Log Data
Have you considered using the batch utility?