A SERVICE OF

logo

Open as PDF
next previous
SAP Online Help 07.09.2004
SAP NetWeaver Visual Composer: User Guide 157
Func-
tion
Descrip-
tion
Syntax Examples
beginning of
the string
and
containing
the next
specified
number of
characters.
displayed as MEN.
Related or similar
function: AT
TRIM
Removes
the white
space from
both ends of
the string.
LTRIM
removes the
white space
only from
the left.
TRIM(text)
TRIM(@YEAR_TO_END)
Removes the white space
in the returned value.
For example, the value “
ANNUAL TURNOVER “
would be displayed as
ANNUAL TURNOVER (without
the spaces at the
beginning and the end).
Related or similar
functions: COMPACT,
LTRIM, RTRIM
FILL
Fills a string
of a given
length with
the
specified
(“pad”)
characters.
FILL(len,pad)
where pad is the character
or characters for filling
FILL(8,*)
Returns a string of eight
characters, using * to represent all
empty characters in the string. For
example, HOME would be displayed
as HOME****
Similar or related functions:
RPAD,
LPAD, ZPAD
+(Conca-
tenate)
Connects
two returned
values
(number or
text) in
order to
produce a
single,
continuous
text value.
NOTE that
only two
arguments
can be
concate-
nated.
(string)+(string)
(@CITY_NAME)+(STATE_NAME)
Displays the returned
values of the two fields
as a single value. For
example, if the values
DAYTON and OHIO are
returned for the two
fields, the value DAYTON
OHIO would be displayed.
To concatenate two
numbers, use the DSTR
function, as in this
example: NSTR(@FIRST) +
NSTR (@SECOND). In this
example, returned values
of ‘2’ and ‘4’ would
result in a value of 24
being displayed.
Other available String functions: LEN, LIKE, PREF and others