Fast/Unload standard functions - Revision history

Dme: /* #STRIP: Remove leading and/or trailing copies of pad character */

2017-01-26T19:28:51Z

#STRIP: Remove leading and/or trailing copies of pad character

← Older revision		Revision as of 19:28, 26 January 2017
Line 2,126:		Line 2,126:

	<tr><th>'N...' (uppercase <code>N</code>)</th>		<tr><th>'N...' (uppercase <code>N</code>)</th>
	<td>Strips <b>N</b>either leading characters nor trailing characters. </td></tr>		<td>Strips <b>N</b>either leading characters nor trailing characters. This can be useful if you <b>only</b> want to use <var>#STRIP</var> to replace <var class="term">nullval</var> with the null string.</td></tr>

	<tr><th>'P...' (uppercase <code>P</code>)</th>		<tr><th>'P...' (uppercase <code>P</code>)</th>
Line 2,150:		Line 2,150:
	#STRIP(' ABC ', 'L') returns 'ABC '		#STRIP(' ABC ', 'L') returns 'ABC '
	#STRIP(' ABC ', 'T') returns ' ABC'		#STRIP(' ABC ', 'T') returns ' ABC'

	#STRIP('000123', 'L', '0') returns '123'		#STRIP('000123', 'L', '0') returns '123'
	#STRIP('000123', 'P', '0', '_') returns '~~0123~~'		#STRIP('000123', 'P', '0') returns '123'

			#STRIP('000000', 'L', '0') returns ''
			#STRIP('000000', 'P', '0') returns '0'

			#STRIP('_123', 'P', , '_') returns '_123'
			#STRIP('_', 'P', , '_') returns ''
			#STRIP('__', 'P', , '_') returns '__'

			#STRIP(' _', 'P', , '_') returns '_'
			#STRIP(' _', 'N', , '_') returns ' _'
			#STRIP('_', 'P', , '_') returns ''
			#STRIP('_', 'N', , '_') returns ''
	</nowiki></p>		</nowiki></p>
	<p>		<p>

ELowell: /* #STRIP: Remove leading and/or trailing copies of pad character */

2017-01-20T18:01:20Z

#STRIP: Remove leading and/or trailing copies of pad character

← Older revision		Revision as of 18:01, 20 January 2017
Line 2,104:		Line 2,104:
	character from a string. It accepts an optional specification of which characters to strip (Leading, Trailing, or Both).		character from a string. It accepts an optional specification of which characters to strip (Leading, Trailing, or Both).
	It also lets you designate a <var>#STRIP</var> first-argument value to be nullified.		It also lets you designate a <var>#STRIP</var> first-argument value to be nullified.
	<p class="syntax"><span class="term">%out</span> = #STRIP(<span class="term">str</span>, [B\|L~~\|LK~~\|N\|P\|T], [<span class="term">pad</span>], [<span class="term">nullval</span>])		<p class="syntax"><span class="term">%out</span> = #STRIP(<span class="term">str</span>, [B\|L\|N\|P\|T], [<span class="term">pad</span>], [<span class="term">nullval</span>])
	</p>		</p>
	Where:		Where:
Line 2,114:		Line 2,114:
	<td>String to be stripped; required.</td></tr>		<td>String to be stripped; required.</td></tr>

	<tr><th><var>B</var>\|<var>L~~</var>\|<var>LK~~</var>\|<var>N</var>\|<var>P</var>\|<var>T</var></th>		<tr><th><var>B</var>\|<var>L</var>\|<var>N</var>\|<var>P</var>\|<var>T</var></th>
	<td>Optional indicator of the type of strip; defaults to <var>B</var>:		<td>Optional indicator of the type of strip; defaults to <var>B</var>:
	<table class="thJustBold">		<table class="thJustBold">
