• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 598
  • Last Modified:

finding asci value of non printable character

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
tminelgin
Asked:
tminelgin
  • 2
2 Solutions
 
slightwv (䄆 Netminder) Commented:
There is a dump sql function.  Check out:
psoug.org/reference/convert_func.htm
0
 
cyberkiwiCommented:
You can use the ASCII(str) function but it works on the first char in str
0
 
cyberkiwiCommented:
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now