Discussion (6)3
Log in or sign up to continue

Thanks - simple example is:

do ##class(%SQL.Statement).%ExecDirect(,"select top 10 'foo'").%DisplayFormatted("CSV",,,.filesUsed)
do ##class(%Stream.FileCharacter).%OpenId(filesUsed(1)).OutputToDevice()

As it says in the Class Reference, "NOTE: pFormat of CSV/100 is not a true comma separated value, but instead uses TAB separated values."


I think that there is a 'DOS CSV' file format that dows use COMMAS but I am not sure how you would specify it. In Excel, it is one of the options when exporting a spreadsheet to a delimited text file.