Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagecpp
themeConfluence
FUNCTION xpfTrimString (actualString  : STRING; 
                        prefixChars   : STRING; 
                        suffixChars   : STRING; 
                        options       : INTEGER)
                        trimmedString : STRING; 
                

Use this This function will return the trimmed version of the actualString based on the the given prefix/suffix and options

Arguments

Insert excerptUS:_a_actualStringUS:_a_actualStringnopaneltrue Insert excerptUS:_a_prefixCharsUS:_a_prefixCharsnopaneltrue Insert excerptUS:_a_suffixCharsUS:_a_suffixCharsnopaneltrue Insert excerptUS:_a_options_XPXUS:_a_options_XPXnopaneltruetrim a string according to the given specification.The xpfTrimString() function has a variable number of arguments, i.e., it can be invoked with minimum 1 argument and maximum 4 arguments.

Arguments

...

 

 TypeNameComment
STRING
actualString
The actual string to be trimmed
STRING
prefixCharsOptional argument. Default is INDETERMINATE (?). This argument specifies a set of characters that will be used in trimming the start (prefix) of the actualString. This argument is only effective when the option xpxTRIM_STRING_PREFIX is specified.
STRING
suffixCharsOptional argument. Default is INDETERMINATE (?). This argument specifies a set of characters that will be used in trimming the end (suffix) of the actualString. This argument is only effective when the option xpxTRIM_STRING_SUFFIX is specified.
INTEGER
optionsOptional argument. Default value is INDETERMINATE (?). Specifies the suffix of each substring. This suffix will be removed in the string splitting operation.

Return Value

...

 

Insert excerpt
US:_r_trimmedString
US:_r_trimmedString
nopaneltrue

...

Insert excerpt
US:_o_TRIM_STRING_PREFIX_ALL_NON_PRINTABLE_CHARS_XPX
US:_o_TRIM_STRING_PREFIX_ALL_NON_PRINTABLE_CHARS_XPX
nopaneltrue
Insert excerpt
US:_o_TRIM_STRING_SUFFIX_ALL_NON_PRINTABLE_CHARS_XPX
US:_o_TRIM_STRING_SUFFIX_ALL_NON_PRINTABLE_CHARS_XPX
nopaneltrue
Insert excerpt
US:_o_TRIM_STRING_SUFFIX_XPX
US:_o_TRIM_STRING_SUFFIX_XPX
nopaneltrue
Insert excerpt
US:_o_TRIM_STRING_PREFIX_XPX
US:_o_TRIM_STRING_PREFIX_XPX
nopaneltrue
Insert excerpt
US:_o_TRIM_STRING_PREFIX_WHITE_SPACE_XPX
US:_o_TRIM_STRING_PREFIX_WHITE_SPACE_XPX
nopaneltrue
Insert excerpt
US:_o_TRIM_STRING_SUFFIX_WHITE_SPACE_XPX
US:_o_TRIM_STRING_SUFFIX_WHITE_SPACE_XPX
nopaneltrue

 

Example

...

<example missing>-- This removes all leading and trailing white spaces

trimmed_string := xpfTrimString(mystring,?,?,xpxTRIM_STRING_PREFIX_WHITE_SPACE ~| xpxTRIM_STRING_SUFFIX_WHITE_SPACE);   

 

See also

Filter by label (Content by label)
showLabelsfalse
showSpacefalse
cqllabel = "string" and parent = "5636522"