Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

removing characters from string

Status
Not open for further replies.
UcfMike

UcfMike

IS-IT--Management
Joined
Mar 29, 2007
Messages
184
Location
US
I want to remove the first two characters from a string, but I don't know what those characters are going to be, how would I do this in report studio?
 
Sort by date Sort by votes
Use substring function and start with position 3 in the string:

substring('ABCDE',3,10) yields 'CDE'

Ties Blom

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sruthi2016
  • Locked
  • Question Question
Help on cognos javascript to pass parameter from one report to another dynamically
Replies
0
Views
287
sruthi2016
sruthi2016
goice
  • Locked
  • Question Question
Report 10.1.2 Drill Through Problem from Report Author (OLAP) to Report Author (Relational)
Replies
0
Views
242
goice
goice
sconti11
  • Locked
  • Question Question
Opening Report in New Window from Parent URL??
Replies
0
Views
207
sconti11
sconti11
chandanrock
  • Locked
  • Question Question
Date prompt not passing from parent report to child report
Replies
1
Views
225
chandanrock
chandanrock
birdie4me
  • Locked
  • Question Question
Creating a date filter for rpt runs on monday but pulls from the previous Sat-Fri
Replies
1
Views
252
drlex
drlex

Part and Inventory Search

Sponsor

Back
Top