Line 2,124:		Line 2,124:
	<tr><th>'L...' (uppercase <code>L</code>)</th>		<tr><th>'L...' (uppercase <code>L</code>)</th>
	<td>Strips <b>L</b>eading pad characters only. </td></tr>		<td>Strips <b>L</b>eading pad characters only. </td></tr>

	~~<tr><th>'LK...' (uppercase <code>LK</code>)</th>~~
	~~<td>Strips leading zeroes from numeric value output. </td></tr>~~

	<tr><th>'N...' (uppercase <code>N</code>)</th>		<tr><th>'N...' (uppercase <code>N</code>)</th>
Line 2,138:		Line 2,135:
	</table>		</table>
	<p>		<p>
	The ~~<var>LK</var>,~~ <var>N</var>, and <var>P</var> options are available as of version 7.7 of <var class="product">Fast/Unload</var>. </p></td></tr>		The <var>N</var> and <var>P</var> options are available as of version 7.7 of <var class="product">Fast/Unload</var>. </p></td></tr>

	<tr><th>pad</th>		<tr><th>pad</th>
Line 2,160:		Line 2,157:
	code of 8 when:</p>		code of 8 when:</p>
	<ul>		<ul>
	<li><var>B\|L~~\|LK~~\|N\|P\|T</var> does not begin with uppercase <code>B</code>, <code>L~~</code>, <code>LK~~</code>, <code>N</code>, <code>P</code>, or uppercase <code>T</code>. </li>		<li><var>B\|L\|N\|P\|T</var> does not begin with uppercase <code>B</code>, <code>L</code>, <code>N</code>, <code>P</code>, or uppercase <code>T</code>. </li>

	<li><var class="term">pad</var> specified and length is not 1. </li>		<li><var class="term">pad</var> specified and length is not 1. </li>

Dme: Undo revision 95297 by Dme (talk)

2017-01-19T23:06:13Z

Undo revision 95297 by Dme (talk)

← Older revision		Revision as of 23:06, 19 January 2017
Line 2,126:		Line 2,126:

	<tr><th>'LK...' (uppercase <code>LK</code>)</th>		<tr><th>'LK...' (uppercase <code>LK</code>)</th>
	<td>Strips leading ~~fill characters (usually 0)~~ from numeric value output. </td></tr>		<td>Strips leading zeroes from numeric value output. </td></tr>

	<tr><th>'N...' (uppercase <code>N</code>)</th>		<tr><th>'N...' (uppercase <code>N</code>)</th>

Dme: Undo revision 95298 by Dme (talk)

2017-01-19T23:05:57Z

Undo revision 95298 by Dme (talk)

← Older revision		Revision as of 23:05, 19 January 2017
Line 2,126:		Line 2,126:

	<tr><th>'LK...' (uppercase <code>LK</code>)</th>		<tr><th>'LK...' (uppercase <code>LK</code>)</th>
	<td>Strips leading fill characters (usually 0) from value. </td></tr>		<td>Strips leading fill characters (usually 0) from numeric value output. </td></tr>

	<tr><th>'N...' (uppercase <code>N</code>)</th>		<tr><th>'N...' (uppercase <code>N</code>)</th>

Dme: /* #STRIP: Remove leading and/or trailing copies of pad character */

2017-01-19T22:55:52Z

#STRIP: Remove leading and/or trailing copies of pad character

← Older revision		Revision as of 22:55, 19 January 2017
Line 2,126:		Line 2,126:

	<tr><th>'LK...' (uppercase <code>LK</code>)</th>		<tr><th>'LK...' (uppercase <code>LK</code>)</th>
	<td>Strips leading fill characters (usually 0) from ~~numeric~~ value ~~output~~. </td></tr>		<td>Strips leading fill characters (usually 0) from value. </td></tr>

	<tr><th>'N...' (uppercase <code>N</code>)</th>		<tr><th>'N...' (uppercase <code>N</code>)</th>

Dme: /* #STRIP: Remove leading and/or trailing copies of pad character */

2017-01-19T22:55:02Z

#STRIP: Remove leading and/or trailing copies of pad character

