1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 3226a8927SAndrew Rist<!--*********************************************************** 415ea6395Smseidel * 5226a8927SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 6226a8927SAndrew Rist * or more contributor license agreements. See the NOTICE file 7226a8927SAndrew Rist * distributed with this work for additional information 8226a8927SAndrew Rist * regarding copyright ownership. The ASF licenses this file 9226a8927SAndrew Rist * to you under the Apache License, Version 2.0 (the 10226a8927SAndrew Rist * "License"); you may not use this file except in compliance 11226a8927SAndrew Rist * with the License. You may obtain a copy of the License at 1215ea6395Smseidel * 13226a8927SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 1415ea6395Smseidel * 15226a8927SAndrew Rist * Unless required by applicable law or agreed to in writing, 16226a8927SAndrew Rist * software distributed under the License is distributed on an 17226a8927SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 18226a8927SAndrew Rist * KIND, either express or implied. See the License for the 19226a8927SAndrew Rist * specific language governing permissions and limitations 20226a8927SAndrew Rist * under the License. 2115ea6395Smseidel * 22226a8927SAndrew Rist ***********************************************************--> 23226a8927SAndrew Rist 24cdf0e10cSrcweir<helpdocument version="1.0"> 25cdf0e10cSrcweir<meta> 26cdf0e10cSrcweir<topic id="textsbasicshared03120308xml" indexer="include" status="PUBLISH"> 27cdf0e10cSrcweir<title id="tit" xml-lang="en-US">RSet Statement [Runtime]</title> 28cdf0e10cSrcweir<filename>/text/sbasic/shared/03120308.xhp</filename> 29cdf0e10cSrcweir</topic> 30cdf0e10cSrcweir</meta> 31cdf0e10cSrcweir<body> 32cdf0e10cSrcweir<section id="rset"> 33*54be4daeSmseidel<bookmark xml-lang="en-US" branch="index" id="bm_id3153345"> 34*54be4daeSmseidel<bookmark_value>RSet statement</bookmark_value> 35cdf0e10cSrcweir</bookmark> 36cdf0e10cSrcweir<paragraph role="heading" id="hd_id3153345" xml-lang="en-US" level="1" l10n="U" oldref="1"><link href="text/sbasic/shared/03120308.xhp" name="RSet Statement [Runtime]">RSet Statement [Runtime]</link></paragraph> 37cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150503" xml-lang="en-US" l10n="U" oldref="2">Right-aligns a string within a string variable, or copies a user-defined variable type into another.</paragraph> 38cdf0e10cSrcweir</section> 39cdf0e10cSrcweir<paragraph role="heading" id="hd_id3149234" xml-lang="en-US" level="2" l10n="U" oldref="3">Syntax:</paragraph> 40cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150669" xml-lang="en-US" l10n="U" oldref="4">RSet Text As String = Text or RSet Variable1 = Variable2</paragraph> 41cdf0e10cSrcweir<paragraph role="heading" id="hd_id3156024" xml-lang="en-US" level="2" l10n="U" oldref="5">Parameters:</paragraph> 42cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3148552" xml-lang="en-US" l10n="U" oldref="6"> 43cdf0e10cSrcweir<emph>Text:</emph> Any string variable.</paragraph> 44cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154924" xml-lang="en-US" l10n="U" oldref="7"> 45cdf0e10cSrcweir<emph>Text</emph>: String that you want to right-align in the string variable.</paragraph> 46cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149456" xml-lang="en-US" l10n="U" oldref="8"> 47cdf0e10cSrcweir<emph>Variable1:</emph> User-defined variable that is the target for the copied variable.</paragraph> 48cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153381" xml-lang="en-US" l10n="U" oldref="9"> 49cdf0e10cSrcweir<emph>Variable2:</emph> User-defined variable that you want to copy to another variable.</paragraph> 50cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154140" xml-lang="en-US" l10n="U" oldref="10">If the string is shorter than the string variable, <emph>RSet</emph> aligns the string to the right within the string variable. Any remaining characters in the string variable are replaced with spaces. If the string is longer than the string variable, characters exceeding the length of the variable are truncated, and only the remaining characters are right-aligned within the string variable.</paragraph> 51cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149202" xml-lang="en-US" l10n="U" oldref="11">You can also use the <emph>RSet statement</emph> to assign variables of one user-defined type to another.</paragraph> 52cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3151042" xml-lang="en-US" l10n="U" oldref="12">The following example uses the <emph>RSet</emph> and <emph>LSet</emph> statements to modify the left and right alignment of a string.</paragraph> 53cdf0e10cSrcweir<paragraph role="heading" id="hd_id3154909" xml-lang="en-US" level="2" l10n="U" oldref="13">Example:</paragraph> 54cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154218" xml-lang="en-US" l10n="U" oldref="14">Sub ExampleRLSet</paragraph> 55cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3147288" xml-lang="en-US" l10n="U" oldref="15">Dim sVar as string</paragraph> 56cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153367" xml-lang="en-US" l10n="U" oldref="16">Dim sExpr as string</paragraph> 57cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153952" xml-lang="en-US" l10n="U" oldref="18">sVar = String(40,"*")</paragraph> 58cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154013" xml-lang="en-US" l10n="U" oldref="19">sExpr = "SBX"</paragraph> 59cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3155856" xml-lang="en-US" l10n="U" oldref="20">REM Right-align "SBX" in a 40-character string</paragraph> 60cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3152577" xml-lang="en-US" l10n="U" oldref="21">REM Replace asterisks with spaces</paragraph> 61cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149260" xml-lang="en-US" l10n="U" oldref="22">RSet sVar = sExpr</paragraph> 62cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3156444" xml-lang="en-US" l10n="U" oldref="23">Print ">"; sVar; "<"</paragraph> 63cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3148575" xml-lang="en-US" l10n="U" oldref="25">sVar = String(5,"*")</paragraph> 64cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153140" xml-lang="en-US" l10n="U" oldref="26">sExpr = "123457896"</paragraph> 65cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153144" xml-lang="en-US" l10n="U" oldref="27">RSet sVar = sExpr</paragraph> 66cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150116" xml-lang="en-US" l10n="U" oldref="28">Print ">"; sVar; "<"</paragraph> 67cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154491" xml-lang="en-US" l10n="U" oldref="30">sVar = String(40,"*")</paragraph> 68cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149412" xml-lang="en-US" l10n="U" oldref="31">sExpr = "SBX"</paragraph> 69cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3145801" xml-lang="en-US" l10n="U" oldref="32">REM Left-align "SBX" in a 40-character string</paragraph> 70cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3145646" xml-lang="en-US" l10n="U" oldref="33">LSet sVar = sExpr</paragraph> 71cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154511" xml-lang="en-US" l10n="U" oldref="34">Print ">"; sVar; "<"</paragraph> 72cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153839" xml-lang="en-US" l10n="U" oldref="36">sVar = String(5,"*")</paragraph> 73cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149122" xml-lang="en-US" l10n="U" oldref="37">sExpr = "123456789"</paragraph> 74cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150330" xml-lang="en-US" l10n="U" oldref="38">LSet sVar = sExpr</paragraph> 75cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154480" xml-lang="en-US" l10n="U" oldref="39">Print ">"; sVar; "<"</paragraph> 76cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3148914" xml-lang="en-US" l10n="U" oldref="40">End Sub</paragraph> 77cdf0e10cSrcweir</body> 78cdf0e10cSrcweir</helpdocument> 79