source/text/sbasic/shared/03120306.xhp | 22 +++++++++++----------- 1 file changed, 11 insertions(+), 11 deletions(-)
New commits: commit 384d13b8a4793f8aa068f8c73fe8d40b65b1fd3f Author: Pierre F <[email protected]> AuthorDate: Fri Aug 2 16:38:02 2024 +0200 Commit: Olivier Hallot <[email protected]> CommitDate: Mon Aug 12 20:51:20 2024 +0200 split syntax paragraph for MID() function / statement. see also https://ask.libreoffice.org/t/msgbox-statement-vs-function/108929/5 Change-Id: I520df9a2df289e102e265368768e03b53e8c0e2a Reviewed-on: https://gerrit.libreoffice.org/c/help/+/171408 Tested-by: Jenkins Reviewed-by: Olivier Hallot <[email protected]> diff --git a/source/text/sbasic/shared/03120306.xhp b/source/text/sbasic/shared/03120306.xhp index f9cb31167a..58bd2cc581 100644 --- a/source/text/sbasic/shared/03120306.xhp +++ b/source/text/sbasic/shared/03120306.xhp @@ -41,7 +41,9 @@ <embed href="text/sbasic/shared/00000003.xhp#functsyntax"/> <bascode> -<paragraph id="par_id3147530" role="bascode" xml-lang="en-US">Mid (Text As String, Start As Long [, Length As Long]) or Mid (Text As String, Start As Long , Length As Long, Text As String)</paragraph> +<paragraph id="par_id3147530" role="bascode" xml-lang="en-US">Mid (Text As String, Start As Long [, Length As Long]) </paragraph> +<paragraph id="par_id3147540" role="bascode" xml-lang="en-US">Mid (Text As String, Start As Long, Length As Long, Text As String)</paragraph> + </bascode> <embed href="text/sbasic/shared/00000003.xhp#functvalue"/> @@ -59,16 +61,14 @@ <embed href="text/sbasic/shared/00000003.xhp#functexample"/> <bascode> -<paragraph id="par_idm1341563264" role="bascode" localize="false" xml-lang="en-US">Sub ExampleUSDate</paragraph> -<paragraph id="par_idm1341562032" role="bascode" localize="false" xml-lang="en-US">Dim sInput As String</paragraph> -<paragraph id="par_idm1341560800" role="bascode" localize="false" xml-lang="en-US">Dim sUS_date As String</paragraph> -<paragraph id="par_id3153189" role="bascode" xml-lang="en-US"> sInput = InputBox("Please input a date in the international format 'YYYY-MM-DD'")</paragraph> -<paragraph id="par_idm1341557792" role="bascode" localize="false" xml-lang="en-US"> sUS_date = Mid(sInput, 6, 2)</paragraph> -<paragraph id="par_idm1341556544" role="bascode" localize="false" xml-lang="en-US"> sUS_date = sUS_date & "/"</paragraph> -<paragraph id="par_idm1341555280" role="bascode" localize="false" xml-lang="en-US"> sUS_date = sUS_date & Right(sInput, 2)</paragraph> -<paragraph id="par_idm1341554016" role="bascode" localize="false" xml-lang="en-US"> sUS_date = sUS_date & "/"</paragraph> -<paragraph id="par_idm1341552752" role="bascode" localize="false" xml-lang="en-US"> sUS_date = sUS_date & Left(sInput, 4)</paragraph> -<paragraph id="par_idm1341551488" role="bascode" localize="false" xml-lang="en-US"> MsgBox sUS_date</paragraph> +<paragraph id="par_idm1341563264" role="bascode" localize="false" xml-lang="en-US">Sub ExampleMid_Function_and_Statement</paragraph> +<paragraph id="par_idm1341562032" role="bascode" localize="false" xml-lang="en-US"> original_text = "This is the original Text"</paragraph> +<paragraph id="par_idm1341557792" role="bascode" localize="false" xml-lang="en-US">' Mid as function </paragraph> +<paragraph id="par_idm1341556544" role="bascode" localize="false" xml-lang="en-US"> msgbox Mid( original_text , 13, 8) ' returns the word original</paragraph> +<paragraph id="par_idm1341555280" role="bascode" localize="false" xml-lang="en-US"> msgbox original_text ' original_text not modified</paragraph> +<paragraph id="par_idm1341553792" role="bascode" localize="false" xml-lang="en-US">' Mid as statement </paragraph> +<paragraph id="par_idm1341552752" role="bascode" localize="false" xml-lang="en-US"> Mid( original_text, 13, 8, "new" )</paragraph> +<paragraph id="par_idm1341551488" role="bascode" localize="false" xml-lang="en-US"> msgbox original_text ' returns This is the new Text</paragraph> <paragraph id="par_idm1341550256" role="bascode" localize="false" xml-lang="en-US">End Sub</paragraph> </bascode> <section id="relatedtopics">
