At 11:46 PM 3/7/2008, Castanaro, Bob wrote:
I'll have to look up the differences between TRIM and LTRIM.
Learned two things today, how to use a left join (very helpful)
and this new TRIM function. You read about this stuff but don't
always get the chance to use it.
Bob,
Among seventy two (72) enhancements in R:BASE 7.5 for Windows
(Build: 7.5.25.31212), released on December 12, 2006, three new
string manipulation functions were also introduced.
. ((TRIM(text))
. ((LTRIM(text))
. ((RTRIM(text))
((TRIM(text)) Trims leading as well as trailing blanks from text,
returning a text string. In the following example, the value of
vStrim is the text string ABCDE without the leading as well as
trailing blanks.
SET VARIABLE vStrim = (TRIM(' ABCDE '))
((LTRIM(text)) Trims leading blanks from text, returning a text
string. In the following example, the value of vStrim is the text
string ABCDE without the leading blanks.
SET VARIABLE vStrim = (LTRIM(' ABCDE'))
(RTRIM(text)) Trims trailing blanks from text, returning a text
string. This is similar to the existing STRIM function for string
manipulation. In the following example, the value of vStrim is the
text string ABCDE without the trailing blanks.
SET VARIABLE vStrim = (RTRIM('ABCDE '))
Very Best R:egards,
Razzak.
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
