| Line 1: |
Line 1: |
| − | <div id="6SpaceContent" class="zcontent" align="left"> | + | <div style="font-size:30px">'''CLEAN(text)'''</div><br/> |
| | + | *text is any string to remove non-printable characters. |
| | | | |
| − | '''CLEAN'''(Text)
| + | ==Description== |
| | + | *It removes all non-printable characters from text entered. |
| | + | *Printable characters are from ASCII values 32 to 127 |
| | + | *CLEAN function remove all other characters other that ASCII values 32 to 127.. |
| | | | |
| − | where,
| + | ==Example== |
| − | | |
| − | '''Text''' - is any text from which to remove nonprintable characters.
| |
| − | | |
| − | </div>
| |
| − | ----
| |
| − | <div id="1SpaceContent" class="zcontent" align="left">It removes all nonprintable characters from text.</div>
| |
| − | ----
| |
| − | <div id="7SpaceContent" class="zcontent" align="left">CLEAN function remove the first 32 nonprinting characters in the 7-bit ASCII(0 to 31)from text.</div>
| |
| − | ----
| |
| − | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
| |
| − | | |
| − | CLEAN
| |
| − | | |
| − | </div></div>
| |
| − | ----
| |
| − | <div id="8SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | Lets see an example in (Column1, Row2)
| |
| − | | |
| − | <nowiki>=CLEAN(R1C1)</nowiki>
| |
| − | | |
| − | CLEAN returns Zcubes.
| |
| − | | |
| − | </div>
| |
| − | ----
| |
| − | <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
| |
| − | ----
| |
| − | <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
| |
| − | ----
| |
| − | <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
| |
| − | ----
| |
| − | <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
| |
| − | ----
| |
| − | <div id="2SpaceContent" class="zcontent" align="left">
| |
| | | | |
| | {| id="TABLE3" class="SpreadSheet blue" | | {| id="TABLE3" class="SpreadSheet blue" |
| | |- class="even" | | |- class="even" |
| − | | class=" " |
| + | ! CLEAN("�ZCubes�") |
| − | | class=" " | Column1
| + | ! �ZCubes� |
| − | | Column2
| + | ! ZCubes |
| − | | Column3
| + | |
| − | | Column4 | + | |- |
| | |- class="odd" | | |- class="odd" |
| − | | class=" " | Row1 | + | |CLEAN(B5) |
| − | | class="sshl_f" | �Zcubes�
| + | |ஸtrial� |
| − | | class=" " | | + | |trial |
| − | | class=" " | | + | |
| − | | class=" " |
| |
| | |- class="even" | | |- class="even" |
| − | | class=" " | Row2 | + | | CLEAN(nb) |
| − | | class="sshl_f SelectTD ChangeBGColor SelectTD" | | + | |89 |
| − | <div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div>Zcubes
| + | |Y |
| − | | class=" " | | + | |
| − | | class=" " |
| |
| − | | class=" " |
| |
| | |- class="odd" | | |- class="odd" |
| − | | Row3 | + | |CLEAN("†††cross†††") |
| − | | class=" " |
| + | |†††cross††† |
| − | | class=" " |
| + | |cross |
| − | | class=" " |
| + | |
| − | | class=" " |
| |
| − | |- class="even"
| |
| − | | Row4
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | |- class="odd"
| |
| − | | class=" " | Row5
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class=" " | | |
| − | | class=" " | | |
| − | |- class="even"
| |
| − | | Row6
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| | |} | | |} |
| | | | |
| − | <div align="left">[[Image:calci1.gif]]</div></div>
| + | ==See Also== |
| − | ----
| + | *[[Manuals/calci/CHAR| CHAR]] |
| | + | *[[Manuals/calci/CODE| CODE]] |
| | + | |
| | + | ==References== |
| | + | [http://en.wikipedia.org/wiki/ASCII ASCII Values] |
| | + | [http://web.itu.edu.tr/~sgunduz/courses/mikroisl/ascii.html Printable & Non-printable Characters] |