Oh... it works... it's just the text mode display has a mind of it's own when it comes to calculated column widths... so you need to do something like this......

The problem with the UNC is that the server must be logged in as a "super domain user" than can "see" those other boxes and directories...

JohnG,

What was in the array?  Might help me understand why people would need to pass such a structure to a proc or function... thanks.

Heh... in my case, it's multiple ex-wifes

Nice job, Zach... didn't realize that starting over was an option but I do thank you for the explanation of what you did

Nope... and I feel for ya... you're not the first person I've seen get thrown into these types of duties with no experience... But, heh

Another proverb:

"Before you can think outside the box, you must first realize... that you're in a box."  --Jeff Moden circa 2004

The only tool I use is the large Calcium knob that sits upon my shoulders   Most good-to-excellent Developers and DBA's are able to...

Correct... not portable in most cases... certainly not portable to Oracle.  But I'm not one of those that will forsake the use of a good tool just for some chance...

My first step would be to talk to the vendor providing the data and get them to provide the proper format of having the same number of semicolons on every...

I guess I'd have to say, like anything else, "It depends"

Had one recruiter try to push me into an Oracle job I didn't...

Then, you can do one of two things...

1.  Import to a 3 column staging table (where you can also validate the data before making it live, good safeguard) and transfer...

Oh, I agree... I'm lucky enough to have a similar situation.

Just wanted everyone to know the implicit "dots" work the same way (month before day) on certain servers and not...

Yeah, shame on me... I keep forgetting about that... On other servers, particularly those outside the U.S.A., the reverse failure would be true...

Jonathon

I agree with Kenneth... proper syntax calls for the column name to be followed with either a comma, an AS with an alias followed by a comma, or an alias...