← Older revision		Revision as of 22:55, 19 January 2017
Line 2,126:		Line 2,126:

	<tr><th>'LK...' (uppercase <code>LK</code>)</th>		<tr><th>'LK...' (uppercase <code>LK</code>)</th>
	<td>Strips leading ~~zeroes~~ from numeric value output. </td></tr>		<td>Strips leading fill characters (usually 0) from numeric value output. </td></tr>

	<tr><th>'N...' (uppercase <code>N</code>)</th>		<tr><th>'N...' (uppercase <code>N</code>)</th>

JAL: add #STRIP 7.7 changes

2016-09-08T20:33:39Z

add #STRIP 7.7 changes

Show changes

JAL: add product version

2016-09-08T20:16:27Z

add product version

← Older revision		Revision as of 20:16, 8 September 2016
Line 2,197:		Line 2,197:
	</ul>		</ul>
	<p>		<p>
	Defaults to <var>B</var>. The <var>LK</var>, <var>N</var>, and <var>P</var> options are available as of version 7.7 of ~~Model 204~~. </p></td></tr>		Defaults to <var>B</var>. The <var>LK</var>, <var>N</var>, and <var>P</var> options are available as of version 7.7 of <var class="product">Fast/Unload</var>. </p></td></tr>

	<tr><th>pad</th>		<tr><th>pad</th>
Line 2,205:		Line 2,205:
	<td>The <var class="term">str</var> value to be output as a null; optional. If the value of <var class="term">str</var> is equal to the value of <var class="term">nullval</var>, <var>#STRIP</var> returns a null string for <var class="term">str</var>.		<td>The <var class="term">str</var> value to be output as a null; optional. If the value of <var class="term">str</var> is equal to the value of <var class="term">nullval</var>, <var>#STRIP</var> returns a null string for <var class="term">str</var>.
	<p>		<p>
	Available as of version 7.7 of ~~Model 204~~, you might use <var class="term">nullval</var> for fields that have a "placeholder value" or "default value" that is not actual data.</p></td></tr>		Available as of version 7.7 of <var class="product">Fast/Unload</var>, you might use <var class="term">nullval</var> for fields that have a "placeholder value" or "default value" that is not actual data.</p></td></tr>
	</table>		</table>
	<p><b>Examples</b>		<p><b>Examples</b>

JAL: /* #STRIP: Remove leading and/or trailing copies of pad character */ add 7.7 options

2016-09-08T19:41:34Z

#STRIP: Remove leading and/or trailing copies of pad character: add 7.7 options

← Older revision		Revision as of 19:41, 8 September 2016
Line 2,170:		Line 2,170:
	The <var>#STRIP</var> function removes leading, trailing, or both, copies of a pad		The <var>#STRIP</var> function removes leading, trailing, or both, copies of a pad
	character from a string. It accepts an optional specification of which characters to strip (Leading, Trailing, or Both).		character from a string. It accepts an optional specification of which characters to strip (Leading, Trailing, or Both).
	It lets you designate a <var>#STRIP</var> first-argument value to be nullified.		It also lets you designate a <var>#STRIP</var> first-argument value to be nullified.
	<p class="syntax"><span class="term">%out</span> = #STRIP(<span class="term">str</span>, [B\|L\|T], [<span class="term">pad</span>], [<span class="term">nullval</span>])		<p class="syntax"><span class="term">%out</span> = #STRIP(<span class="term">str</span>, [B\|L\|LK\|N\|P\|T], [<span class="term">pad</span>], [<span class="term">nullval</span>])
	</p>		</p>
	Where:		Where:
