Error when exporting data from SQL output to csv

Question

I have a SQL that has one of the columns that stores value that begins with a hyphen '-'. When I tried to export it to csv I get an Invalid Name error. When I view it in the SQL editor it shows correctly (Sample : -Coke).

Is there anyway I could have this value saved successfully in the csv file ?

Given below is a sample view of the data

Name
-Coke
-Pepsi

Sample SQL I used:

SELECT name FROM sales WHERE name like '-%';

I am using a Redshift DB.

If you use ms excel import the file with column data format as text — rgen3
– rgen3, Commented Oct 17, 2018 at 8:00
So how exactly did you "export it to CSV"? Which tool did you use for that? — user330315
– user330315, Commented Oct 17, 2018 at 9:59
Very hard to give any advice unless you explain how you are exporting the data to a CSV file. — Nathan Griffiths
– Nathan Griffiths, Commented Oct 18, 2018 at 1:24
@Nathan, I am trying to export the SQL output to a csv file from the SQL editor — Kevin Nash
– Kevin Nash, Commented Oct 18, 2018 at 5:48
So, which SQL editor? And where are you seeing the "Invalid Name" error? In the SQL editor? In Excel? You might want to take a look at these tips for writing a question that gives you the best chance of getting a useful answer: stackoverflow.com/help/how-to-ask — Nathan Griffiths
– Nathan Griffiths, Commented Oct 18, 2018 at 19:23

PrathapG · Accepted Answer · 2018-10-17 08:57:03Z

1

Run the query SELECT name FROM sales WHERE name like '-%';

Select the all results and right click on it and select Copy with headers then, paste it in Excel. Now save excel as a CSV. Done...

answered Oct 17, 2018 at 8:57

PrathapG

7891 gold badge7 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Meyyappan · Accepted Answer · 2018-10-17 09:57:04Z

0

You can create a view with your "SELECT name FROM sales WHERE name like '-%';" query, then right click on the database and use Tasks->Export Data in ssms. "Flat file Destination" needs to be selected in "choose destination' if you need the result in csv

answered Oct 17, 2018 at 9:57

Meyyappan

3442 silver badges4 bronze badges

Collectives™ on Stack Overflow

Error when exporting data from SQL output to csv

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related