diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-09-02 19:31:21 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2020-09-03 01:41:54 +0200 |
| commit | 1476465fc35ec2162a513ebc668fed82ed77397b (patch) | |
| tree | 40d27d432e8f146fd7a8ae94fadf4475d4cce9b1 /source/text/sbasic | |
| parent | d9d73c9fcb86892de84ae870e09f380555a6fd5f (diff) | |
tdf#136213 Basic string functions update
Change-Id: I86ce4fe20c1947bc1742c9ed6c9726d73b8cbbf8
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/101984
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
Diffstat (limited to 'source/text/sbasic')
21 files changed, 172 insertions, 129 deletions
diff --git a/source/text/sbasic/shared/00000003.xhp b/source/text/sbasic/shared/00000003.xhp index 5c675002e0..c525575f04 100644 --- a/source/text/sbasic/shared/00000003.xhp +++ b/source/text/sbasic/shared/00000003.xhp @@ -181,7 +181,7 @@ <section id="dialoglibhowtoget"> <paragraph role="paragraph" id="par_id631529990528928" xml-lang="en-US">Open <item type="menuitem">Tools - Macros - Organize dialogs...</item> and select <item type="menuitem">%PRODUCTNAME Dialogs</item> container.</paragraph> -</section> +</section> <section id="basiclibhowtoget"> <paragraph role="paragraph" id="par_id631529000528928" xml-lang="en-US">Open <item type="menuitem">Tools - Macros - %PRODUCTNAME Basic - Edit</item> and select <item type="menuitem">%PRODUCTNAME Macros</item> container.</paragraph> </section> @@ -212,6 +212,10 @@ <h2 id="hd_id061420171139088233"><variable id="functexample">Example:</variable></h2> </section> + +<paragraph role="paragraph" id="par_id161599082457466"><variable id="stringfunctions"><link href="text/sbasic/shared/03120300.xhp" name="string functions">String functions</link></variable></paragraph> + + <paragraph id="par_id06142017015837916" role="paragraph" xml-lang="en-US"><variable id="VBA-Financial"><link href="text/sbasic/shared/special_vba_func.xhp#VBAFinancial">VBA financial functions</link></variable></paragraph> <paragraph id="par_id06142017016837917" role="paragraph" xml-lang="en-US"><variable id="VBATimeAndDate"><link href="text/sbasic/shared/special_vba_func.xhp#VBADateTime">VBA Time and Date functions</link></variable></paragraph> <paragraph id="par_id06142017016837918" role="paragraph" xml-lang="en-US"><variable id="VBAIO"><link href="text/sbasic/shared/special_vba_func.xhp#VBAIO">VBA I/O functions</link></variable></paragraph> diff --git a/source/text/sbasic/shared/01020100.xhp b/source/text/sbasic/shared/01020100.xhp index 8b777f7ba3..7a769d70e5 100644 --- a/source/text/sbasic/shared/01020100.xhp +++ b/source/text/sbasic/shared/01020100.xhp @@ -47,11 +47,11 @@ </bookmark> -<paragraph id="hd_id3149346" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/01020100.xhp" name="Using Variables">Using Variables</link></paragraph> +<h1 id="hd_id3149346"><link href="text/sbasic/shared/01020100.xhp" name="Using Variables">Using Variables</link></h1> <paragraph id="par_id3154346" role="paragraph" xml-lang="en-US">The following describes the basic use of variables in $[officename] Basic.</paragraph> </section> -<paragraph id="hd_id3153361" role="heading" level="2" xml-lang="en-US">Naming Conventions for Variable Identifiers</paragraph> +<h2 id="hd_id3153361">Naming Conventions for Variable Identifiers</h2> <paragraph id="par_id3148797" role="paragraph" xml-lang="en-US">A variable name can consist of a maximum of 255 characters. The first character of a variable name <emph>must</emph> be a letter A-Z or a-z. Numbers can also be used in a variable name, but punctuation symbols and special characters are not permitted, with exception of the underscore character ("_"). In $[officename] Basic variable identifiers are not case-sensitive. Variable names may contain spaces but must be enclosed in square brackets if they do.</paragraph> <paragraph id="par_id3156422" role="paragraph" xml-lang="en-US">Examples for variable identifiers:</paragraph> @@ -66,7 +66,7 @@ <paragraph id="par_idm1341234704" role="bascode">Number,Mine=12 'Not valid, punctuation marks are not allowed'</paragraph> </bascode> -<paragraph id="hd_id3146317" role="heading" level="2" xml-lang="en-US">Declaring Variables</paragraph> +<h2 id="hd_id3146317">Declaring Variables</h2> <paragraph id="par_id3150299" role="paragraph" xml-lang="en-US">In $[officename] Basic you don't need to declare variables explicitly. A variable declaration can be performed with the <emph>Dim</emph> statement. You can declare more than one variable at a time by separating the names with a comma. To define the variable type, use either a type-declaration sign after the name, or the appropriate key word. </paragraph> <paragraph id="par_id3154118" role="paragraph" xml-lang="en-US">Examples for variable declarations:</paragraph> @@ -77,16 +77,16 @@ <paragraph id="par_idm1341205936" role="bascode">Dim c As Boolean 'Declares c as a Boolean variable that can be TRUE or FALSE'</paragraph> </bascode> -<paragraph id="par_id3144770" role="warning" xml-lang="en-US">Once you have declared a variable as a certain type, you cannot declare the variable under the same name again as a different type!</paragraph> +<warning id="par_id3144770">Once you have declared a variable as a certain type, you cannot declare the variable under the same name again as a different type!</warning> -<paragraph id="hd_id3149331" role="heading" level="3" xml-lang="en-US">Forcing Variable Declarations</paragraph> +<h3 id="hd_id3149331">Forcing Variable Declarations</h3> <paragraph id="par_id3149443" role="paragraph" xml-lang="en-US">To force declaration of variables, use the following command:</paragraph> <bascode> <paragraph id="par_idm1341182432" role="bascode" localize="false" xml-lang="en-US">Option Explicit</paragraph> </bascode> <paragraph id="par_id3155072" role="paragraph" xml-lang="en-US">The <emph>Option Explicit</emph> statement has to be the first line in the module, before the first SUB. Generally, only arrays need to be declared explicitly. All other variables are declared according to the type-declaration character, or - if omitted - as the default type <emph>Single</emph>.</paragraph> -<paragraph id="hd_id3154614" role="heading" level="2" xml-lang="en-US">Variable Types</paragraph> +<h2 id="hd_id3154614">Variable Types</h2> <paragraph id="par_id3155383" role="paragraph" xml-lang="en-US">$[officename] Basic supports four variable classes:</paragraph> <list type="unordered"> @@ -103,40 +103,40 @@ <paragraph id="par_id3154762" role="listitem" xml-lang="en-US"> <emph>Object</emph> variables can store objects of various types, like tables and documents within a document.</paragraph> </listitem></list> -<paragraph id="hd_id3153805" role="heading" level="3" xml-lang="en-US">Integer Variables</paragraph> +<h3 id="hd_id3153805">Integer Variables</h3> <paragraph id="par_id3146966" role="paragraph" xml-lang="en-US">Integer variables range from -32768 to 32767. If you assign a floating-point value to an integer variable, the decimal places are rounded to the next integer. Integer variables are rapidly calculated in procedures and are suitable for counter variables in loops. An integer variable only requires two bytes of memory. "%" is the type-declaration character.</paragraph> <bascode> <paragraph id="par_idm1341159200" role="bascode" localize="false" xml-lang="en-US">Dim Variable%</paragraph> <paragraph id="par_idm1341157968" role="bascode" localize="false" xml-lang="en-US">Dim Variable As Integer</paragraph> </bascode> -<paragraph id="hd_id3147546" role="heading" level="3" xml-lang="en-US">Long Integer Variables</paragraph> +<h3 id="hd_id3147546">Long Integer Variables</h3> <paragraph id="par_id3151193" role="paragraph" xml-lang="en-US">Long integer variables range from -2147483648 to 2147483647. If you assign a floating-point value to a long integer variable, the decimal places are rounded to the next integer. Long integer variables are rapidly calculated in procedures and are suitable for counter variables in loops for large values. A long integer variable requires four bytes of memory. "&" is the type-declaration character.</paragraph> <bascode> <paragraph id="par_idm1341151984" role="bascode" localize="false" xml-lang="en-US">Dim Variable&</paragraph> <paragraph id="par_idm1341150736" role="bascode" localize="false" xml-lang="en-US">Dim Variable As Long</paragraph> </bascode> -<paragraph id="hd_id7596972" role="heading" level="3" xml-lang="en-US">Decimal Variables<comment>see i64349</comment></paragraph> +<h3 id="hd_id7596972">Decimal Variables<comment>see i64349</comment></h3> <paragraph id="par_id2649311" role="paragraph" xml-lang="en-US">Decimal variables can take positive or negative numbers or zero. Accuracy is up to 29 digits.</paragraph><comment>i85284</comment> <paragraph id="par_id7617114" role="paragraph" xml-lang="en-US">You can use plus (+) or minus (-) signs as prefixes for decimal numbers (with or without spaces).</paragraph> <paragraph id="par_id1593676" role="paragraph" xml-lang="en-US">If a decimal number is assigned to an integer variable, %PRODUCTNAME Basic rounds the figure up or down.<comment>information from "Programming Guide for BASIC" about decimal variables</comment></paragraph> -<paragraph id="hd_id3147500" role="heading" level="3" xml-lang="en-US">Single Variables</paragraph> +<h3 id="hd_id3147500">Single Variables</h3> <paragraph id="par_id3153070" role="paragraph" xml-lang="en-US">Single variables can take positive or negative values ranging from 3.402823 x 10E38 to 1.401298 x 10E-45. Single variables are floating-point variables, in which the decimal precision decreases as the non-decimal part of the number increases. Single variables are suitable for mathematical calculations of average precision. Calculations require more time than for Integer variables, but are faster than calculations with Double variables. A Single variable requires 4 bytes of memory. The type-declaration character is "!".</paragraph> <bascode> <paragraph id="par_idm1341137456" role="bascode" localize="false" xml-lang="en-US">Dim Variable!</paragraph> <paragraph id="par_idm1341136224" role="bascode" localize="false" xml-lang="en-US">Dim Variable As Single</paragraph> </bascode> -<paragraph id="hd_id3155753" role="heading" level="3" xml-lang="en-US">Double Variables</paragraph> +<h3 id="hd_id3155753">Double Variables</h3> <paragraph id="par_id3150953" role="paragraph" xml-lang="en-US">Double variables can take positive or negative values ranging from 1.79769313486232 x 10E308 to 4.94065645841247 x 10E-324. Double variables are floating-point variables, in which the decimal precision decreases as the non-decimal part of the number increases. Double variables are suitable for precise calculations. Calculations require more time than for Single variables. A Double variable requires 8 bytes of memory. The type-declaration character is "#".</paragraph> <bascode> -<paragraph id="par_idm1341130144" role="bascode" xml-lang="en-US">Dim Variable#</paragraph> +<paragraph id="par_idm1341130144" role="bascode" xml-lang="en-US">Dim Variable#</paragraph> <paragraph id="par_idm1341128912" role="bascode" localize="false" xml-lang="en-US">Dim Variable As Double</paragraph> </bascode> -<paragraph id="hd_id3155747" role="heading" level="3" xml-lang="en-US">Currency Variables</paragraph> +<h3 id="hd_id3155747">Currency Variables</h3> <paragraph id="par_id3153337" role="paragraph" xml-lang="en-US">Currency variables are internally stored as 64-bit numbers (8 Bytes) and displayed as a fixed-decimal number with 15 non-decimal and 4 decimal places. The values range from -922337203685477.5808 to +922337203685477.5807. Currency variables are used to calculate currency values with a high precision. The type-declaration character is "@".</paragraph> <bascode> <paragraph id="par_idm1341123216" role="bascode" localize="false" xml-lang="en-US">Dim Variable@</paragraph> @@ -146,40 +146,41 @@ <h3 id="hd_id301576839713868">Literals for integers</h3> <paragraph role="paragraph" id="par_id1001576839723156">Numbers can be encoded using octal and hexadecimal forms.</paragraph> <bascode> - <paragraph role="bascode" id="bas_id331576850637825" localize="false">xi = &o13 ' 8 + 3</paragraph> - <paragraph role="bascode" id="bas_id761576850640144" localize="false">ci = &h65 ' 6*16 + 5</paragraph> - <paragraph role="bascode" id="bas_id511576850640336" localize="false">MAX_Integer = &o77777 ' 32767 = &h7FFF</paragraph> - <paragraph role="bascode" id="bas_id571576850640536" localize="false">MIN_Integer = &o100000 ' -32768 = &h8000</paragraph> - <paragraph role="bascode" id="bas_id541576850641922" localize="false">MAX_Long = &h7fffffff ' 2147483647 = &o17777777777</paragraph> - <paragraph role="bascode" id="bas_id481576850564801" localize="false">MIN_Long = &h80000000 ' -2147483648 = &o20000000000</paragraph> + <paragraph role="bascode" id="bas_id331576850637825" localize="false">xi = &o13 ' 8 + 3</paragraph> + <paragraph role="bascode" id="bas_id761576850640144" localize="false">ci = &h65 ' 6*16 + 5</paragraph> + <paragraph role="bascode" id="bas_id511576850640336" localize="false">MAX_Integer = &o77777 ' 32767 = &h7FFF</paragraph> + <paragraph role="bascode" id="bas_id571576850640536" localize="false">MIN_Integer = &o100000 ' -32768 = &h8000</paragraph> + <paragraph role="bascode" id="bas_id541576850641922" localize="false">MAX_Long = &h7fffffff ' 2147483647 = &o17777777777</paragraph> + <paragraph role="bascode" id="bas_id481576850564801" localize="false">MIN_Long = &h80000000 ' -2147483648 = &o20000000000</paragraph> </bascode> -<paragraph id="hd_id3148742" role="heading" level="3" xml-lang="en-US">String Variables</paragraph> -<paragraph id="par_id3151393" role="paragraph" xml-lang="en-US">String variables can hold character strings with up to 65,535 characters. Each character is stored as the corresponding Unicode value. String variables are suitable for word processing within programs and for temporary storage of any non-printable character up to a maximum length of 64 Kbytes. The memory required for storing string variables depends on the number of characters in the variable. The type-declaration character is "$".</paragraph> +<h3 id="hd_id3148742">String Variables</h3> +<paragraph id="par_id3151393" role="paragraph" xml-lang="en-US">String variables can hold character strings with up to 2,147,483,648 characters. Each character is stored as the corresponding Unicode value. String variables are suitable for word processing within programs and for temporary storage of any non-printable character up to a maximum length of 2 Gbytes. The memory required for storing string variables depends on the number of characters in the variable. The type-declaration character is "$".</paragraph> +<tip id="par_id381599081637549">In BASIC String functions, the first character of the string has index 1.</tip> <bascode> <paragraph id="par_idm1341116176" role="bascode" localize="false" xml-lang="en-US">Dim Variable$</paragraph> <paragraph id="par_idm1341114944" role="bascode" localize="false" xml-lang="en-US">Dim Variable As String</paragraph> </bascode> -<paragraph id="hd_id3150534" role="heading" level="3" xml-lang="en-US">Boolean Variables</paragraph> +<h3 id="hd_id3150534">Boolean Variables</h3> <paragraph id="par_id3145632" role="paragraph" xml-lang="en-US">Boolean variables store only one of two values: TRUE or FALSE. A number 0 evaluates to FALSE, every other value evaluates to TRUE.</paragraph> <bascode> <paragraph id="par_idm1341109456" role="bascode" localize="false" xml-lang="en-US">Dim Variable As Boolean</paragraph> </bascode> -<paragraph id="hd_id3149722" role="heading" level="3" xml-lang="en-US">Date Variables</paragraph> +<h3 id="hd_id3149722">Date Variables</h3> <paragraph id="par_id3159116" role="paragraph" xml-lang="en-US">Date variables can only contain dates and time values stored in an internal format. Values assigned to Date variables with <link href="text/sbasic/shared/03030101.xhp" name="Dateserial"><emph>Dateserial</emph></link>, <link href="text/sbasic/shared/03030102.xhp" name="Datevalue"><emph>Datevalue</emph></link>, <link href="text/sbasic/shared/03030205.xhp" name="Timeserial"><emph>Timeserial</emph></link> or <link href="text/sbasic/shared/03030206.xhp" name="Timevalue"><emph>Timevalue</emph></link> are automatically converted to the internal format. Date-variables are converted to normal numbers by using the <link href="text/sbasic/shared/03030103.xhp" name="Day"><emph>Day</emph></link>, <link href="text/sbasic/shared/03030104.xhp" name="Month"><emph>Month</emph></link>, <link href="text/sbasic/shared/03030106.xhp" name="Year"><emph>Year</emph></link> or the <link href="text/sbasic/shared/03030201.xhp" name="Hour"><emph>Hour</emph></link>, <link href="text/sbasic/shared/03030202.xhp" name="Minute"><emph>Minute</emph></link>, <link href="text/sbasic/shared/03030204.xhp" name="Second"><emph>Second</emph></link> function. The internal format enables a comparison of date/time values by calculating the difference between two numbers. These variables can only be declared with the key word <emph>Date</emph>.</paragraph> <bascode> <paragraph id="par_idm1341092144" role="bascode" localize="false" xml-lang="en-US">Dim Variable As Date</paragraph> </bascode> -<paragraph id="hd_id3148732" role="heading" level="2" xml-lang="en-US">Initial Variable Values</paragraph> +<h2 id="hd_id3148732">Initial Variable Values</h2> <paragraph id="par_id3154549" role="paragraph" xml-lang="en-US">As soon as the variable has been declared, it is automatically set to the "Null" value. Note the following conventions:</paragraph> <paragraph id="par_id3143222" role="paragraph" xml-lang="en-US"> <emph>Numeric</emph> variables are automatically assigned the value "0" as soon as they are declared.</paragraph> <paragraph id="par_id3150693" role="paragraph" xml-lang="en-US"> <emph>Date variables</emph> are assigned the value 0 internally; equivalent to converting the value to "0" with the <link href="text/sbasic/shared/03030103.xhp" name="Day"><emph>Day</emph></link>, <link href="text/sbasic/shared/03030104.xhp" name="Month"><emph>Month</emph></link>, <link href="text/sbasic/shared/03030106.xhp" name="Year"><emph>Year</emph></link> or the <link href="text/sbasic/shared/03030201.xhp" name="Hour"><emph>Hour</emph></link>, <link href="text/sbasic/shared/03030202.xhp" name="Minute"><emph>Minute</emph></link>, <link href="text/sbasic/shared/03030204.xhp" name="Second"><emph>Second</emph></link> function.</paragraph> <paragraph id="par_id3154807" role="paragraph" xml-lang="en-US"> <emph>String variables</emph> are assigned an empty-string ("") when they are declared.</paragraph> -<paragraph id="hd_id3153936" role="heading" level="2" xml-lang="en-US">Arrays</paragraph> +<h2 id="hd_id3153936">Arrays</h2> <paragraph id="par_id3148736" role="paragraph" xml-lang="en-US">$[officename] Basic knows one- or multi-dimensional arrays, defined by a specified variable type. Arrays are suitable for editing lists and tables in programs. Individual elements of an array can be addressed through a numeric index.</paragraph> <paragraph id="par_id3149546" role="paragraph" xml-lang="en-US">Arrays <emph>must</emph> be declared with the <emph>Dim</emph> statement. There are several ways to define the index range of an array:</paragraph> @@ -192,7 +193,7 @@ <paragraph id="par_id3153005" role="paragraph" xml-lang="en-US">The index range can include positive as well as negative numbers. <comment>i36558</comment></paragraph> -<paragraph id="hd_id3154507" role="heading" level="2" xml-lang="en-US">Constants</paragraph> +<h2 id="hd_id3154507">Constants</h2> <paragraph id="par_id3156357" role="paragraph" xml-lang="en-US">Constants have a fixed value. They are only defined once in the program and cannot be redefined later:</paragraph> <bascode> <paragraph id="par_idm1341038256" role="bascode" localize="false" xml-lang="en-US">Const ConstName=Expression</paragraph> diff --git a/source/text/sbasic/shared/03120201.xhp b/source/text/sbasic/shared/03120201.xhp index 815a840c71..9b60756d91 100644 --- a/source/text/sbasic/shared/03120201.xhp +++ b/source/text/sbasic/shared/03120201.xhp @@ -33,7 +33,7 @@ <bookmark_value>Spc function</bookmark_value> </bookmark> -<paragraph id="hd_id3150499" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03120201.xhp" name="Space Function">Space and Spc Functions</link></paragraph> +<h1 id="hd_id3150499"><link href="text/sbasic/shared/03120201.xhp" name="Space Function">Space and Spc Functions</link></h1> <paragraph id="par_id3154927" role="paragraph" xml-lang="en-US">Returns a string that consists of a specified amount of spaces.</paragraph> </section> <note id="par_id681546202842979">The Spc function works the same as the Space function.</note> @@ -46,7 +46,7 @@ <paragraph id="par_id3149233" role="paragraph" xml-lang="en-US">String</paragraph> <embed href="text/sbasic/shared/00000003.xhp#functparameters"/> -<paragraph id="par_id3143228" role="paragraph" xml-lang="en-US"> <emph>n:</emph> Numeric expression that defines the number of spaces in the string. The maximum allowed value of <emph>n</emph> is 65535.</paragraph> +<paragraph id="par_id3143228" role="paragraph" xml-lang="en-US"> <emph>n:</emph> Numeric expression that defines the number of spaces in the string. The maximum allowed value of <emph>n</emph> is 2,147,483,648.</paragraph> <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> <embed href="text/sbasic/shared/00000003.xhp#err5"/> diff --git a/source/text/sbasic/shared/03120202.xhp b/source/text/sbasic/shared/03120202.xhp index e088ee7185..ff30d5ef98 100644 --- a/source/text/sbasic/shared/03120202.xhp +++ b/source/text/sbasic/shared/03120202.xhp @@ -34,26 +34,26 @@ </bookmark> -<paragraph id="hd_id3147291" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03120202.xhp" name="String Function">String Function</link></paragraph> +<h1 id="hd_id3147291"><link href="text/sbasic/shared/03120202.xhp" name="String Function">String Function</link></h1> <paragraph id="par_id3147242" role="paragraph" xml-lang="en-US">Creates a string according to the specified character, or the first character of a string expression that is passed to the function.</paragraph> </section> -<paragraph id="hd_id3149516" role="heading" level="2" xml-lang="en-US">Syntax:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/> <bascode> <paragraph id="par_id3149233" role="bascode" xml-lang="en-US">String (n As Long, {expression As Integer | character As String})</paragraph> </bascode> -<paragraph id="hd_id3143270" role="heading" level="2" xml-lang="en-US">Return value:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functvalue"/> <paragraph id="par_id3147530" role="paragraph" xml-lang="en-US">String</paragraph> -<paragraph id="hd_id3154923" role="heading" level="2" xml-lang="en-US">Parameters:</paragraph> -<paragraph id="par_id3154347" role="paragraph" xml-lang="en-US"> <emph>n:</emph> Numeric expression that indicates the number of characters to return in the string. The maximum allowed value of n is 65535.</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functparameters"/> +<paragraph id="par_id3154347" role="paragraph" xml-lang="en-US"> <emph>n:</emph> Numeric expression that indicates the number of characters to return in the string. The maximum allowed value of n is 2,147,483,648.</paragraph> <paragraph id="par_id3148664" role="paragraph" xml-lang="en-US"> <emph>Expression:</emph> Numeric expression that defines the ASCII code for the character.</paragraph> <paragraph id="par_id3150359" role="paragraph" xml-lang="en-US"> <emph>Character:</emph> Any single character used to build the return string, or any string of which only the first character will be used.</paragraph> <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> <embed href="text/sbasic/shared/00000003.xhp#err5"/> -<paragraph id="hd_id3152920" role="heading" level="2" xml-lang="en-US">Example:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functexample"/> <bascode> <paragraph id="par_idm1340924160" role="bascode" localize="false" xml-lang="en-US">Sub ExampleString</paragraph> <paragraph id="par_idm1340922928" role="bascode" localize="false" xml-lang="en-US">Dim sText As String</paragraph> @@ -65,4 +65,4 @@ </bascode> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> diff --git a/source/text/sbasic/shared/03120301.xhp b/source/text/sbasic/shared/03120301.xhp index 3f19ae6de5..018e8ccc91 100644 --- a/source/text/sbasic/shared/03120301.xhp +++ b/source/text/sbasic/shared/03120301.xhp @@ -34,23 +34,23 @@ </bookmark> -<paragraph id="hd_id3153539" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03120301.xhp" name="Format Function">Format Function</link></paragraph> +<h1 id="hd_id3153539"><link href="text/sbasic/shared/03120301.xhp" name="Format Function">Format Function</link></h1> <paragraph id="par_id3156042" role="paragraph" xml-lang="en-US">Converts a number to a string, and then formats it according to the format that you specify.</paragraph> </section> -<paragraph id="hd_id3145090" role="heading" level="2" xml-lang="en-US">Syntax:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/> <bascode> <paragraph id="par_id3153527" role="bascode" xml-lang="en-US">Format (Number [, Format As String])</paragraph> </bascode> -<paragraph id="hd_id3149178" role="heading" level="2" xml-lang="en-US">Return value:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functvalue"/> <paragraph id="par_id3148474" role="paragraph" xml-lang="en-US">String</paragraph> -<paragraph id="hd_id3159176" role="heading" level="2" xml-lang="en-US">Parameters:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functparameters"/> <paragraph id="par_id3149415" role="paragraph" xml-lang="en-US"> <emph>Number:</emph> Numeric expression that you want to convert to a formatted string.</paragraph> <paragraph id="par_id3147531" role="paragraph" xml-lang="en-US"> <emph>Format:</emph> String that specifies the format code for the number. If <emph>Format</emph> is omitted, the Format function works like the <emph>Str</emph> function.</paragraph> -<paragraph id="hd_id3147561" role="heading" level="2" xml-lang="en-US">Formatting Codes</paragraph> +<h2 id="hd_id3147561">Formatting Codes</h2> <paragraph id="par_id3147265" role="paragraph" xml-lang="en-US">The following list describes the codes that you can use for formatting a number:</paragraph> <paragraph id="par_id3153380" role="paragraph" xml-lang="en-US"> <emph>0:</emph> If <emph>Number</emph> has a digit at the position of the 0 in the format code, the digit is displayed, otherwise a zero is displayed.</paragraph> <paragraph id="par_id3151210" role="paragraph" xml-lang="en-US">If <emph>Number</emph> has fewer digits than the number of zeros in the format code, (on either side of the decimal), leading or trailing zeros are displayed. If the number has more digits to the left of the decimal separator than the amount of zeros in the format code, the additional digits are displayed without formatting.</paragraph> @@ -72,7 +72,7 @@ <paragraph id="par_id3145749" role="paragraph" xml-lang="en-US">You can also use the following predefined number formats. Except for "General Number", all of the predefined format codes return the number as a decimal number with two decimal places.</paragraph> <paragraph id="par_id3150113" role="paragraph" xml-lang="en-US">If you use predefined formats, the name of the format must be enclosed in quotation marks.</paragraph> -<paragraph id="hd_id3149377" role="heading" level="2" xml-lang="en-US">Predefined format</paragraph> +<h2 id="hd_id3149377">Predefined format</h2> <paragraph id="par_id3154730" role="paragraph" xml-lang="en-US"> <emph>General Number:</emph> Numbers are displayed as entered.</paragraph> <paragraph id="par_id3153158" role="paragraph" xml-lang="en-US"> <emph>Currency:</emph> Inserts a dollar sign in front of the number and encloses negative numbers in brackets.</paragraph> <paragraph id="par_id3154490" role="paragraph" xml-lang="en-US"> <emph>Fixed:</emph> Displays at least one digit in front of the decimal separator.</paragraph> @@ -84,7 +84,7 @@ <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> <embed href="text/sbasic/shared/00000003.xhp#err5"/> -<paragraph id="hd_id3149019" role="heading" level="2" xml-lang="en-US">Example:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functexample"/> <bascode> <paragraph id="par_idm1341556320" role="bascode" localize="false" xml-lang="en-US">Sub ExampleFormat</paragraph> <paragraph id="par_idm1341555088" role="bascode" localize="false" xml-lang="en-US"> MsgBox Format(6328.2, "##,##0.00")</paragraph> @@ -94,6 +94,8 @@ </bascode> <section id="relatedtopics"> <paragraph role="paragraph" id="par_id381513082126889" xml-lang="en-US"><link href="text/shared/01/05020301.xhp" name="number format code">Number format codes</link></paragraph> + <paragraph role="paragraph" id="par_id161599082457466" localize="false"><embedvar href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph> </section> + </body> </helpdocument> diff --git a/source/text/sbasic/shared/03120302.xhp b/source/text/sbasic/shared/03120302.xhp index 361545bfb5..68c6f05ca5 100644 --- a/source/text/sbasic/shared/03120302.xhp +++ b/source/text/sbasic/shared/03120302.xhp @@ -34,7 +34,7 @@ </bookmark> -<paragraph id="hd_id3152363" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03120302.xhp" name="LCase Function">LCase Function</link></paragraph> +<h1 id="hd_id3152363"><link href="text/sbasic/shared/03120302.xhp" name="LCase Function">LCase Function</link></h1> <paragraph id="par_id3145609" role="paragraph" xml-lang="en-US">Converts all uppercase letters in a string to lowercase.</paragraph> </section> <paragraph id="par_id3154347" role="paragraph" xml-lang="en-US">See also: <link href="text/sbasic/shared/03120310.xhp" name="UCase">UCase</link> Function</paragraph> @@ -59,6 +59,9 @@ <paragraph id="par_id3146986" role="bascode" xml-lang="en-US"> Print UCase(sVar) ' Returns "LAS VEGAS"</paragraph> <paragraph id="par_idm1341096336" role="bascode" localize="false" xml-lang="en-US">End Sub</paragraph> </bascode> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id161599082457466" localize="false"><embedvar href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph> +</section> </body> </helpdocument> diff --git a/source/text/sbasic/shared/03120303.xhp b/source/text/sbasic/shared/03120303.xhp index cc0b41a88e..596b15faa7 100644 --- a/source/text/sbasic/shared/03120303.xhp +++ b/source/text/sbasic/shared/03120303.xhp @@ -34,26 +34,26 @@ </bookmark> -<paragraph id="hd_id3149346" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03120303.xhp" name="Left Function">Left Function</link></paragraph> +<h1 id="hd_id3149346"><link href="text/sbasic/shared/03120303.xhp" name="Left Function">Left Function</link></h1> <paragraph id="par_id3147242" role="paragraph" xml-lang="en-US">Returns the number of leftmost characters that you specify of a string expression.</paragraph> </section> -<paragraph id="hd_id3156153" role="heading" level="2" xml-lang="en-US">Syntax:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/> <bascode> <paragraph id="par_id3150771" role="bascode" xml-lang="en-US">Left (Text As String, n As Long)</paragraph> </bascode> -<paragraph id="hd_id3153824" role="heading" level="2" xml-lang="en-US">Return value:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functvalue"/> <paragraph id="par_id3147530" role="paragraph" xml-lang="en-US">String</paragraph> -<paragraph id="hd_id3148946" role="heading" level="2" xml-lang="en-US">Parameters:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functparameters"/> <paragraph id="par_id3148552" role="paragraph" xml-lang="en-US"> <emph>Text:</emph> Any string expression that you want to return the leftmost characters from.</paragraph> -<paragraph id="par_id3149456" role="paragraph" xml-lang="en-US"> <emph>n:</emph> Numeric expression that specifies the number of characters that you want to return. If <emph>n</emph> = 0, a zero-length string is returned. The maximum allowed value is 65535.</paragraph> +<paragraph id="par_id3149456" role="paragraph" xml-lang="en-US"> <emph>n:</emph> Numeric expression that specifies the number of characters that you want to return. If <emph>n</emph> = 0, a zero-length string is returned. The maximum allowed value is 2,147,483,648.</paragraph> <paragraph id="par_id3150791" role="paragraph" xml-lang="en-US">The following example converts a date in YYYY.MM.DD format to MM/DD/YYYY format.</paragraph> <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> <embed href="text/sbasic/shared/00000003.xhp#err5"/> -<paragraph id="hd_id3125863" role="heading" level="2" xml-lang="en-US">Example:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functexample"/> <bascode> <paragraph id="par_idm1340818096" role="bascode" localize="false" xml-lang="en-US">Sub ExampleUSDate</paragraph> <paragraph id="par_idm1340816864" role="bascode" localize="false" xml-lang="en-US">Dim sInput As String</paragraph> @@ -67,6 +67,8 @@ <paragraph id="par_idm1340806272" role="bascode" localize="false" xml-lang="en-US"> MsgBox sUS_date</paragraph> <paragraph id="par_idm1340805040" role="bascode" localize="false" xml-lang="en-US">End Sub</paragraph> </bascode> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id161599082457466" localize="false"><embedvar href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph> +</section> </body> - -</helpdocument>
\ No newline at end of file +</helpdocument> diff --git a/source/text/sbasic/shared/03120304.xhp b/source/text/sbasic/shared/03120304.xhp index 19e9d6450a..54567d6a0c 100644 --- a/source/text/sbasic/shared/03120304.xhp +++ b/source/text/sbasic/shared/03120304.xhp @@ -34,23 +34,23 @@ </bookmark> -<paragraph id="hd_id3143268" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03120304.xhp" name="LSet Statement">LSet Statement</link></paragraph> +<h1 id="hd_id3143268"><link href="text/sbasic/shared/03120304.xhp" name="LSet Statement">LSet Statement</link></h1> <paragraph id="par_id3155419" role="paragraph" xml-lang="en-US">Aligns a string to the left of a string variable, or copies a variable of a user-defined type to another variable of a different user-defined type.</paragraph> </section> -<paragraph id="hd_id3145317" role="heading" level="2" xml-lang="en-US">Syntax:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/> <bascode> <paragraph id="par_id3150984" role="bascode" xml-lang="en-US">LSet Var As String = Text or LSet Var1 = Var2</paragraph> </bascode> -<paragraph id="hd_id3143271" role="heading" level="2" xml-lang="en-US">Parameters:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functparameters"/> <paragraph id="par_id3145610" role="paragraph" xml-lang="en-US"> <emph>Var:</emph> Any String variable that contains the string that you want align to the left.</paragraph> <paragraph id="par_id3154346" role="paragraph" xml-lang="en-US"> <emph>Text:</emph> String that you want to align to the left of the string variable.</paragraph> <paragraph id="par_id3151054" role="paragraph" xml-lang="en-US"> <emph>Var1:</emph> Name of the user-defined type variable that you want to copy to.</paragraph> <paragraph id="par_id3153361" role="paragraph" xml-lang="en-US"> <emph>Var2:</emph> Name of the user-defined type variable that you want to copy from.</paragraph> <paragraph id="par_id3154686" role="paragraph" xml-lang="en-US">If the string is shorter than the string variable, <emph>LSet</emph> left-aligns the string within the string variable. Any remaining positions in the string variable are replaced by spaces. If the string is longer than the string variable, only the leftmost characters up to the length of the string variable are copied. With the <emph>LSet</emph> statement, you can also copy a user-defined type variable to another variable of the same type.</paragraph> -<paragraph id="hd_id3156282" role="heading" level="2" xml-lang="en-US">Example:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functexample"/> <bascode> <paragraph id="par_idm1341571792" role="bascode" localize="false" xml-lang="en-US">Sub ExampleRLSet</paragraph> <paragraph id="par_idm1341570560" role="bascode" localize="false" xml-lang="en-US">Dim sVar As String</paragraph> @@ -76,6 +76,9 @@ <paragraph id="par_idm1341544208" role="bascode" localize="false" xml-lang="en-US"> Print ">"; sVar; "<"</paragraph> <paragraph id="par_idm1341542960" role="bascode" localize="false" xml-lang="en-US">End Sub</paragraph> </bascode> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id161599082457466" localize="false"><embedvar href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph> +</section> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> diff --git a/source/text/sbasic/shared/03120305.xhp b/source/text/sbasic/shared/03120305.xhp index 4cec0d7d78..b0cd811c40 100644 --- a/source/text/sbasic/shared/03120305.xhp +++ b/source/text/sbasic/shared/03120305.xhp @@ -34,25 +34,25 @@ </bookmark> -<paragraph id="hd_id3147574" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03120305.xhp" name="LTrim Function">LTrim Function</link></paragraph> +<h1 id="hd_id3147574"><link href="text/sbasic/shared/03120305.xhp" name="LTrim Function">LTrim Function</link></h1> <paragraph id="par_id3145316" role="paragraph" xml-lang="en-US">Removes all leading spaces at the start of a string expression.</paragraph> </section> -<paragraph id="hd_id3154924" role="heading" level="2" xml-lang="en-US">Syntax:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/> <bascode> <paragraph id="par_id3148552" role="bascode" xml-lang="en-US">LTrim (Text As String)</paragraph> </bascode> -<paragraph id="hd_id3156344" role="heading" level="2" xml-lang="en-US">Return value:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functvalue"/> <paragraph id="par_id3151056" role="paragraph" xml-lang="en-US">String</paragraph> -<paragraph id="hd_id3150543" role="heading" level="2" xml-lang="en-US">Parameters:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functparameters"/> <paragraph id="par_id3150792" role="paragraph" xml-lang="en-US"> <emph>Text:</emph> Any string expression.</paragraph> <paragraph id="par_id3125863" role="paragraph" xml-lang="en-US">Use this function to remove spaces at the beginning of a string expression.</paragraph> <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> <embed href="text/sbasic/shared/00000003.xhp#err5"/> -<paragraph id="hd_id3145419" role="heading" level="2" xml-lang="en-US">Example:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functexample"/> <bascode> <paragraph id="par_idm1340839888" role="bascode" localize="false" xml-lang="en-US">Sub ExampleSpaces</paragraph> <paragraph id="par_idm1340838656" role="bascode" localize="false" xml-lang="en-US">Dim sText2 As String,sText As String,sOut As String</paragraph> @@ -67,6 +67,9 @@ <paragraph id="par_idm1340827232" role="bascode" localize="false" xml-lang="en-US"> MsgBox sOut</paragraph> <paragraph id="par_idm1340826000" role="bascode" localize="false" xml-lang="en-US">End Sub</paragraph> </bascode> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id161599082457466" localize="false"><embedvar href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph> +</section> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> diff --git a/source/text/sbasic/shared/03120306.xhp b/source/text/sbasic/shared/03120306.xhp index bc95904c3e..d3f4efe7ba 100644 --- a/source/text/sbasic/shared/03120306.xhp +++ b/source/text/sbasic/shared/03120306.xhp @@ -35,29 +35,29 @@ </bookmark> -<paragraph id="hd_id3143268" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03120306.xhp" name="Mid Function, Mid Statement">Mid Function, Mid Statement</link></paragraph> +<h1 id="hd_id3143268"><link href="text/sbasic/shared/03120306.xhp" name="Mid Function, Mid Statement">Mid Function, Mid Statement</link></h1> <paragraph id="par_id3148473" role="paragraph" xml-lang="en-US">Returns the specified portion of a string expression (<emph>Mid function</emph>), or replaces the portion of a string expression with another string (<emph>Mid statement</emph>).</paragraph> </section> -<paragraph id="hd_id3154285" role="heading" level="2" xml-lang="en-US">Syntax:</paragraph> +<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> </bascode> -<paragraph id="hd_id3145068" role="heading" level="2" xml-lang="en-US">Return value:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functvalue"/> <paragraph id="par_id3149295" role="paragraph" xml-lang="en-US">String (only by Function)</paragraph> -<paragraph id="hd_id3154347" role="heading" level="2" xml-lang="en-US">Parameters:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functparameters"/> <paragraph id="par_id3148664" role="paragraph" xml-lang="en-US"> <emph>Text:</emph> Any string expression that you want to modify.</paragraph> -<paragraph id="par_id3150359" role="paragraph" xml-lang="en-US"> <emph>Start: </emph>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.<comment>see i17928</comment></paragraph> -<paragraph id="par_id3148451" role="paragraph" xml-lang="en-US"> <emph>Length:</emph> Numeric expression that returns the number of characters that you want to replace or return. The maximum allowed value is 65535.</paragraph> +<paragraph id="par_id3150359" role="paragraph" xml-lang="en-US"> <emph>Start: </emph>Numeric expression that indicates the character position within the string where the string portion that you want to replace or to return begins. The minimum allowed value is 1. The maximum allowed value is 2,147,483,648.<comment>see i17928</comment></paragraph> +<paragraph id="par_id3148451" role="paragraph" xml-lang="en-US"> <emph>Length:</emph> Numeric expression that returns the number of characters that you want to replace or return. The maximum allowed value is 2,147,483,648.</paragraph> <paragraph id="par_id3125864" role="paragraph" xml-lang="en-US">If the Length parameter in the <emph>Mid function</emph> is omitted, all characters in the string expression from the start position to the end of the string are returned.</paragraph> <paragraph id="par_id3144762" role="paragraph" xml-lang="en-US">If the Length parameter in the <emph>Mid statement</emph> is less than the length of the text that you want to replace, the text is reduced to the specified length.</paragraph> <paragraph id="par_id3150769" role="paragraph" xml-lang="en-US"> <emph>Text:</emph> The string to replace the string expression (<emph>Mid statement</emph>).</paragraph> <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> <embed href="text/sbasic/shared/00000003.xhp#err5"/> -<paragraph id="hd_id3149560" role="heading" level="2" xml-lang="en-US">Example:</paragraph> +<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> @@ -71,6 +71,8 @@ <paragraph id="par_idm1341551488" role="bascode" localize="false" xml-lang="en-US"> MsgBox sUS_date</paragraph> <paragraph id="par_idm1341550256" role="bascode" localize="false" xml-lang="en-US">End Sub</paragraph> </bascode> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id161599082457466" localize="false"><embedvar href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph> +</section> </body> - -</helpdocument>
\ No newline at end of file +</helpdocument> diff --git a/source/text/sbasic/shared/03120307.xhp b/source/text/sbasic/shared/03120307.xhp index 4b6a7af3a9..e970b80a1a 100644 --- a/source/text/sbasic/shared/03120307.xhp +++ b/source/text/sbasic/shared/03120307.xhp @@ -34,27 +34,27 @@ </bookmark> -<paragraph id="hd_id3153311" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03120307.xhp" name="Right Function">Right Function</link></paragraph> +<h1 id="hd_id3153311"><link href="text/sbasic/shared/03120307.xhp" name="Right Function">Right Function</link></h1> <paragraph id="par_id3150984" role="paragraph" xml-lang="en-US">Returns the rightmost "n" characters of a string expression.</paragraph> </section> <paragraph id="par_id3149763" role="paragraph" xml-lang="en-US">See also: <link href="text/sbasic/shared/03120303.xhp" name="Left Function">Left Function</link>.</paragraph> -<paragraph id="hd_id3145315" role="heading" level="2" xml-lang="en-US">Syntax:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/> <bascode> <paragraph id="par_id3153061" role="bascode" xml-lang="en-US">Right (Text As String, n As Long)</paragraph> </bascode> -<paragraph id="hd_id3145068" role="heading" level="2" xml-lang="en-US">Return value:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functvalue"/> <paragraph id="par_id3156344" role="paragraph" xml-lang="en-US">String</paragraph> -<paragraph id="hd_id3146795" role="heading" level="2" xml-lang="en-US">Parameters:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functparameters"/> <paragraph id="par_id3153526" role="paragraph" xml-lang="en-US"> <emph>Text:</emph> Any string expression that you want to return the rightmost characters of.</paragraph> -<paragraph id="par_id3151211" role="paragraph" xml-lang="en-US"> <emph>n:</emph> Numeric expression that defines the number of characters that you want to return. If <emph>n</emph> = 0, a zero-length string is returned. The maximum allowed value is 65535.</paragraph> +<paragraph id="par_id3151211" role="paragraph" xml-lang="en-US"> <emph>n:</emph> Numeric expression that defines the number of characters that you want to return. If <emph>n</emph> = 0, a zero-length string is returned. The maximum allowed value is 2,147,483,648.</paragraph> <paragraph id="par_id3158410" role="paragraph" xml-lang="en-US">The following example converts a date in YYYY-MM-DD format to the US date format (MM/DD/YYYY).</paragraph> <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> <embed href="text/sbasic/shared/00000003.xhp#err5"/> -<paragraph id="hd_id3156212" role="heading" level="2" xml-lang="en-US">Example:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functexample"/> <bascode> <paragraph id="par_idm1341027360" role="bascode" localize="false" xml-lang="en-US">Sub ExampleUSDate</paragraph> <paragraph id="par_idm1341026128" role="bascode" localize="false" xml-lang="en-US">Dim sInput As String</paragraph> @@ -68,6 +68,9 @@ <paragraph id="par_idm1341015584" role="bascode" localize="false" xml-lang="en-US"> MsgBox sUS_date</paragraph> <paragraph id="par_idm1341014352" role="bascode" localize="false" xml-lang="en-US">End Sub</paragraph> </bascode> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id161599082457466" localize="false"><embedvar href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph> +</section> </body> </helpdocument> diff --git a/source/text/sbasic/shared/03120308.xhp b/source/text/sbasic/shared/03120308.xhp index 7ac77340e5..e527399c5c 100644 --- a/source/text/sbasic/shared/03120308.xhp +++ b/source/text/sbasic/shared/03120308.xhp @@ -34,16 +34,16 @@ </bookmark> -<paragraph id="hd_id3153345" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03120308.xhp" name="RSet Statement">RSet Statement</link></paragraph> +<h1 id="hd_id3153345"><link href="text/sbasic/shared/03120308.xhp" name="RSet Statement">RSet Statement</link></h1> <paragraph id="par_id3150503" role="paragraph" xml-lang="en-US">Right-aligns a string within a string variable, or copies a user-defined variable type into another.</paragraph> </section> -<paragraph id="hd_id3149234" role="heading" level="2" xml-lang="en-US">Syntax:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/> <bascode> <paragraph id="par_id3150669" role="bascode" xml-lang="en-US">RSet Text As String = Text or RSet Variable1 = Variable2</paragraph> </bascode> -<paragraph id="hd_id3156024" role="heading" level="2" xml-lang="en-US">Parameters:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functparameters"/> <paragraph id="par_id3148552" role="paragraph" xml-lang="en-US"> <emph>Text:</emph> Any string variable.</paragraph> <paragraph id="par_id3154924" role="paragraph" xml-lang="en-US"> <emph>Text</emph>: String that you want to right-align in the string variable.</paragraph> <paragraph id="par_id3149456" role="paragraph" xml-lang="en-US"> <emph>Variable1:</emph> User-defined variable that is the target for the copied variable.</paragraph> @@ -52,7 +52,7 @@ <paragraph id="par_id3149202" role="paragraph" xml-lang="en-US">You can also use the <emph>RSet statement</emph> to assign variables of one user-defined type to another.</paragraph> <paragraph id="par_id3151042" role="paragraph" xml-lang="en-US">The following example uses the <emph>RSet</emph> and <emph>LSet</emph> statements to modify the left and right alignment of a string.</paragraph> -<paragraph id="hd_id3154909" role="heading" level="2" xml-lang="en-US">Example:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functexample"/> <bascode> <paragraph id="par_idm1341567472" role="bascode" localize="false" xml-lang="en-US">Sub ExampleRLSet</paragraph> <paragraph id="par_idm1341566240" role="bascode" localize="false" xml-lang="en-US">Dim sVar As String</paragraph> @@ -78,6 +78,9 @@ <paragraph id="par_idm1341539968" role="bascode" localize="false" xml-lang="en-US"> Print ">"; sVar; "<"</paragraph> <paragraph id="par_idm1341538720" role="bascode" localize="false" xml-lang="en-US">End Sub</paragraph> </bascode> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id161599082457466" localize="false"><embedvar href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph> +</section> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> diff --git a/source/text/sbasic/shared/03120309.xhp b/source/text/sbasic/shared/03120309.xhp index ec7b1cb1c8..5218fc61e8 100644 --- a/source/text/sbasic/shared/03120309.xhp +++ b/source/text/sbasic/shared/03120309.xhp @@ -34,25 +34,25 @@ </bookmark> -<paragraph id="hd_id3154286" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03120309.xhp" name="RTrim Function">RTrim Function</link></paragraph> +<h1 id="hd_id3154286"><link href="text/sbasic/shared/03120309.xhp" name="RTrim Function">RTrim Function</link></h1> <paragraph id="par_id3153127" role="paragraph" xml-lang="en-US">Deletes the spaces at the end of a string expression.</paragraph> </section> <paragraph id="par_id3153062" role="paragraph" xml-lang="en-US">See also: <link href="text/sbasic/shared/03120305.xhp" name="LTrim Function">LTrim Function</link></paragraph> -<paragraph id="hd_id3154924" role="heading" level="2" xml-lang="en-US">Syntax:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/> <bascode> <paragraph id="par_id3154347" role="bascode" xml-lang="en-US">RTrim (Text As String)</paragraph> </bascode> -<paragraph id="hd_id3149457" role="heading" level="2" xml-lang="en-US">Return value:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functvalue"/> <paragraph id="par_id3153381" role="paragraph" xml-lang="en-US">String</paragraph> -<paragraph id="hd_id3148798" role="heading" level="2" xml-lang="en-US">Parameters:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functparameters"/> <paragraph id="par_id3151380" role="paragraph" xml-lang="en-US"> <emph>Text: </emph>Any string expression.</paragraph> <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> <embed href="text/sbasic/shared/00000003.xhp#err5"/> -<paragraph id="hd_id3151041" role="heading" level="2" xml-lang="en-US">Example:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functexample"/> <bascode> <paragraph id="par_idm1341574144" role="bascode" localize="false" xml-lang="en-US">Sub ExampleSpaces</paragraph> <paragraph id="par_idm1341572912" role="bascode" localize="false" xml-lang="en-US">Dim sText2 As String,sText As String,sOut As String</paragraph> @@ -67,6 +67,9 @@ <paragraph id="par_idm1341561488" role="bascode" localize="false" xml-lang="en-US"> MsgBox sOut</paragraph> <paragraph id="par_idm1341560256" role="bascode" localize="false" xml-lang="en-US">End Sub</paragraph> </bascode> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id161599082457466" localize="false"><embedvar href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph> +</section> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> diff --git a/source/text/sbasic/shared/03120310.xhp b/source/text/sbasic/shared/03120310.xhp index 5c052abd28..bf1eab43ee 100644 --- a/source/text/sbasic/shared/03120310.xhp +++ b/source/text/sbasic/shared/03120310.xhp @@ -34,7 +34,7 @@ </bookmark> -<paragraph id="hd_id3153527" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03120310.xhp" name="UCase Function">UCase Function</link></paragraph> +<h1 id="hd_id3153527"><link href="text/sbasic/shared/03120310.xhp" name="UCase Function">UCase Function</link></h1> <paragraph id="par_id3155420" role="paragraph" xml-lang="en-US">Converts lowercase characters in a string to uppercase.</paragraph> </section> <paragraph id="par_id3150771" role="paragraph" xml-lang="en-US">See also: <link href="text/sbasic/shared/03120302.xhp" name="LCase Function">LCase Function</link></paragraph> @@ -57,6 +57,9 @@ <paragraph id="par_id3156280" role="bascode" xml-lang="en-US"> Print UCase(sVar) ' returns "LAS VEGAS"</paragraph> <paragraph id="par_idm1340871632" role="bascode" localize="false" xml-lang="en-US">End Sub</paragraph> </bascode> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id161599082457466" localize="false"><embedvar href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph> +</section> </body> </helpdocument> diff --git a/source/text/sbasic/shared/03120311.xhp b/source/text/sbasic/shared/03120311.xhp index 5dd60bae28..f8e1752225 100644 --- a/source/text/sbasic/shared/03120311.xhp +++ b/source/text/sbasic/shared/03120311.xhp @@ -34,24 +34,24 @@ </bookmark> -<paragraph id="hd_id3150616" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03120311.xhp" name="Trim Function">Trim Function</link></paragraph> +<h1 id="hd_id3150616"><link href="text/sbasic/shared/03120311.xhp" name="Trim Function">Trim Function</link></h1> <paragraph id="par_id3149177" role="paragraph" xml-lang="en-US">Removes all leading and trailing spaces from a string expression.</paragraph> </section> -<paragraph id="hd_id3159157" role="heading" level="2" xml-lang="en-US">Syntax:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/> <bascode> <paragraph id="par_id3155341" role="bascode" xml-lang="en-US">Trim( Text As String )</paragraph> </bascode> -<paragraph id="hd_id3155388" role="heading" level="2" xml-lang="en-US">Return value:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functvalue"/> <paragraph id="par_id3143228" role="paragraph" xml-lang="en-US">String</paragraph> -<paragraph id="hd_id3145609" role="heading" level="2" xml-lang="en-US">Parameters:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functparameters"/> <paragraph id="par_id3159414" role="paragraph" xml-lang="en-US"> <emph>Text:</emph> Any string expression.</paragraph> <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> <embed href="text/sbasic/shared/00000003.xhp#err5"/> -<paragraph id="hd_id3148663" role="heading" level="2" xml-lang="en-US">Example:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functexample"/> <bascode> <paragraph id="par_idm1341576784" role="bascode" localize="false" xml-lang="en-US">Sub ExampleSpaces</paragraph> <paragraph id="par_idm1341575552" role="bascode" localize="false" xml-lang="en-US">Dim sText2 As String,sText As String,sOut As String</paragraph> @@ -66,6 +66,9 @@ <paragraph id="par_idm1341564128" role="bascode" localize="false" xml-lang="en-US"> MsgBox sOut</paragraph> <paragraph id="par_idm1341562896" role="bascode" localize="false" xml-lang="en-US">End Sub</paragraph> </bascode> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id161599082457466" localize="false"><embedvar href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph> +</section> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> diff --git a/source/text/sbasic/shared/03120312.xhp b/source/text/sbasic/shared/03120312.xhp index 3c17b560b6..a6599480e8 100644 --- a/source/text/sbasic/shared/03120312.xhp +++ b/source/text/sbasic/shared/03120312.xhp @@ -1,5 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - <!-- * This file is part of the LibreOffice project. * @@ -17,7 +16,6 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - <helpdocument version="1.0"> <meta> <topic id="textsbasicshared03120312xml" indexer="include" status="PUBLISH"> @@ -32,22 +30,22 @@ <section id="converttourl"> <bookmark xml-lang="en-US" branch="index" id="bm_id3152801"><bookmark_value>ConvertToURL function</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3152801" xml-lang="en-US" level="1"><link href="text/sbasic/shared/03120312.xhp" name="ConvertToURL Function">ConvertToURL Function</link></paragraph> +<h1 id="hd_id3152801"><link href="text/sbasic/shared/03120312.xhp" name="ConvertToURL Function">ConvertToURL Function</link></h1> <paragraph role="paragraph" id="par_id3148538" xml-lang="en-US">Converts a system file name to a file URL.</paragraph> </section> -<paragraph role="heading" id="hd_id3150669" xml-lang="en-US" level="2">Syntax:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/> <bascode> <paragraph role="bascode" id="par_id3154285" xml-lang="en-US">ConvertToURL(filename)</paragraph> </bascode> -<paragraph role="heading" id="hd_id3150984" xml-lang="en-US" level="2">Return value:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functvalue"/> <paragraph role="paragraph" id="par_id3147530" xml-lang="en-US">String</paragraph> -<paragraph role="heading" id="hd_id3148550" xml-lang="en-US" level="2">Parameters:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functparameters"/> <paragraph role="paragraph" id="par_id3148947" xml-lang="en-US"> <emph>Filename:</emph> A file name as string.</paragraph> <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> <embed href="text/sbasic/shared/00000003.xhp#err5"/> <section id="exampleconverttofromurl"> -<paragraph role="heading" id="hd_id3153361" xml-lang="en-US" level="2">Example:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functexample"/> <bascode> <paragraph role="bascode" id="par_id3150792" xml-lang="en-US">systemFile$ = "c:\folder\mytext.txt"</paragraph> <paragraph role="bascode" localize="false" id="par_id3154365" xml-lang="en-US">url$ = ConvertToURL( systemFile$ )</paragraph> @@ -56,5 +54,8 @@ <paragraph role="bascode" localize="false" id="par_id3144762" xml-lang="en-US">print systemFileAgain$</paragraph> </bascode> </section> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id161599082457466" localize="false"><embedvar href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph> +</section> </body> </helpdocument> diff --git a/source/text/sbasic/shared/03120313.xhp b/source/text/sbasic/shared/03120313.xhp index c9a98ce0a7..0d8b57b2e1 100644 --- a/source/text/sbasic/shared/03120313.xhp +++ b/source/text/sbasic/shared/03120313.xhp @@ -1,5 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - <!-- * This file is part of the LibreOffice project. * @@ -17,7 +16,6 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - <helpdocument version="1.0"> <meta> <topic id="textsbasicshared03120313xml" indexer="include" status="PUBLISH"> @@ -32,20 +30,23 @@ <section id="convertfromurl"> <bookmark xml-lang="en-US" branch="index" id="bm_id3153894"><bookmark_value>ConvertFromURL function</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3153894" xml-lang="en-US" level="1"><link href="text/sbasic/shared/03120313.xhp" name="ConvertFromURL Function">ConvertFromURL Function</link></paragraph> +<h1 id="hd_id3153894"><link href="text/sbasic/shared/03120313.xhp" name="ConvertFromURL Function">ConvertFromURL Function</link></h1> <paragraph role="paragraph" id="par_id3147226" xml-lang="en-US">Converts a file URL to a system file name.</paragraph> </section> -<paragraph role="heading" id="hd_id3143267" xml-lang="en-US" level="2">Syntax:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/> <bascode> <paragraph role="bascode" id="par_id3154142" xml-lang="en-US">ConvertFromURL(filename)</paragraph> </bascode> -<paragraph role="heading" id="hd_id3159157" xml-lang="en-US" level="2">Return value:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functvalue"/> <paragraph role="paragraph" id="par_id3150669" xml-lang="en-US">String</paragraph> -<paragraph role="heading" id="hd_id3143270" xml-lang="en-US" level="2">Parameters:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functparameters"/> <paragraph role="paragraph" id="par_id3156023" xml-lang="en-US"> <emph>Filename:</emph> A file name as a string.</paragraph> <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> <embed href="text/sbasic/shared/00000003.xhp#err5"/> <embed href="text/sbasic/shared/03120312.xhp#exampleconverttofromurl"/> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id161599082457466" localize="false"><embedvar href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph> +</section> </body> </helpdocument> diff --git a/source/text/sbasic/shared/03120314.xhp b/source/text/sbasic/shared/03120314.xhp index aae47d81c1..23c8cc4d3a 100644 --- a/source/text/sbasic/shared/03120314.xhp +++ b/source/text/sbasic/shared/03120314.xhp @@ -34,24 +34,24 @@ </bookmark> -<paragraph id="hd_id3156027" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03120314.xhp" name="Split Function">Split Function</link></paragraph> +<h1 id="hd_id3156027"><link href="text/sbasic/shared/03120314.xhp" name="Split Function">Split Function</link></h1> <paragraph id="par_id3155805" role="paragraph" xml-lang="en-US">Returns an array of substrings from a string expression.</paragraph> </section> -<paragraph id="hd_id3149177" role="heading" level="2" xml-lang="en-US">Syntax:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/> <bascode> <paragraph id="par_id3153824" role="bascode" xml-lang="en-US">Split (Text As String, delimiter, number)</paragraph> </bascode> -<paragraph id="hd_id3149763" role="heading" level="2" xml-lang="en-US">Return value:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functvalue"/> <paragraph id="par_id3154285" role="paragraph" xml-lang="en-US">String</paragraph> -<paragraph id="hd_id3145315" role="heading" level="2" xml-lang="en-US">Parameters:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functparameters"/> <paragraph id="par_id3156023" role="paragraph" xml-lang="en-US"> <emph>Text:</emph> Any string expression.</paragraph> <paragraph id="par_id3147560" role="paragraph" xml-lang="en-US"> <emph>delimiter (optional):</emph> A string of one or more characters length that is used to delimit the Text. The default is the space character.</paragraph> <paragraph id="par_id3145069" role="paragraph" xml-lang="en-US"> <emph>number (optional):</emph> The number of substrings that you want to return.</paragraph> -<paragraph id="hd_id3150398" role="heading" level="2" xml-lang="en-US">Example:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functexample"/> <section id="splitjoinex"> <bascode> @@ -96,6 +96,9 @@ <paragraph id="par_idm1341238032" role="bascode" localize="false" xml-lang="en-US">End Sub</paragraph> </bascode> </section> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id161599082457466" localize="false"><embedvar href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph> +</section> </body> -</helpdocument>
\ No newline at end of file +</helpdocument> diff --git a/source/text/sbasic/shared/03120315.xhp b/source/text/sbasic/shared/03120315.xhp index 286c33e5d8..361e666cc9 100644 --- a/source/text/sbasic/shared/03120315.xhp +++ b/source/text/sbasic/shared/03120315.xhp @@ -1,5 +1,4 @@ <?xml version="1.0" encoding="UTF-8"?> - <!-- * This file is part of the LibreOffice project. * @@ -17,7 +16,6 @@ * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . --> - <helpdocument version="1.0"> <meta> <topic id="textsbasicshared03120315xml" indexer="include" status="PUBLISH"> @@ -32,22 +30,24 @@ <section id="join"> <bookmark xml-lang="en-US" branch="index" id="bm_id3149416"><bookmark_value>Join function</bookmark_value> </bookmark> -<paragraph role="heading" id="hd_id3149416" xml-lang="en-US" level="1"><link href="text/sbasic/shared/03120315.xhp" name="Join Function">Join Function</link></paragraph> +<h1 id="hd_id3149416"><link href="text/sbasic/shared/03120315.xhp" name="Join Function">Join Function</link></h1> <paragraph role="paragraph" id="par_id3149670" xml-lang="en-US">Returns a string from a number of substrings in a string array.</paragraph> </section> -<paragraph role="heading" id="hd_id3159414" xml-lang="en-US" level="2">Syntax:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functsyntax"/> <bascode> <paragraph role="bascode" id="par_id3156344" xml-lang="en-US">Join (Text As String Array, delimiter)</paragraph> </bascode> -<paragraph role="heading" id="hd_id3150400" xml-lang="en-US" level="2">Return value:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functvalue"/> <paragraph role="paragraph" id="par_id3150359" xml-lang="en-US">String</paragraph> -<paragraph role="heading" id="hd_id3148798" xml-lang="en-US" level="2">Parameters:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functparameters"/> <paragraph role="paragraph" id="par_id3145171" xml-lang="en-US"> <emph>Text:</emph> A string array.</paragraph> <paragraph role="paragraph" id="par_id3154908" xml-lang="en-US"> <emph>delimiter (optional):</emph> A string character that is used to separate the substrings in the resulting string. The default delimiter is the space character. If delimiter is a string of length zero "", the substrings are joined without separator.</paragraph> -<paragraph role="heading" id="hd_id3154218" xml-lang="en-US" level="2">Example:</paragraph> +<embed href="text/sbasic/shared/00000003.xhp#functexample"/> <embed href="text/sbasic/shared/03120314.xhp#splitjoinex"/> +<section id="relatedtopics"> + <paragraph role="paragraph" id="par_id161599082457466" localize="false"><embedvar href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph> +</section> </body> </helpdocument> - diff --git a/source/text/sbasic/shared/03120401.xhp b/source/text/sbasic/shared/03120401.xhp index a1ccb0bf70..3bf471ea9b 100644 --- a/source/text/sbasic/shared/03120401.xhp +++ b/source/text/sbasic/shared/03120401.xhp @@ -34,21 +34,21 @@ </bookmark> -<paragraph id="hd_id3155934" role="heading" level="1" xml-lang="en-US"><link href="text/sbasic/shared/03120401.xhp" name="InStr Function">InStr Function</link></paragraph> +<h1 id="hd_id3155934"><link href="text/sbasic/shared/03120401.xhp" name="InStr Function">InStr Function</link></h1> <paragraph id="par_id3153990" role="paragraph" xml-lang="en-US">Returns the position of a string within another string.</paragraph> </section> <paragraph id="par_id3147303" role="paragraph" xml-lang="en-US">The Instr function returns the position at which the match was found. If the string was not found, the function returns 0.</paragraph> -<paragraph id="hd_id3145090" role="heading" level="2" xml-lang="en-US">Syntax:</paragraph> +<h2 id="hd_id3145090">Syntax:</h2> <bascode> <paragraph id="par_id3146957" role="bascode" xml-lang="en-US">InStr ([Start As Long,] Text1 As String, Text2 As String[, Compare])</paragraph> </bascode> -<paragraph id="hd_id3148538" role="heading" level="2" xml-lang="en-US">Return value:</paragraph> +<h2 id="hd_id3148538">Return value:</h2> <paragraph id="par_id3149763" role="paragraph" xml-lang="en-US">Integer</paragraph> -<paragraph id="hd_id3148473" role="heading" level="2" xml-lang="en-US">Parameters:</paragraph> -<paragraph id="par_id3153126" role="paragraph" xml-lang="en-US"> <emph>Start: </emph>A numeric expression that marks the position in a string where the search for the specified substring starts. If you omit this parameter, the search starts at the first character of the string. The maximum allowed value is 65535.<comment>see i17928</comment></paragraph> +<h2 id="hd_id3148473">Parameters:</h2> +<paragraph id="par_id3153126" role="paragraph" xml-lang="en-US"> <emph>Start: </emph>A numeric expression that marks the position in a string where the search for the specified substring starts. If you omit this parameter, the search starts at the first character of the string. The minimum allowed value is 1. The maximum allowed value is 2,147,483,648.<comment>see i17928</comment></paragraph> <paragraph id="par_id3145609" role="paragraph" xml-lang="en-US"> <emph>Text1:</emph> The string expression that you want to search.</paragraph> <paragraph id="par_id3147559" role="paragraph" xml-lang="en-US"> <emph>Text2:</emph> The string expression that you want to search for.</paragraph> <paragraph id="par_id3154758" role="paragraph" xml-lang="en-US"> <emph>Compare:</emph> Optional numeric expression that defines the type of comparison. The value of this parameter can be 0 or 1. The default value of 1 specifies a text comparison that is not case-sensitive. The value of 0 specifies a binary comparison that is case-sensitive.<comment>fixes i17929</comment></paragraph> @@ -56,7 +56,7 @@ <embed href="text/sbasic/shared/00000003.xhp#errorcode"/> <embed href="text/sbasic/shared/00000003.xhp#err5"/> -<paragraph id="hd_id3154366" role="heading" level="2" xml-lang="en-US">Example:</paragraph> +<h2 id="hd_id3154366">Example:</h2> <bascode> <paragraph id="par_idm1341612352" role="bascode" localize="false" xml-lang="en-US">Sub ExamplePosition</paragraph> <paragraph id="par_idm1341611120" role="bascode" localize="false" xml-lang="en-US">Dim sInput As String</paragraph> diff --git a/source/text/sbasic/shared/replace.xhp b/source/text/sbasic/shared/replace.xhp index 7f4e825f1e..7b8d819d98 100644 --- a/source/text/sbasic/shared/replace.xhp +++ b/source/text/sbasic/shared/replace.xhp @@ -50,5 +50,8 @@ <paragraph role="bascode" id="par_id501587778372566" xml-lang="en-US" localize="false">msgbox replace ("ABCDEFGHI", "E", "*", 4)</paragraph> <paragraph role="bascode" id="par_id861587778446685" xml-lang="en-US">REM returns D*FGHI because the search starts at position 4, which is also the start of the returned string.</paragraph> </bascode> + <section id="relatedtopics"> + <paragraph role="paragraph" id="par_id161599082457466" localize="false"><embedvar href="text/sbasic/shared/00000003.xhp#stringfunctions"/></paragraph> + </section> </body> </helpdocument> |