Home » Developer & Programmer » Reports & Discoverer » How to modify text in OD
How to modify text in OD [message #391556] Thu, 12 March 2009 10:07 Go to next message
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!
Re: How to modify text in OD [message #391649 is a reply to message #391556] Thu, 12 March 2009 16:03 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
Re: How to modify text in OD [message #391804 is a reply to message #391556] Fri, 13 March 2009 10:45 Go to previous message
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)

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


Current Time: Sun Dec 11 04:20:38 CST 2016

Total time taken to generate the page: 0.06461 seconds