Options

Save File with Customer Delimiter

sjackersjacker Posts: 2
edited January 13, 2015 3:06PM in SQL Multi Script
We have the need to save a set of results to a file using a Custom Delimiter. In our case, the file needs to be delimited with a semi-colon. Management Studio has this option, so we’ll get it done, but we will need to run the query once for each of our 43 databases. If we could use SQL Multi Script, that would be wonderful!

Is there a way to do this in SQL Multi Script that we haven’t found?

Maybe this option is already in development?
· Share on Twitter

Comments

  • Options
    Andrew PAndrew P Posts: 194 Silver 3
    Hello Sjacker,

    Thanks for reaching out to us!

    Currently you cannot specify a custom delimiter within Multiscript, but you might be able to output to a .csv file then do a "Find And Replace All" with Notepad++ to get the formatting right. In any case I have submitted a feature request SE-684, so it is up to the project managers to triage accordingly.

    Please let me know if you have any questions.

    Warmly,
    Andrew Pierce
    Product Support Engineer - Redgate
    Andrew Pierce
    Technical Sales Engineer
    Redgate Software
    · Share on Twitter
Sign In or Register to comment.