Strip unneeded info from the exported CSV file

Question

I'm using this batch script to export the result of SQL-script in a tab-delimited CSV.

sqlcmd -S PRISHA-CRM  -i "C:\Users\Administrator\Desktop\test.sql" -U essl1 -P essl  -o C:\outputfile.csv  -s " "

Tried multiple things but it's not working.

Show us the things you have tried and specify how they are not meeting expectation. — lit, Nov 16 '15 at 15:59
Check the answer at http://stackoverflow.com/questions/425379/how-to-export-data-as-csv-format-from-sql-server-using-sqlcmd — lit, Nov 16 '15 at 19:07
What is "**tab**-delimited **C**SV"?? note that the '**C**' stands for "**C**omma"... — aschipfl, Nov 17 '15 at 01:00

score 0 · Answer 1 · answered Nov 16 '15 at 19:27

0

If you want to remove the dashed lines then pipe your output to the FINDSTR command and then redirect to the output file.

sqlcmd -S PRISHA-CRM  -i "C:\Users\Administrator\Desktop\test.sql" -U essl1 -P essl -s " " | findstr /R /C:"^[^-]*$" >C:\outputfile.csv

Don't know anything about SQLCMD so I don't know why you are getting data in B4.

answered Nov 16 '15 at 19:27

Squashman

Hi its not working with data ... need Tab delimited .. only colum hedding is coming that to not in proper format – Sailesh Agarwal Nov 17 '15 at 08:14

1 Answers1