Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Using the SQL Shell Interface - changing the delimiter in the outputted
Question
· Jul 31, 2020

Using the SQL Shell Interface - changing the delimiter in the outputted

cache 2017.2 windows 10

Is there any way to change the sql Shell interface to output a <TAB> between the fields instead of outputting one or more spaces between columns

 

I needed to run an sql ( that took a while to run) and then  cut and paste the generated output into excel, trouble was the paste into excel was not very good for columns when there's spaces used between the columns

 

kev

#SQL #Caché
Source URL:https://community.intersystems.com/post/using-sql-shell-interface-changing-delimiter-outputted