topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Friday November 7, 2025, 6:12 am
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

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

superticker

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 146
    • View Profile
    • Superticker's SU reviews about technology
    • Donate to Member
Trying to export a clip as a .csv text file
« on: September 17, 2025, 08:10 PM »
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, 09:12 AM by superticker »

superticker

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 146
    • View Profile
    • Superticker's SU reviews about technology
    • Donate to Member
Re: Trying to export a clip as a .csv text file
« Reply #1 on: September 18, 2025, 09:05 AM »
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?

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, 09:20 AM by superticker »