[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] The use of ltrim function
- Subject: [sqr-users] The use of ltrim function
- From: "Jennifer Lee" <j-lee@groupwise.umn.edu>
- Date: Thu, 14 Oct 2004 09:58:27 -0500
- Delivery-date: Thu, 14 Oct 2004 10:00:01 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
Hi,
It is true that if one is to trim a character from the left of a
string, this function of let command works very well. Why is it that
if this function is used to trim a string of characters, the result is
unpredictable?
Here's the story:
Let $string_whole =
'/l99/dbexample/PRODUCTION/fa/aidyear2005/umncr/CRAA05IN'
let $string_ltrim = '/l99/dbexample/PRODUCTION/fa/aidyear2005/umncr/'
let $string_result = ltrim($string_whole, $string_ltrim)
In two different instances (or environments) where the same code is
executed, the content of $string_result varies:
Instance #1: 'CRAA05IN'
Instance #2: 'RAA05IN'
Does one always have to use a combination of instri, length, and substr
to get a substring out of another string? What are the ways folks use
often for this type of operation?
Thanks in advance,
Jennifer
This e-mail and its attachments have been scanned for viruses.
EAS - Systems Support, OIT, University of Minnesota
_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users