$Alpha - Revision history

JAL: typo

2018-01-08T20:04:30Z

typo

← Older revision		Revision as of 20:04, 8 January 2018
Line 13:		Line 13:
	<li>0, for a false condition if one of these occurs:		<li>0, for a false condition if one of these occurs:
	<ul>		<ul>
	<li><var class="term">string</var> contains digits, spaces, or punctuation marks~~, or~~</li>		<li><var class="term">string</var> contains digits, spaces, or punctuation marks</li>
	<li><var class="term">string</var> is null</li>		<li><var class="term">string</var> is null</li>
	<li>U.S. English characters in the string have accent marks.</li>		<li>U.S. English characters in the string have accent marks</li>
	</ul></li>		</ul></li>
	</ul></td></tr>		</ul></td></tr>
Line 23:		Line 23:
	<ul>		<ul>
	<li>A literal enclosed in quotation marks</li>		<li>A literal enclosed in quotation marks</li>
	<li>A [[~~Using_variables_and_values_in_computation~~\|%variable]]</li>		<li>A [[Using variables and values in_computation\|%variable]]</li>
	<li>A field name without quotation marks. In this case, the function call must be embedded in a <var>[[Record_loops#FOR_EACH_RECORD_statement\|FOR EACH RECORD]]</var> loop where the current value of the field is verified.</li>		<li>A field name without quotation marks. In this case, the function call must be embedded in a <var>[[Record_loops#FOR_EACH_RECORD_statement\|FOR EACH RECORD]]</var> loop where the current value of the field is verified.</li>
	</ul></td></tr>		</ul></td></tr>

JAL: add italics

2018-01-08T16:56:25Z

add italics

← Older revision		Revision as of 16:56, 8 January 2018
Line 1:		Line 1:
	<p>		<p>
	The <var>$Alpha</var> function verifies whether a string is composed only of characters ~~which~~ are valid in the specified (or default) language.		The <var>$Alpha</var> function verifies whether a string is composed only of characters that are valid in the specified (or default) language.
			</p>

			==Syntax==
			<p class="syntax"><span class="term">%result</span> = $Alpha(<span class="term">string</span> [,<span class="term">language</span>]) </p>

			<table>
			<tr><th>%result</th>
			<td>A numeric variable that contains:
	<ul>		<ul>
	<li>1 ~~is returned~~ for a true condition.</li>		<li>1, for a true condition.</li>
	<li>0 ~~is returned~~ for a false condition if:		<li>0, for a false condition if one of these occurs:
	<ul>		<ul>
	<li>~~the~~ string contains digits, spaces, or punctuation marks, or</li>		<li><var class="term">string</var> contains digits, spaces, or punctuation marks, or</li>
	<li>~~the~~ string is null~~, or~~</li>		<li><var class="term">string</var> is null</li>
	<li>U.S. English characters in the string have accent marks.</li>		<li>U.S. English characters in the string have accent marks.</li>
	</ul>		</ul></li>
	</li>		</ul></td></tr>
	</ul></p>

	~~==Syntax==~~		<tr><th>string</th>
	<p>~~The format of the $Alpha function is:~~<~~/p>~~		<td>The string to be verified. <var class="term">string</var> must be one of the following:
	~~<p class="syntax">$Alpha(<span class="term"~~>string</~~span> [,<span class="term">language</span>]) </p~~>
	<p>
	~~Where:</p>~~
	~~<ul>~~
	~~<li~~><var class="term">string</var> ~~represents the string to be verified. The string~~ must be one of the following:
	<ul>		<ul>
	<li>A literal enclosed in quotation marks</li>		<li>A literal enclosed in quotation marks</li>
	<li>A [[Using_variables_and_values_in_computation\|%variable]]</li>		<li>A [[Using_variables_and_values_in_computation\|%variable]]</li>
	<li>A field name without quotation marks. In this case, the function call must be embedded in a <var>[[Record_loops#FOR_EACH_RECORD_statement\|FOR EACH RECORD]]</var> loop where the current value of the field is verified.</li>		<li>A field name without quotation marks. In this case, the function call must be embedded in a <var>[[Record_loops#FOR_EACH_RECORD_statement\|FOR EACH RECORD]]</var> loop where the current value of the field is verified.</li>
	</ul></li>		</ul></td></tr>

	<li>~~The~~ optional <var class="term">language</var> ~~argument specifies the language to use. The language argument~~ is handled as follows:		<tr><th>language</th>
			<td>An optional string that specifies the language to use. <var class="term">language</var> is handled as follows:
	<ul>		<ul>
	<li>You can enter a literal enclosed in quotation marks or a %variable containing a valid language name. If the value you enter is not a supported language, the request is canceled with the following error message. See the <var>[[LANGUSER parameter\|LANGUSER]]</var> parameter for the valid values.		<li>You can enter a literal enclosed in quotation marks or a %variable containing a valid language name. If the value you enter is not a supported language, the request is canceled with the following error message. See the <var>[[LANGUSER parameter\|LANGUSER]]</var> parameter for the valid values.
Line 33:		Line 36:
	<li>If you omit the <var class="term">language</var> argument, <var class="product">Model 204</var> performs the validation in U.S. English, even if the value of the <var>LANGUSER</var> parameter is not <code>US</code>, and lowercase characters are not recognized.</li>		<li>If you omit the <var class="term">language</var> argument, <var class="product">Model 204</var> performs the validation in U.S. English, even if the value of the <var>LANGUSER</var> parameter is not <code>US</code>, and lowercase characters are not recognized.</li>

	<li>An asterisk enclosed in quotation marks (<tt>'*'</tt>) instructs <var class="product">Model 204</var> to use the value of the <var>LANGUSER</var> parameter.		<li>An asterisk enclosed in quotation marks (<tt>'*'</tt>) instructs <var class="product">Model 204</var> to use the value of the <var>LANGUSER</var> parameter. </li>
	</li>		</ul></td></tr>
	</ul></li>		</table>
	</ul>

	==Examples==		==Examples==

DCameron: /* Syntax */

2018-01-08T11:22:15Z

Syntax

← Older revision		Revision as of 11:22, 8 January 2018
Line 22:		Line 22:
	<li>A literal enclosed in quotation marks</li>		<li>A literal enclosed in quotation marks</li>
	<li>A [[Using_variables_and_values_in_computation\|%variable]]</li>		<li>A [[Using_variables_and_values_in_computation\|%variable]]</li>
	<li>A field name without quotation marks. In this case, the function call must be embedded in a <var>FOR EACH RECORD</var> loop where the current value of the field is verified.</li>		<li>A field name without quotation marks. In this case, the function call must be embedded in a <var>[[Record_loops#FOR_EACH_RECORD_statement\|FOR EACH RECORD]]</var> loop where the current value of the field is verified.</li>
	</ul></li>		</ul></li>

DCameron: /* Syntax */

2018-01-08T11:20:55Z

Syntax

← Older revision		Revision as of 11:20, 8 January 2018
Line 21:		Line 21:
	<ul>		<ul>
	<li>A literal enclosed in quotation marks</li>		<li>A literal enclosed in quotation marks</li>
	<li>A %variable</li>		<li>A [[Using_variables_and_values_in_computation\|%variable]]</li>
	<li>A field name without quotation marks. In this case, the function call must be embedded in a <var>FOR EACH RECORD</var> loop where the current value of the field is verified.</li>		<li>A field name without quotation marks. In this case, the function call must be embedded in a <var>FOR EACH RECORD</var> loop where the current value of the field is verified.</li>
	</ul></li>		</ul></li>

ELowell at 22:11, 3 March 2016

2016-03-03T22:11:12Z

← Older revision		Revision as of 22:11, 3 March 2016
Line 2:		Line 2:
	The <var>$Alpha</var> function verifies whether a string is composed only of characters which are valid in the specified (or default) language.		The <var>$Alpha</var> function verifies whether a string is composed only of characters which are valid in the specified (or default) language.
	<ul>		<ul>
	<li>1 is returned ~~if the~~ condition ~~is true~~.</li>		<li>1 is returned for a true condition.</li>
	<li>0 is returned if ~~the condition is false; for example~~:		<li>0 is returned for a false condition if:
	<ul>		<ul>
	<li>the string contains digits, spaces, or punctuation marks</li>		<li>the string contains digits, spaces, or punctuation marks, or</li>
	<li>the string is null</li>		<li>the string is null, or</li>
	<li>U.S. English characters in a string have accent marks</li>		<li>U.S. English characters in the string have accent marks.</li>
	</ul>		</ul>
	</li>		</li>

ELowell: misc cleanup

2016-03-03T21:27:57Z

misc cleanup

← Older revision		Revision as of 21:27, 3 March 2016
Line 1:		Line 1:
	<p>		<p>
	The <var>$Alpha</var> function verifies whether a string is composed only of characters which are valid in the specified (or default) language. A 1 is returned if the condition is true~~; otherwise, a~~ 0 is returned ~~(for a false~~ condition~~). A 0~~ is ~~returned if there are any~~ spaces or punctuation marks ~~in the string, or if~~ the string is null.</p>		The <var>$Alpha</var> function verifies whether a string is composed only of characters which are valid in the specified (or default) language.
			<ul>
			<li>1 is returned if the condition is true.</li>
			<li>0 is returned if the condition is false; for example:
			<ul>
			<li>the string contains digits, spaces, or punctuation marks</li>
			<li>the string is null</li>
			<li>U.S. English characters in a string have accent marks</li>
			</ul>
			</li>
			</ul></p>

	==Syntax==		==Syntax==
Line 8:		Line 18:
	Where:</p>		Where:</p>
	<ul>		<ul>
	<li><var class="term">string</var> represents the string to be verified. string must be one of:		<li><var class="term">string</var> represents the string to be verified. The string must be one of the following:
	<ul>		<ul>
	<li>A literal enclosed in quotation marks</li>		<li>A literal enclosed in quotation marks</li>
			<li>A %variable</li>
	<li>%variable</li>

	<li>A field name without quotation marks. In this case, the function call must be embedded in a <var>FOR EACH RECORD</var> loop where the current value of the field is verified.</li>		<li>A field name without quotation marks. In this case, the function call must be embedded in a <var>FOR EACH RECORD</var> loop where the current value of the field is verified.</li>
	</ul></li>		</ul></li>
Line 32:		Line 40:
	==Examples==		==Examples==
	<p>		<p>
	The following table has examples of the ~~pattern~~ and language arguments as literals:</p>		The following table has examples of the <var class="term">string</var> and <var class="term">language</var> arguments as literals.</p>
	<table>		<table>
	<tr class="head">		<tr class="head">
Line 62:		Line 70:
	</table>		</table>
	<p>		<p>
	~~The~~ following request sorts and prints the names of agents whose name contains ~~non alphabetic~~ characters. The quoted asterisk in the <var>$Alpha</var> call causes <var class="product">Model 204</var> to verify the contents of the field <code>AGENT</code> against whatever language is indicated by the value of the <var>LANGUSER</var> parameter:</p>		In the following code example, the request sorts and prints the names of agents whose name contains nonalphabetic characters. The quoted asterisk in the <var>$Alpha</var> call causes <var class="product">Model 204</var> to verify the contents of the field <code>AGENT</code> against whatever language is indicated by the value of the <var>LANGUSER</var> parameter:</p>
	<p class="code">BEGIN		<p class="code">RESET LANGUSER 'FRENCHC'
			BEGIN
	POL.HOLDERS: FIND ALL RECORDS FOR WHICH		POL.HOLDERS: FIND ALL RECORDS FOR WHICH
	RECTYPE = POLICYHOLDER		RECTYPE = POLICYHOLDER

JAL: misc cleanup

2015-03-09T20:47:55Z

misc cleanup

Show changes

Mlarocca at 14:21, 17 June 2014

2014-06-17T14:21:25Z

← Older revision		Revision as of 14:21, 17 June 2014
Line 2:		Line 2:
	<b>Syntax</b>		<b>Syntax</b>
	<p>The format of the $Alpha function is:</p>		<p>The format of the $Alpha function is:</p>
	<p class="code">$~~ALPHA~~(string <var>[</var>,language<var>]</var>)		<p class="code">$Alpha(string <var>[</var>,language<var>]</var>)
	</p>		</p>
	<p>where:</p>		<p>where:</p>
Line 35:		Line 35:
	<tr>		<tr>
	<td>		<td>
	<p class="code"><var>$~~ALPHA~~('JOHN','US')</var>		<p class="code"><var>$alpha('JOHN','US')</var>
	</p></td>		</p></td>
	<td align="right"><var>1</var></td>		<td align="right"><var>1</var></td>
Line 41:		Line 41:
	<tr>		<tr>
	<td>		<td>
	<p class="code"><var>$~~ALPHA~~('M�CON','FRENCHC')</var>		<p class="code"><var>$alpha('M�CON','FRENCHC')</var>
	</p></td>		</p></td>
	<td align="right"><var>1</var></td>		<td align="right"><var>1</var></td>
Line 47:		Line 47:
	<tr>		<tr>
	<td>		<td>
	<p class="code">$~~ALPHA~~('<var>M�CON','US')</var>		<p class="code">$alpha('<var>M�CON','US')</var>
	</p></td>		</p></td>
	<td align="right">0</td>		<td align="right">0</td>
Line 53:		Line 53:
	<tr>		<tr>
	<td>		<td>
	<p class="code"><var>$~~ALPHA~~('JOHN SMITH','US')</var>		<p class="code"><var>$alpha('JOHN SMITH','US')</var>
	</p></td>		</p></td>
	<td align="right"><var>0</var></td>		<td align="right"><var>0</var></td>
Line 59:		Line 59:
	<tr>		<tr>
	<td>		<td>
	<p class="code"><var>$~~ALPHA~~('�LE D'ORL�ANS','FRENCHC')</var>		<p class="code"><var>$alpha('�LE D'ORL�ANS','FRENCHC')</var>
	</p></td>		</p></td>
	<td align="right"><var>0</var></td>		<td align="right"><var>0</var></td>
Line 65:		Line 65:
	<tr>		<tr>
	<td>		<td>
	<p class="code"><var>$~~ALPHA~~('12A','US')</var>		<p class="code"><var>$alpha('12A','US')</var>
	</p></td>		</p></td>
	<td align="right"><var>0</var></td>		<td align="right"><var>0</var></td>
Line 71:		Line 71:
	<tr>		<tr>
	<td>		<td>
	<p class="code"><var>$~~ALPHA~~('12A','FRENCHC')</var>		<p class="code"><var>$alpha('12A','FRENCHC')</var>
	</p></td>		</p></td>
	<td align="right"><var>0</var></td>		<td align="right"><var>0</var></td>
	</tr>		</tr>
	</table>		</table>
	<p>The following request sorts and prints the names of agents whose name contains non alphabetic characters. The quoted asterisk in the $~~ALPHA~~ call causes <var class="product">Model 204</var> to verify the contents of the field AGENT against whatever language is indicated by the value of the LANGUSER parameter:</p>		<p>The following request sorts and prints the names of agents whose name contains non alphabetic characters. The quoted asterisk in the $Alpha call causes <var class="product">Model 204</var> to verify the contents of the field AGENT against whatever language is indicated by the value of the LANGUSER parameter:</p>
	<p class="code">BEGIN		<p class="code">BEGIN
	POL.HOLDERS: FIND ALL RECORDS FOR WHICH		POL.HOLDERS: FIND ALL RECORDS FOR WHICH
Line 82:		Line 82:
	END FIND		END FIND
	FOR EACH RECORD IN POL.HOLDERS		FOR EACH RECORD IN POL.HOLDERS
	IF NOT $~~ALPHA~~ (AGENT, '*') THEN		IF NOT $alpha (AGENT, '*') THEN
	PLACE RECORD ON LIST BADNAME		PLACE RECORD ON LIST BADNAME
	END IF		END IF
Line 92:		Line 92:
	END		END
	</p>		</p>
	<p class="note"><b>Note:</b> For upward compatibility reasons, $~~ALPHA~~ and $~~ALPHNUM~~ do not recognize lowercase English letters as alphabetic characters unless a non-null language parameter is specified.</p>		<p class="note"><b>Note:</b> For upward compatibility reasons, $Alpha and $Alphnum do not recognize lowercase English letters as alphabetic characters unless a non-null language parameter is specified.</p>
	[[Category:SOUL $functions]]		[[Category:SOUL $functions]]

Mlarocca at 14:18, 17 June 2014

2014-06-17T14:18:30Z

← Older revision		Revision as of 14:18, 17 June 2014
Line 1:		Line 1:
	<p>The $~~ALPHA~~ function verifies whether a string is composed only of characters which are valid in the specified (or default) language. A 1 is returned if the condition is true; otherwise, a 0 is returned (for a false condition). A 0 is returned if there are any spaces or punctuation marks in the string, or if the string is null.</p>		<p>The $Alpha function verifies whether a string is composed only of characters which are valid in the specified (or default) language. A 1 is returned if the condition is true; otherwise, a 0 is returned (for a false condition). A 0 is returned if there are any spaces or punctuation marks in the string, or if the string is null.</p>
	<b>Syntax</b>		<b>Syntax</b>
	<p>The format of the $~~ALPHA~~ function is:</p>		<p>The format of the $Alpha function is:</p>
	<p class="code">$ALPHA(string <var>[</var>,language<var>]</var>)		<p class="code">$ALPHA(string <var>[</var>,language<var>]</var>)
	</p>		</p>

Mlarocca: Mlarocca moved page $ALPHA to $Alpha: Change capitalization of title

2014-06-17T14:03:46Z

Mlarocca moved page $ALPHA to $Alpha: Change capitalization of title

← Older revision	Revision as of 14:03, 17 June 2014
(No difference)