Simple question - tab delimited file to database

[robstacey]

I have a question regarding the solution that you have provided here.

I have a similar file that when reading the tab delimited line I may have as
many as 60 blank fields at a time. When using the solution that you have
recommended here it catches every other blank tab delimited field. for
example: tab" "tab" "tab" "tab" "tab" "tab will only return three of the values
that I sub in for the blank space, where as it should be returning five.

Thoughts of how to resolve this?

Thanks in advance.

[robstacey]

In response to my own question; you just use the above replace statement (and
accompanying cfif statements) twice or I found a little function that will do
all the work for you and then dump everything into an array.

The function is GetTabTextFeed and can be located at:
[url]http://www.cflib.org/udf.cfm?ID=855[/url].