• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Getting rid of special characters in TOAD commands

 
Ranch Foreman
Posts: 883
8
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I have SQL commands stored in JIRA.   I copy them to TOAD and get formatting errors.  
I examined the SQL and it contains hidden characters that look like CTRL+248.  

I clean up the SQL in MS Word with the hidden characters turned on and then copy into TOAD.

Is there a way to use the TOAD automation to edit the place where SQL is entered?   I see there is  a find and replace choice but I don't know how to look at the TOAD edit area through code.

Thanks,

Kevin
 
Marshal
Posts: 4514
572
VSCode Eclipse IDE TypeScript Redhat MicroProfile Quarkus Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
You mention CTRL+248 - is that the degrees character ° ?

 
kevin Abel
Ranch Foreman
Posts: 883
8
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
It looks like the degrees character to me.  I'm not sure if is that one.  I know 248bis the degree character.
Thanks,
Kevin
 
kevin Abel
Ranch Foreman
Posts: 883
8
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
It could be
ALT+ 0176
ALT+248
UT 0020:SPACE[SP]

The first two did not work in options.

I don't know how to do this the third way.

It may be possible with a regular expression but I'm not sure how to do that.

Thanks,

Kevin
 
kevin Abel
Ranch Foreman
Posts: 883
8
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
I keep finding more information on the find and replace topic.

The feature in TOAD only works when typing.  It does not automatically work during cut and paste.

Kevin
 
Ron McLeod
Marshal
Posts: 4514
572
VSCode Eclipse IDE TypeScript Redhat MicroProfile Quarkus Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Could it be similar to the issue described in this Microsoft support forum thread, where the browser-based source is using a non-breaking space character (xC2A0) instead of a regular space character (x20)?
 
kevin Abel
Ranch Foreman
Posts: 883
8
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Ron McLeod wrote: Could it be similar to the issue described in this Microsoft support forum thread, where the browser-based source is using a non-breaking space character (xC2A0) instead of a regular space character (x20)?



I forget the exact details, but this looks similar.   I wasn't using Lync, but the copy paste wasn't working well.  

I am going back through old posts of mine and came across this.

Thanks,

Kevin
reply
    Bookmark Topic Watch Topic
  • New Topic