csv export

[Nikolay]

This report may help if you need export some custom data into csv file with semicolon as delImiter.

Code: Select all

select '"'||date||'"'||delimiter||'"'||
payee||'"'||delimiter||'"'||
TransactionType||'"'||delimiter||'"'||
case TransactionType when 'Withdrawal' then -amount else amount end||'"'||delimiter||'"'||
Category||'"'||delimiter||'"'||
Subcategory||'"'||delimiter||'"'||
TransactionNumber||'"'||delimiter||'"'||
replace(notes,'"', '""')||'"' as data
from alldata
left join (select ';' as delimiter)
where AccountName like '$%' and TransactionType<>'Transfer'

Result may be copied from Custom SQL view then pasted into notepad or into some any other pad, saved as csv.