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: 21148
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: SQL - spaces in cols.
Next Topic: date as page item
Goto Forum:
  


Current Time: Mon Aug 21 01:45:11 CDT 2017

Total time taken to generate the page: 0.10143 seconds