Saturday 27 August 2016

Ajax Mask Delimiters in asp.net


//HTML

<asp:ToolkitScriptManager ID="toolkitM" runat="server"></asp:ToolkitScriptManager>


<asp:TextBox ID="txt_code" runat="server" Width="130px" Height="22px" />
<asp:MaskedEditExtender ID="MaskedEditExtender2" runat="server"
            TargetControlID="txt_code"
             Mask="9,999,999.99"
             MessageValidatorTip="true"
             OnFocusCssClass="MaskedEditFocus"
             OnInvalidCssClass="MaskedEditError"
             MaskType="Number"
             InputDirection="RightToLeft"
             AcceptNegative="Left"
             DisplayMoney="Left"
             ErrorTooltipEnabled="True">

             </asp:MaskedEditExtender>


//Result - only numeric with decimal

<asp:TextBox ID="txt_code" runat="server" Width="130px" Height="22px" />
<asp:MaskedEditExtender ID="MaskedEditExtender2" runat="server"
            TargetControlID="txt_code"
             Mask="LL/999,999.99"
             MessageValidatorTip="true"
             OnFocusCssClass="MaskedEditFocus"
             OnInvalidCssClass="MaskedEditError"
             MaskType="Number"
             InputDirection="RightToLeft"
             AcceptNegative="Left"
             DisplayMoney="Left"
             ErrorTooltipEnabled="True">

             </asp:MaskedEditExtender>

//Result - Alpha/numeric,numeric.numeric

Mask Type-

None – No validation
Number – Number validation
Date – Date validation
Time – Time validation
DateTime – Date and time validation

1) Mask Characters and Delimiters
9 - Only a numeric character
L - Only a letter
$ - Only a letter or a space
C - Only a custom character (case sensitive)
A - Only a letter or a custom character
N - Only a numeric or custom character
? - Any character

/ - Date separator
: - Time separator
. - Decimal separator
, - Thousand separator
\ - Escape character
{ - Initial delimiter for repetition of masks
} - Final delimiter for repetition of masks

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...