Avatar of RUA Volunteer2?
RUA Volunteer2?
Flag for United States of America asked on

Column wrapping when Copy&Paste or export data from SQL Server to Excel with large string column

I have a MS SQL SERVER query that I run. One of the field/columns is huge. Called Raw_Results If the results are say 1200-1400 characters long and.......
and I need to export them to a file in excel. Current version. How could I do that cleanly. 

Why because the results of that column wrap on export. Thus messing up the file because I cant get clean columns.  

Is there a way in SQL or EXCEL that might correct that. I heard that there might be a CHAR(??) function or something that might do it or maybe some setting in excel or in the SQL Export tool that can solve this problem?

Microsoft SQL ServerMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
aikimark

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
aikimark

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Peter Chan

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
RUA Volunteer2?

ASKER
aikimark
Yes there may be some carriage returns in there but I am not sure how to check that other than copy the record out and past it and try to find it to see if I can find one.

I will try all the others options.
The copy & paste seems to be the most problematic. I could not find Tab-Delimiter feature in the SQL export does not seem to be obvious. These look like all good solutions I will try them. Thank you all.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy