January 27, 2011 at 8:07 am
Hello, I am trying to export data with over 200 columns to fixed width and output seems to be without row delimiter.
I did find out that eliminating header column solves some
problems but makes it harder on receiving party to validate. We can live with that but I can't deal with shoving my data to a 2000 SQL box to get fixed width out!!!
Talk about feeling STUPID!
January 27, 2011 at 8:11 am
You have to change to Ragged Right instead of Fixed Width. Fixed Width is for mainframe output, which doesn't use row delimiters.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
January 27, 2011 at 8:59 am
BLESS YOU, GMAN!!!!
You have just made my day a lot easier!
THANK YOU!
January 28, 2011 at 6:20 am
You're welcome.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply