wbexport

17 views
Skip to first unread message

GT

unread,
Jul 6, 2023, 3:50:27 PM7/6/23
to SQL Workbench/J - DBMS independent SQL tool
I have a txt output file that is exporting one column via Wbexport...

so as an example it looks like

abc
def
ghi
jkl

I would like it to look like

abc | def | ghi | jkl

I cannot seem to get rid of the carriage return.
any thoughts?

Thomas Kellerer

unread,
Jul 7, 2023, 2:59:42 AM7/7/23
to sql-wo...@googlegroups.com
WbExport writes each row from the query into one line of the output file

If you want to convert the rows into columns, you need change the query that you use to retrieve the data to be exported,
e.g. using string_ag() or something similar
Reply all
Reply to author
Forward
0 new messages