Line 2,184:		Line 2,184:
	<td>Optional indicator of the type of strip:		<td>Optional indicator of the type of strip:
	<ul>		<ul>
	<li>'B...' (any string beginning with uppercase <code>B</code>): ~~to strip~~ <b>B</b>oth leading and trailing pad characters. </li>		<li>'B...' (any string beginning with uppercase <code>B</code>): strips <b>B</b>oth leading and trailing pad characters. </li>

	<li>'L...' (any string beginning with uppercase <code>L</code>): ~~to strip~~ <b>L</b>eading pad characters only. </li>		<li>'L...' (any string beginning with uppercase <code>L</code>): strips <b>L</b>eading pad characters only. </li>

			<li>'LK...' (any string beginning with uppercase <code>LK</code>): strips leading zeroes from numeric value output. </li>

			<li>'N...' (any string beginning with uppercase <code>N</code>): <b>N</b>o leading-character or trailing-character stripping. </li>

			<li>'P...' (any string beginning with uppercase <code>P</code>): strips all but one leading <b>P</b>ad character from consecutive leading <var class="term">pad</var> characters. </li>

	<li>'T...' (any string beginning with uppercase <code>T</code>): to strip <b>T</b>railing pad characters only. </li>		<li>'T...' (any string beginning with uppercase <code>T</code>): to strip <b>T</b>railing pad characters only. </li>
	</ul>		</ul>
	<p>		<p>
	Defaults to <var>B</var>.		Defaults to <var>B</var>. The <var>LK</var>, <var>N</var>, and <var>P</var> options are available as of version 7.7 of Model 204. </p></td></tr>
	</p></td></tr>

	<tr><th>pad</th>		<tr><th>pad</th>
Line 2,204:		Line 2,209:
	<p><b>Examples</b>		<p><b>Examples</b>
	</p>		</p>
	<p class="code"><nowiki>#STRIP(' ABC ') returns 'ABC'		<p class="code"><nowiki>#STRIP(' ABC ') returns 'ABC'
	#STRIP(' ABC ', 'L') returns 'ABC '		#STRIP(' ABC ', 'L') returns 'ABC '
	#STRIP(' ABC ', 'T') returns ' ABC'		#STRIP(' ABC ', 'T') returns ' ABC'
	#STRIP('000123', 'L', '0') returns '123'		#STRIP('000123', 'L', '0') returns '123'
			#STRIP('000123', 'P', '0', '_') returns '0123'
	</nowiki></p>		</nowiki></p>
	<p>		<p>
Line 2,213:		Line 2,219:
	code of 8 when:</p>		code of 8 when:</p>
	<ul>		<ul>
	<li><var>B\|L\|T</var> does not begin with ~~either~~ uppercase <code>B</code>, ~~uppercase~~ <code>L</code>, or uppercase <code>T</code>. </li>		<li><var>B\|L\|LK\|N\|P\|T</var> does not begin with uppercase <code>B</code>, <code>L</code>, <code>LK</code>, <code>N</code>, <code>P</code>, or uppercase <code>T</code>. </li>

	<li><var class="term">pad</var> specified and length is not 1. </li>		<li><var class="term">pad</var> specified and length is not 1. </li>
Line 2,222:		Line 2,228:
	<li>This #function is similar to the <var>#DEBLANK</var> function ([[##deblnk\|#DEBLANK: Remove leading and trailing blanks from substring]]). </li>		<li>This #function is similar to the <var>#DEBLANK</var> function ([[##deblnk\|#DEBLANK: Remove leading and trailing blanks from substring]]). </li>
	</ul>		</ul>
	~~<p>~~
	~~This #function is new in <var class="product">Fast/Unload</var> version 4.0.~~
	~~</p>~~

	<div id="#substr"></div>		<div id="#substr"></div>

JAL: remove comment

2016-09-07T20:02:17Z

remove comment

← Older revision		Revision as of 20:02, 7 September 2016
Line 1:		Line 1:
	~~<!-- Page name: Fast/Unload standard functions-->~~
	{{DISPLAYTITLE:Fast/Unload standard #functions}}		{{DISPLAYTITLE:Fast/Unload standard #functions}}
	This wiki page lists the #functions provided with <var class="product">Fast/Unload</var>.		This wiki page lists the #functions provided with <var class="product">Fast/Unload</var>.