> 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?
Use the Java split function, it will not concatenate consecutive
delimiters.
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
