[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

BUsiness Objects - truncate 11 most right characters of an object

Posted on 2012-04-10
3
Medium Priority
?
621 Views
Last Modified: 2012-06-09
I have a report in Webi that I need to truncate the 11 chracters on the right.
0
Comment
Question by:Pdeters
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 20

Accepted Solution

by:
flow01 earned 1500 total points
ID: 37830344
if it uses sql on an oracle database try
 substr(xxx,1,length(xxx)-11)
where xxx is the column you want to truncate
0
 

Author Comment

by:Pdeters
ID: 37930334
this is in Business Objects
0
 

Author Closing Comment

by:Pdeters
ID: 38065698
Sent me in the right direction
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to recover a database from a user managed backup

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question