Solved

finding asci value of non printable character

Posted on 2010-11-22
3
593 Views
Last Modified: 2012-08-14
There us some sort of unprintable character at the end of several of my input recs in a varchar (30) description column. It is causing the usual mayhem by being treated as a delimeter and splitting the record. They are not the usual ascii values (I think 10 and 14) for newline and tab.  Can I dump this column to get the value.  From there I can either translate it or replace it.
0
Comment
Question by:tminelgin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 77

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 62 total points
ID: 34193488
There is a dump sql function.  Check out:
psoug.org/reference/convert_func.htm
0
 
LVL 58

Expert Comment

by:cyberkiwi
ID: 34193509
You can use the ASCII(str) function but it works on the first char in str
0
 
LVL 58

Accepted Solution

by:
cyberkiwi earned 63 total points
ID: 34193515
You can combine ascii with right, e.g.

select ascii(substr(somecol, -1,1)) from tbl
select ascii(substr(somecol, -2,1)) from tbl
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

689 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question