OraFAQ Forum: Server Administration » special character problem

Home » RDBMS Server » Server Administration » special character problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

special character problem [message #57484]

Wed, 18 June 2003 19:25

sidd
Messages: 130
Registered: May 2003

Senior Member

Here is file coming from cobol, i need to automize this file and load into oracle, i need to replace this special character with "&#124" or "," any help is appreciated.. using unix or oracle

22111334.�e#*!ENDRy�e#*!HD
�e#*!GBL�e#*!INCID�e#*!
�e#*!
�e#*! �e#*! �e#*!
�e#*!83 �e#*! �e#*!
52751920742754322846214
1.�e#*! 4.�e#*! 0.�e#*!
0.�e#*! 0.�e#*!
0
.�e#*! �e#*! �e#*!

Report message to a moderator

Re: special character problem [message #57493 is a reply to message #57484]

Thu, 19 June 2003 05:41

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

simplest method is to use the search and replace method available in any common editor.
use a vi editor ( fastest)
or 
just a notepad ( slowest)

Report message to a moderator

Re: special character problem [message #57496 is a reply to message #57493]

Thu, 19 June 2003 06:53

sidd
Messages: 130
Registered: May 2003

Senior Member

I cannot vi bcoz its giving me too long line error when i try to vi.. and search and replace, i cannot do that bcoz i cannot type that character its not there on keyboard. please neeed help really badly on this.. i don't know what am going to do

Report message to a moderator

Re: special character problem [message #57499 is a reply to message #57496]

Thu, 19 June 2003 07:28

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

what kind of special characters?
still you can produce certain characters fromt the key board, like this

`&#9612;&#945; &#9689; &#9574; &#9608; &#9787; �

but would be a bit tiresome to map it.
try to cure it in cobol iteself

Report message to a moderator

Re: special character problem [message #57500 is a reply to message #57499]

Thu, 19 June 2003 07:31

sidd
Messages: 130
Registered: May 2003

Senior Member

Dear sir,
problem here is all other branch groups have written scripts for it and they have automized it, its only the our group haven't done yet.. so its immposible to get a good file from cobol.. it can be done with 'tr' it seems..
thanks men.

Report message to a moderator

Re: special character problem [message #57528 is a reply to message #57499]

Fri, 20 June 2003 08:30

Raja
Messages: 57
Registered: March 2000

Member

to replace the special characters, you no need to type it, just copy it & paste it in 'find&replace' window box. in fact, here am copied those characters and pasted here instead of searching for ascii number and all.
`▌α ◙ ╦ █ ☻ �

Report message to a moderator

Previous Topic:	Oracle Instance Reinstall
Next Topic:	Datafile Dropping

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 10:33:32 CDT 2024