From ed5640d8b587fbcfed7dd7967f3de04b37a76f26 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sun, 7 Apr 2024 11:06:44 +0200 Subject: Adding upstream version 4:7.4.7. Signed-off-by: Daniel Baumann --- .../source/text/sbasic/shared/03120303.xhp | 74 ++++++++++++++++++++++ 1 file changed, 74 insertions(+) create mode 100644 helpcontent2/source/text/sbasic/shared/03120303.xhp (limited to 'helpcontent2/source/text/sbasic/shared/03120303.xhp') diff --git a/helpcontent2/source/text/sbasic/shared/03120303.xhp b/helpcontent2/source/text/sbasic/shared/03120303.xhp new file mode 100644 index 000000000..596b15faa --- /dev/null +++ b/helpcontent2/source/text/sbasic/shared/03120303.xhp @@ -0,0 +1,74 @@ + + + + + + + Left Function + /text/sbasic/shared/03120303.xhp + + + + + + +

+ + Left function + + + +

Left Function

+Returns the number of leftmost characters that you specify of a string expression. +

+ +

+ +Left (Text As String, n As Long) + + +

+String + +

+ 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 2,147,483,648. +The following example converts a date in YYYY.MM.DD format to MM/DD/YYYY format. +

+ +

+ +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 + +

+ +

+ + -- cgit v1.2.3