I’m trying to import some SAP SLT table data and hitting what looks like escape character \ to present a quote that isn't the surrounding quotes. This example should load as Monitors 22". I can get it in for what I'm doing now, and this is just for analysis, but I'm curious if there is a method other than editing the source or leaving the quotes and post-scrub them out.
"Snoop D.","Monitors 22"","",
So do you mean that your export file looks like:
"Snoop D.","Monitors 22\"","",
and you want Toad to process the \" as just "?
Unfortunately, the text file parser for Toad's Import Table Data feature does not support escape characters. I could add that feature if it's needed. The only workaround I can think of (if you have control over the format of the export file) is: Don't quote your strings and if necessary, use something besides a comma for the delimiter (maybe a tab?). Or export to excel instead of text (again, without quotes)
-John
Correct. The original is "Snoop D.","Monitors 22"","",
I just loaded with the wrapping quoted and did a TRIM BOTH to remove them. THis was really more of a "Am I missing how to do something in Toad?" vs. "really need it in Toad" quest.
Ah, yeah, TRIM BOTH. Good call.
Confession is good. Gemini taught me "BOTH". It also did it for 254 columns with a smart prompt. At some point I want to poke the "When can I make Toad AI magic with with my on-prem Toad and restricted databases/code and my limited authorized AI endpoints." question. Gemini (now), xAi, ChatGPT, and Claude in some unknown order.
Hi, thanks for the feedback. In our February release, we’ll be offering new licenses that would allow users to use Toad with on-premise licenses but utilize our AI features - AI Explain and AI Code with GitHub Copilot integration. Please look for the release notifications and speak with your account rep for licensing options. Let me know if I can answer any other questions.
I suspect our current annual renewal going through now isn't going to help me here, but I'm not sure if your path is every going to be an option for us in the US DoD space where we cannot leverage commercially configured AI. I'm still learning where some of the models can help with a prioritization on the things that are either really hard, a time sump, or both. Specific areas that I'm diving into are Toad generated products that I can feed to GenAI.mil to make life better. TKPROF output is an easy example. I still have to manually copy or upload to output, but it works. I haven't figured out how to make the AI tools more aware of my DDL and code so it can make more informed decisions. Code and DDL dependencies spiral into the "too big to upload" with what I can use so far. In a perfect scenario I could trace a session with Toad and when I stop it would offer options to send a tkprof output and possibly other supporting content to the AI gods that I must worship and then give me results like index suggestions and some PL/SQL and SQL rewrites. How Toad could shoot that stuff to a CAC authenticated endpoint is out of my area, but that's my dream.
Thanks for getting back with more details, this kind of feedback is valuable and helps guide our priorities.
Completely understand about the DoD restrictions. Our current Toad AI features are all cloud based, so they don't fit restricted environments today.
Regarding your scenario of TKprof, we have the following update on where we're headed on our roadmap:
We're actively looking at ways to support private/internal LLMs (hosted by the user or air-gapped).
At the same time, we're also exploring enhancements around MCP Services that could deliver more context-aware features like: Session Browser, Schema Compare, Automation Designer or Trace File Browser - exposing Toad feature via chat conversations.
While we don't have specific timelines yet, feedback like yours can accelerate our focus on environments like yours that are on-prem. Would you mind if we connect via email for future conversations with the product team?
User Forum Users: we welcome your feedback regarding AI and how it can help your usage with Toad.
Hey Chuck,
We've talked about Trace File Browser in the past, so I know you use it. I'm curious to know why/when you opt for TKProf instead.
-John
John,
I'm all in on TFB for about 95%+ of normal tracing. I still occasionally rely on tkprof for cases where I trace insanely large processes or need to pre-merge files with trcsess. I recently asked Gemini Pro what and how I could feed it and get something useful from Oracle tracing. A 2MB text file upload limit makes many raw trace files unusable. It did say to feed it tkprof output and limit the output to some top 10 SQL sort option. I've only done this a couple of times so far, but it was a pretty simple process and was a little helpful in one of the cases.
Feel free to reach out via email anytime.