Thread: Translate TABS to spaces
03-23-04, 21:04 #1Registered User
- Join Date
- Mar 2004
Unanswered: Translate Non Printing Characters to spaces
Hi, Im having a problem which I would think we be straight-forward but is not... I have loaded from SQL statements from Unix into an Oracle table ( line by line ), and am trying to then convert any instance of a TAB into a space...
so I'm trying :
REPLACE(sql_column, '\t', ' ') but its not working ??
I would like to expand this question to include converting any non-printing characters that can ever be found in a VARCHAR2 column ( basically the characters that display as a little box when using a front-end Oracle utility ), such as a carriage return, form-feed... Thanks
Last edited by arnzie; 03-24-04 at 00:41.
03-24-04, 03:36 #2Drunkard
- Join Date
- Nov 2002
- Desk, slightly south of keyboard
Try using the ascii value for tab, rather than the \t.
select replace('ABC',chr(65),chr(66)) from dual
IIRC the ascii value for tab is 8.
BillPlease don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.