OraFAQ Forum: Unix » How tro remove unwanted characters from a flat file

Home » Infrastructure » Unix » How tro remove unwanted characters from a flat file (HP Unix, Oracle 10g)

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

How tro remove unwanted characters from a flat file [message #524564]

Sat, 24 September 2011 15:48

Roadies99
Messages: 28
Registered: May 2011
Location: Delhi

Junior Member

I have been provided with a flat file from Hyperion-Essbase, which requires to be loaded to the oracle database.

Location:
The file is located on the Unix machine.

Issue:
The file that has been provided contains not required values Mi#.

Requirement:
1 Is there any command in Unix available that would remove Mi# and replace it with NULL.
2 Is there any command in Unix available that would remove Mi# and replace it with 0.

Report message to a moderator

Re: How tro remove unwanted characters from a flat file [message #524568 is a reply to message #524564]

Sat, 24 September 2011 16:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please clarify, what do you mean by "Mi#"?

Can this file be mapped as External Table?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator