Crystal Reports for Eclipse Designer Guide

Split

Description
Split takes a String that contains a number of substrings, breaks it up into a specified number of substrings and returns an array containing the substrings.
Overloads
  • Split (inputString)
  • Split (inputString, delimiter)
  • Split (inputString, delimiter, count)
  • Split (inputString, delimiter, count, compare)
  • Arguments
  • inputString is a String expression containing substrings and delimiters.
  • delimiter is an optional String character used to identify substring limits. If omitted, the space character (" ") is assumed to be the delimiter. If delimiter is a zero-length string, a single-element array containing the entire inputString string is returned.
  • count is an optional number value of substrings to be returned. The value –1 indicates that all substrings are returned. If omitted, -1 is assumed.
  • compare is an optional Number indicating the kind of comparison to use when evaluating the delimiter string:
    • 0 performs a comparison that is case-sensitive
    • 1 performs a comparison that is case-insensitive
    If omitted, a case-sensitive comparison is performed.
  • In Crystal Reports if you omit an optional argument, you must omit all the following arguments. For example, if you do not specify a delimiter, you cannot specify count nor compare.
    Returns
    Array of String values.
    Action
    Split takes a String that contains a number of substrings, breaks it up into a specified number of substrings and returns an array containing the substrings.
    Examples
    Split ("Chocolate Strawberry Pineapple")
    Returns an array that contains 3 elements, "Chocolate", "Strawberry" and "Pineapple".
    Split ("Chocolate//Strawberry//Pineapple", "//")
    Returns an array that contains 3 elements, "Chocolate", "Strawberry" and "Pineapple".
    Split ("Chocolate//Strawberry//Pineapple", "//", 2)
    Returns an array that contains 2 elements, "Chocolate" and "Strawberry//Pineapple". The last element in the array is a concatenation of the 2nd substring and the remaining substring.
    Split ("Chocolate and Strawberry and Pineapple", " And ", -1, 0)
    Returns an array that contains 1 element, "Chocolate and Strawberry and Pineapple". The delimiter " And " cannot be matched.
    Split ("Chocolate and Strawberry and Pineapple", " And ", -1, 1)
    Returns an array that contains 3 elements, "Chocolate", "Strawberry" and "Pineapple". The delimiter " And " is matched with " and " regardless of the case.
    Comments
    If count, c, is less than the total number of substrings in inputString, then at most c substrings will be returned as elements in the resultant array. The last element in the array being a concatenation of the c-th substring and all the remaining substrings.



    SAP BusinessObjects
    http://www.sap.com/sapbusinessobjects/
    Support services
    http://service.sap.com/bosap-support/
    Product Documentation on the Web
    http://help.sap.com/