DonationCoder.com forum
 
Read-only archive. This is a static copy of the DonationCoder.com forum. Reading and searching work as before; logging in, posting and private messages do not.
Archive of 2026-10-21 · About this archive · Main site

Author Topic: Trying to export a clip as a .csv text file  (Read 3,355 times)

superticker

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 146
Trying to export a clip as a .csv text file
« on: September 18, 2025, 01:10 AM »
I'm trying to export a clip as a .csv text file.

For the Exporting field configuration on the Backup/Maintenance panel, I have entered Clip Text.
But when I try to export the selected clip with "Edit > Export selected clips .." I get the error:

Error DBG109: DBISAM Engine Error # 11949 SQL parsing error
- Expect column name but instead found "Clip Text" in SELECT SQL statement at line 1, column 8

How can I fix this?
« Last Edit: September 18, 2025, 02:12 PM by superticker »

superticker

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 146
Re: Trying to export a clip as a .csv text file
« Reply #1 on: September 18, 2025, 02:05 PM »
I made some progress. The term ClipText must be included on the Backup/Maintenance panel's Exporting configuration blank as one continuous word without spaces. But the resulting .csv file has problems. The term ClipText is included at the top of the file's payload--see excerpt below. I don't want that. How can I exclude that?

In addition, the contents of the clip itself are in quotes--see below: "Symbol, Qua ... 4.19784572969458"
I don't want that either. How can I exclude these encapsulating quotes?

Code
ClipText
"Symbol,Quantity,Order Price
BAP,100,278.4762874406207
SAIC,400,102.89381320117934
CRGY,4600,8.774848356172875
FIVE,300,148.7625073662082
PSN,500,82.95472576942313
BRFS,9500,4.19784572969458"
« Last Edit: September 18, 2025, 02:20 PM by superticker »

Original address: https://www.donationcoder.com/forum/index.php?topic=55430.0