Left Function [Runtime]

From 3d2aa7ad3f21812d107e3bf17e0f4cc3050b5a60 Mon Sep 17 00:00:00 2001 From: Rüdiger Timm Date: Fri, 26 Nov 2004 14:25:41 +0000 Subject: INTEGRATION: CWS helpcontentbeta (1.1.2); FILE MERGED 2004/10/06 14:55:13 fpe 1.1.2.2: Regular Update 2004/09/16 11:45:44 fpe 1.1.2.1: Regular Update --- .../source/text/sbasic/shared/03120303.xhp | 69 +++++++++---------- .../source/text/sbasic/shared/03120306.xhp | 77 ++++++++++++---------- 2 files changed, 78 insertions(+), 68 deletions(-) diff --git a/helpcontent2/source/text/sbasic/shared/03120303.xhp b/helpcontent2/source/text/sbasic/shared/03120303.xhp index 7b6309880f..2b65c4b2a6 100755 --- a/helpcontent2/source/text/sbasic/shared/03120303.xhp +++ b/helpcontent2/source/text/sbasic/shared/03120303.xhp @@ -52,46 +52,49 @@ * Contributor(s): _______________________________________ * * - ************************************************************************--> + ************************************************************************--> + + -Left Function [Runtime] +Left Function [Runtime] /text/sbasic/shared/03120303.xhp Sun Microsystems, Inc. -converted from old format - fpe +converted from old format - fpe - - -

- Left;functionLeft Function [Runtime] - Returns the number of leftmost characters that you specify of a string expression. -

- Syntax: - Left (Text As String, n As Integer) - Return value: - String - Parameters: - Text: Any string expression that you want to return the leftmost characters from. - n: Integer expression that specifies the number of characters that you want to return. If n = 0, a zero-length string is returned. - The following example converts a date in YYYY.MM.DD format to MM/DD/YYYY format. -

- Example: - Sub ExampleUSDate - Dim sInput As String - Dim sUS_date As String - sInput = InputBox("Please input a date in the international format 'YYYY-MM-DD'") - sUS_date = Mid(sInput, 6, 2) - sUS_date = sUS_date & "/" - sUS_date = sUS_date & Right(sInput, 2) - sUS_date = sUS_date & "/" - sUS_date = sUS_date & Left(sInput, 4) - MsgBox sUS_date - End Sub - - +

+Left function + +Left Function [Runtime] +Returns the number of leftmost characters that you specify of a string expression. +

+Syntax: +Left (Text As String, n As Long) +Return value: +String +Parameters: + +Text: Any string expression that you want to return the leftmost characters from. + +n: Numeric expression that specifies the number of characters that you want to return. If n = 0, a zero-length string is returned. The maximum allowed value is 65535. +The following example converts a date in YYYY.MM.DD format to MM/DD/YYYY format. +

+Example: +Sub ExampleUSDate +Dim sInput As String +Dim sUS_date As String +sInput = InputBox("Please input a date in the international format 'YYYY-MM-DD'") +sUS_date = Mid(sInput, 6, 2) +sUS_date = sUS_date & "/" +sUS_date = sUS_date & Right(sInput, 2) +sUS_date = sUS_date & "/" +sUS_date = sUS_date & Left(sInput, 4) +MsgBox sUS_date +End Sub + diff --git a/helpcontent2/source/text/sbasic/shared/03120306.xhp b/helpcontent2/source/text/sbasic/shared/03120306.xhp index 04b9a591b0..25c3ac8229 100755 --- a/helpcontent2/source/text/sbasic/shared/03120306.xhp +++ b/helpcontent2/source/text/sbasic/shared/03120306.xhp @@ -52,48 +52,55 @@ * Contributor(s): _______________________________________ * * - ************************************************************************--> + ************************************************************************--> + + -Mid Function, Mid Statement [Runtime] +Mid Function, Mid Statement [Runtime] /text/sbasic/shared/03120306.xhp Sun Microsystems, Inc. -converted from old format - fpe +converted from old format - fpe - - -

- Mid;functionMid Function, Mid Statement [Runtime] - Returns the specified portion of a string expression (Mid function), or replaces the portion of a string expression with another string (Mid statement). -

- Syntax: - Mid (Text As String, Start As Integer [, Length As Integer]) or Mid (Text As String, Start As Integer , Length As Integer, Text As String) - Return value: - String (only by Function) - Parameters: - Text: Any string expression that you want to modify. - Start: Integer expression that indicates the character position within the string where the string portion that you want to replace or to return begins. - Length: Integer expression that returns the number of characters that you want to replace or return. - If the Length parameter in the Mid function is omitted, all characters in the string expression from the start position to the end of the string are returned. - If the Length parameter in the Mid statement is less than the length of the text that you want to replace, the text is reduced to the specified length. - Text: The string to replace the string expression (Mid statement). -

+Mid function +Mid statement + +Mid Function, Mid Statement [Runtime] +Returns the specified portion of a string expression (Mid function), or replaces the portion of a string expression with another string (Mid statement). +

+Syntax: +Mid (Text As String, Start As Long [, Length As Long]) or Mid (Text As String, Start As Long , Length As Long, Text As String) +Return value: +String (only by Function) +Parameters: + +Text: Any string expression that you want to modify. + +Start: Numeric expression that indicates the character position within the string where the string portion that you want to replace or to return begins. The maximum allowed value is 65535.UFI: see #i17928# + +Length: Numeric expression that returns the number of characters that you want to replace or return. The maximum allowed value is 65535. +If the Length parameter in the Mid function is omitted, all characters in the string expression from the start position to the end of the string are returned. +If the Length parameter in the Mid statement is less than the length of the text that you want to replace, the text is reduced to the specified length. + +Text: The string to replace the string expression (Mid statement). +