OraFAQ Forum: Reports & Discoverer » How to modify text in OD

Home » Developer & Programmer » Reports & Discoverer » How to modify text in OD

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

How to modify text in OD [message #391556]

Thu, 12 March 2009 10:07

kstoimenov
Messages: 2
Registered: March 2009
Location: Arlington

Junior Member

Hi,

I am trying to modify a text field and add "-" in OD and I don't know what function do I have to use.

Example of what I need.

I have 0123456789AB01 and I would like to change it to this format:

0123456789-AB-01.

Thanks!

Report message to a moderator

Re: How to modify text in OD [message #391649 is a reply to message #391556]

Thu, 12 March 2009 16:03

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

What is "OD"?

As we speak Oracle, one way to do that could be splitting the string with the SUBSTR function and concatenating its parts with the '-' sign.

Report message to a moderator

Re: How to modify text in OD [message #391804 is a reply to message #391556]

Fri, 13 March 2009 10:45

kstoimenov
Messages: 2
Registered: March 2009
Location: Arlington

Junior Member

OD - Oracle Discoverer.

Thanks for you respod.

This is what I used and It worked great!

SUBSTR(Name,1,12)||'-'||SUBSTR(Name,13,2||'-'||SUBSTR(name,15,4)

Report message to a moderator

Previous Topic:	REPORT COLUMN NAME CHANGING
Next Topic:	Page Break Before & Repeating Frame

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 14:35:20 CST 2024