1cdf0e10cSrcweir<?xml version="1.0" encoding="UTF-8"?> 2cdf0e10cSrcweir 3cdf0e10cSrcweir 4*226a8927SAndrew Rist<!--*********************************************************** 5cdf0e10cSrcweir * 6*226a8927SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 7*226a8927SAndrew Rist * or more contributor license agreements. See the NOTICE file 8*226a8927SAndrew Rist * distributed with this work for additional information 9*226a8927SAndrew Rist * regarding copyright ownership. The ASF licenses this file 10*226a8927SAndrew Rist * to you under the Apache License, Version 2.0 (the 11*226a8927SAndrew Rist * "License"); you may not use this file except in compliance 12*226a8927SAndrew Rist * with the License. You may obtain a copy of the License at 13*226a8927SAndrew Rist * 14*226a8927SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 15*226a8927SAndrew Rist * 16*226a8927SAndrew Rist * Unless required by applicable law or agreed to in writing, 17*226a8927SAndrew Rist * software distributed under the License is distributed on an 18*226a8927SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 19*226a8927SAndrew Rist * KIND, either express or implied. See the License for the 20*226a8927SAndrew Rist * specific language governing permissions and limitations 21*226a8927SAndrew Rist * under the License. 22*226a8927SAndrew Rist * 23*226a8927SAndrew Rist ***********************************************************--> 24*226a8927SAndrew Rist 25*226a8927SAndrew Rist 26cdf0e10cSrcweir 27cdf0e10cSrcweir<helpdocument version="1.0"> 28cdf0e10cSrcweir<meta> 29cdf0e10cSrcweir<topic id="textsbasicshared03120308xml" indexer="include" status="PUBLISH"> 30cdf0e10cSrcweir<title id="tit" xml-lang="en-US">RSet Statement [Runtime]</title> 31cdf0e10cSrcweir<filename>/text/sbasic/shared/03120308.xhp</filename> 32cdf0e10cSrcweir</topic> 33cdf0e10cSrcweir<history> 34cdf0e10cSrcweir<created date="2003-10-31T00:00:00">Sun Microsystems, Inc.</created> 35cdf0e10cSrcweir<lastedited date="2004-08-24T14:16:38">converted from old format - fpe</lastedited> 36cdf0e10cSrcweir</history> 37cdf0e10cSrcweir</meta> 38cdf0e10cSrcweir<body> 39cdf0e10cSrcweir<section id="rset"> 40cdf0e10cSrcweir<bookmark xml-lang="en-US" branch="index" id="bm_id3153345"><bookmark_value>RSet statement</bookmark_value> 41cdf0e10cSrcweir</bookmark> 42cdf0e10cSrcweir<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> 43cdf0e10cSrcweir<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> 44cdf0e10cSrcweir</section> 45cdf0e10cSrcweir<paragraph role="heading" id="hd_id3149234" xml-lang="en-US" level="2" l10n="U" oldref="3">Syntax:</paragraph> 46cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150669" xml-lang="en-US" l10n="U" oldref="4">RSet Text As String = Text or RSet Variable1 = Variable2</paragraph> 47cdf0e10cSrcweir<paragraph role="heading" id="hd_id3156024" xml-lang="en-US" level="2" l10n="U" oldref="5">Parameters:</paragraph> 48cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3148552" xml-lang="en-US" l10n="U" oldref="6"> 49cdf0e10cSrcweir<emph>Text:</emph> Any string variable.</paragraph> 50cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154924" xml-lang="en-US" l10n="U" oldref="7"> 51cdf0e10cSrcweir<emph>Text</emph>: String that you want to right-align in the string variable.</paragraph> 52cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149456" xml-lang="en-US" l10n="U" oldref="8"> 53cdf0e10cSrcweir<emph>Variable1:</emph> User-defined variable that is the target for the copied variable.</paragraph> 54cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153381" xml-lang="en-US" l10n="U" oldref="9"> 55cdf0e10cSrcweir<emph>Variable2:</emph> User-defined variable that you want to copy to another variable.</paragraph> 56cdf0e10cSrcweir<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> 57cdf0e10cSrcweir<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> 58cdf0e10cSrcweir<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> 59cdf0e10cSrcweir<paragraph role="heading" id="hd_id3154909" xml-lang="en-US" level="2" l10n="U" oldref="13">Example:</paragraph> 60cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154218" xml-lang="en-US" l10n="U" oldref="14">Sub ExampleRLSet</paragraph> 61cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3147288" xml-lang="en-US" l10n="U" oldref="15">Dim sVar as string</paragraph> 62cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153367" xml-lang="en-US" l10n="U" oldref="16">Dim sExpr as string</paragraph> 63cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153952" xml-lang="en-US" l10n="U" oldref="18">sVar = String(40,"*")</paragraph> 64cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154013" xml-lang="en-US" l10n="U" oldref="19">sExpr = "SBX"</paragraph> 65cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3155856" xml-lang="en-US" l10n="U" oldref="20">REM Right-align "SBX" in a 40-character string</paragraph> 66cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3152577" xml-lang="en-US" l10n="U" oldref="21">REM Replace asterisks with spaces</paragraph> 67cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149260" xml-lang="en-US" l10n="U" oldref="22">RSet sVar = sExpr</paragraph> 68cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3156444" xml-lang="en-US" l10n="U" oldref="23">Print ">"; sVar; "<"</paragraph> 69cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3148575" xml-lang="en-US" l10n="U" oldref="25">sVar = String(5,"*")</paragraph> 70cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153140" xml-lang="en-US" l10n="U" oldref="26">sExpr = "123457896"</paragraph> 71cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153144" xml-lang="en-US" l10n="U" oldref="27">RSet sVar = sExpr</paragraph> 72cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150116" xml-lang="en-US" l10n="U" oldref="28">Print ">"; sVar; "<"</paragraph> 73cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154491" xml-lang="en-US" l10n="U" oldref="30">sVar = String(40,"*")</paragraph> 74cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149412" xml-lang="en-US" l10n="U" oldref="31">sExpr = "SBX"</paragraph> 75cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3145801" xml-lang="en-US" l10n="U" oldref="32">REM Left-align "SBX" in a 40-character string</paragraph> 76cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3145646" xml-lang="en-US" l10n="U" oldref="33">LSet sVar = sExpr</paragraph> 77cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154511" xml-lang="en-US" l10n="U" oldref="34">Print ">"; sVar; "<"</paragraph> 78cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3153839" xml-lang="en-US" l10n="U" oldref="36">sVar = String(5,"*")</paragraph> 79cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3149122" xml-lang="en-US" l10n="U" oldref="37">sExpr = "123456789"</paragraph> 80cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3150330" xml-lang="en-US" l10n="U" oldref="38">LSet sVar = sExpr</paragraph> 81cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3154480" xml-lang="en-US" l10n="U" oldref="39">Print ">"; sVar; "<"</paragraph> 82cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3148914" xml-lang="en-US" l10n="U" oldref="40">End Sub</paragraph> 83cdf0e10cSrcweir</body> 84cdf0e10cSrcweir</helpdocument> 85