Getting rid of special characters in TOAD commands

[kevin Abel]

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

[Ron McLeod]

You mention CTRL+248 - is that the degrees character ° ?

[kevin Abel]

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]

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]

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]

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]

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