Qasim
-----Original Message-----
From: Stan Winchester [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 30, 2003 4:27 PM
To: CF-Talk
Subject: looping over empty values
I am trying to do an import from a tab-delimited file into a SQL Server
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]
