table, but unfortunately the file has a ton of empty values. I�ve tried to
do a search/replace for:
chr(9) & chr(9)
replacing with:
chr(9) & �NULL� & chr(9)
Also searching for:
chr(9) & chr(13) & chr(10)
replacing with:
chr(9) & �NULL� & chr(13) & chr(10)
I�ve done this as filler for CF to loop over, since CF will ignore empty
values in a string. I actually have called the same search/replace several
times in a row, and have been able to get most of the empty cells with the
�NULL� placeholder, but for some reason there are still some empty values.
Does anyone have an idea for a solution?
Thank you,
Stan Winchester
[EMAIL PROTECTED]
http://www.aftershockweb.com/
Tel. 503-244-3440
Fax 503-244-3454
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
