wolfkillj (5/13/2013)
I couldn't use your sample data because the text file formatting seemed to be inconsistent from line to line
Exactly. If you check my first post, you'll see where I made that point. That's why we import all rows into a single column in the staging table to begin with.
I need a solution that addresses my current setup, including the inconsistent data.