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 "&gt;"; sVar; "&lt;"</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 "&gt;"; sVar; "&lt;"</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 "&gt;"; sVar; "&lt;"</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 "&gt;"; sVar; "&lt;"</paragraph>
82cdf0e10cSrcweir<paragraph role="paragraph" id="par_id3148914" xml-lang="en-US" l10n="U" oldref="40">End Sub</paragraph>
83cdf0e10cSrcweir</body>
84cdf0e10cSrcweir</helpdocument>
85