[{"id":"528e7c85-ad74-4b92-9f07-1b35686aae11","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"b2467823-b20a-4944-8436-3f4a40c2c3a6","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"f9b599ec-cdc1-43e1-9642-54622ec0faf6","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"0c129b8a-7ec0-4a16-8d94-9d4c96121d6b","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"747081eb-5a06-4bac-8e9e-ce86732d168f","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"7d934b01-e977-477a-b989-d25201e93a61","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"62adecb9-3003-4dce-9fa0-33dcdebbd1ed","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"e2676e30-9712-47a0-ae38-733003d74c61","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"6ef06797-8c4c-4b4b-ab10-bb5049aedeff","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"48e7593f-03b2-454d-a45c-cfebca71f3aa","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"59bb5a92-94c0-471a-bbe7-422ee9c9671d","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"56744168-6aab-46c6-8144-702458dc0030","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"6e65ca69-e34b-47ac-a900-df6142d1173a","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"69a3b51b-bbd6-4bf9-b1bf-404bc1130679","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"7e9ac756-4b27-4ccd-87b4-d959dae40aac","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"f9f145be-535c-49f0-85e0-46b82e05ebb9","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"f21c39dc-8e0d-4974-8795-5568b46411b4","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"f1c5b466-1fd4-4130-88dd-9a624a6ea008","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"61aee7ec-5eae-4b92-b381-bc6236377b8b","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"8f3919c2-f0c9-4000-8008-be65026b6290","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"1ec6d1ad-90cc-4094-980f-43aa5fbf9540","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"78b0db4b-017c-4839-8c1e-60f6f5cc6d2b","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"cdf43116-31aa-4260-b33a-9a31c6845eb2","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"9e8044a9-aa63-4694-997d-13747cd3ee9d","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"ecd23122-8f53-4c60-837d-198fd699dfc0","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"7a9b6718-9f7b-4f86-a13f-1af00e6e1fd8","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"363dda9e-fe69-4e08-aae8-37d0147254e3","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"5c96fdcf-19a2-4aed-838a-8ed87a27a690","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"43ba9142-9a42-4717-866b-92a6acafcf6e","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"58f7dc81-7471-48e9-9020-1a2359e01121","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"0536592d-c039-4a1b-b482-aa0ba315a78d","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"2981cffc-37a3-4e64-b682-71d898259ddc","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"bdfcce31-4e7a-46f0-8571-d643d6ae5215","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"a1c74507-1bc8-4333-b919-337bcd7f421a","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"6bb55ad9-04e0-47f2-8343-5e9cb0f24fbc","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"f668bfbe-c4fa-4b5f-add5-f82db90b9710","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"6c4638bd-062c-4cc3-97c1-0daafc8624de","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"55aca15e-f3aa-46ab-95c6-9af4e0c779bc","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"000b26f4-c878-447f-acfc-d7e5571dbd01","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"2822ff18-ccc4-40ab-b205-760e5dc66a93","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"978e1414-788c-42b3-ab45-c91e172a80f8","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"2fced7df-d3ca-43a7-86d8-dfebd34541f7","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"f7b8e156-8572-43aa-aec7-fe176eacc758","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"2a1a5e3f-2bbe-4b96-8587-dbe13a089d4d","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"9a3f74e4-ebdf-4c28-ac95-6901cccf878c","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"9fd5b62f-8f1b-444e-9dcb-3d71965cfc6a","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"ab33528a-79c3-4b1c-82dd-15c99eb9419b","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"3a2e4995-96ce-4123-b7a9-d801c3135e5c","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"1480a066-6c2d-4d50-bf05-fcfb0ea27869","tags":[{"product":null,"links":null,"id":"78ee7eb0-7046-4328-b5b1-adffaa31c45b","name":"New","color":"red","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"533dc174-547d-4419-8260-a62dc1e3a2b6","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"2756d249-e4ca-48db-9775-1b76fc3efc5a","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]},{"id":"c0e02434-b0d8-4b70-83ef-f6ad2ac07536","tags":[{"product":null,"links":null,"id":"a6e583c6-ea84-4023-910e-aaf8c71c5fea","name":"Upd","color":"blue","productId":"c15646e4-63d8-4965-8d62-7549a2986e99"}]}]
        
(Showing Draft Content)

Mask Input

An input mask is a string of characters that defines the format of input expected from the user. Masking an input reduces the chances of errors in data and helps maintain consistency in the database, making it easier to analyze and process data. You can create masks using user-generated rules consisting of patterns, placeholders, masking characters, etc.


SpreadJS provides a mask property and a pattern option to set the input mask. You can use the placeholder option to specify the placeholder. A placeholder is a string of characters that displays in the input field, represents the expected input format, and guides the user to provide input as per the format. If the user does not specify a placeholder, SpreadJS uses "_" by default. You can choose whether to display the placeholder character in the input string using the excludePlaceholder option.


For instance, if a mask pattern is "000000" and "_" is a placeholder, the blank input field displays "______" to indicate the required format of 6 digits. If the excludePlaceholder option is set to false (default) and the user inputs "1234", the input is saved as "1234____" after exiting edit mode. And when the option is true, the input is stored as "1234", that is, the placeholder is excluded.


Similarly, you can also exclude the literal characters by setting the excludeLiteral to true. Literals are characters that are displayed as it is at a specific position and cannot be replaced by any other character. Parentheses and hyphens used in phone numbers or a forward slash in date formats are a few examples.


The following code shows how to set an input mask:

    style = new GC.Spread.Sheets.Style();
    style.mask = {
        pattern: "[a0]{8}",
        excludePlaceholder: true
    };
    sheet.setStyle(14, 0, style);

    style1 = new GC.Spread.Sheets.Style();
    style1.mask = {
        pattern: "Au\\t\\hor: (Chris|Icey|Victor|Ian|Johnson|Ivan)",
        excludeLiteral: true
    };
    sheet.setStyle(15, 0, style1);

If a user inputs a character when the cursor is at placeholder, the new character replaces the placeholder character. In other cases, the new character is inserted. In case user input does not match the pattern, SpreadJS keeps the parts that match the pattern from left to right and drops the remaining invalid parts. However, when a user deletes some text, it deletes the current restriction content only. For instance, in the case of pattern ‘a{3}0{3}’, if a user starts deleting from the left most character of input, SpreadJS allows deletion of first three characters of the current restriction. To delete the remaining input, the user has to place the cursor in the beginning of the next restriction.


To confirm if a pattern is valid or not, SpreadJS provides a static method validatePattern. The following code shows how to use the validatePattern method to validate a pattern:

let sheet = spread.getActiveSheet();
let style = new GC.Spread.Sheets.Style();
let pattern = 'ISBN 0-00000-000-0';
let verifyResult = GC.Spread.Sheets.InputMask.validatePattern('[a0_]{8}');
if (verifyResult.success) {
  style.mask = {
    pattern: 'ISBN 0-00000-000-0'
  };
  sheet.setStyle(0,0,style);
}

Mask patterns are of two types:

  • String pattern

  • Date pattern

String Pattern

A string pattern is the simplest way of defining input format and is constructed using the minimum pattern unit. A minimum pattern unit consists of a character restriction and, optionally, a character length restriction. When character length restriction is not specified, it is considered to be one character. The following table defines various rules for creating patterns using these two types of restrictions.

Restriction type

Category

Pattern Character

Explanation

Sample Pattern

Display('_’ as placeholder)

Input

Output

Character length

Letters

a

Letter

aaa

___

abc

abc

>

Letter auto-converted to uppercase

>

_

a

A

><<<<

_____

chris

Chris

<

Letter auto-converted to lowercase

<

_

A

a

Numbers

0

Digit (0-9)

000

___

123

123

___

12

12_

Optional

()

Any of the strings in braces () should match.

0{1,3} (kg|lb)

_ kg

12 k

12kg

|

Delimiter between strings.

Used within braces().

Characters in braces() are static strings;

an escape character is not required inside braces.

Aut\\hor:(Chris|Icey|Victor|Ian)

or

(Author):(Chris|Icey|Victor|Ian)

Author:Chris

V

Author:Victor

[]

Combine the keywords and literals as a whole.

[>0]{5}

_____

a7osn

A7OSN

-

Indicates the character range.

Used within square braces[].

[\\a-f]

_

b

b

Special Char

\(should use “\\” when construct pattern string)

Escape Character

0\>0

_>_

32

3>2

#

Any Character

###

___

a1&

a1&

Character length restriction

Dynamic

{n}

"n" times repeat

0{4}/0{2}/0{2}

____/__/__

20230101

2023/01/01

{n,m}

Minimum "n" times and maximum "m" times repeat

0{1,3}.0{1,3}.0{1,3}.0{1,3}

_._._._

1270.0.1

127.0.0.1

[\\01]{0,}


1010

1010

{,m}

Upto "m" times repeat

0{,3}


123

123

{n,}

Minimum "n" times repeat

0{1,}.0{2}

_.__

1234.56

1234.56

In dynamic patterns:

  • The placeholder only represents the minimum length required. For example: 0{2,10} displays "__" and 0{0,1} displays nothing.

  • If "m" is not specified, dynamic patterns take maximum length of 2147483648.

Date Pattern

The date pattern is a way to specify the format of date and time values. It is a fixed format pattern and does not accept character length restrictions. In the case of a date pattern, SpreadJS automatically fixes the user input by the date rule. However, you must not repeat date time items such as yyyy, MM etc. in a single pattern. For example, "yyyy/MM/dd yyyy" is an invalid pattern because "yyyy" is used twice.


The following table describes various masking characters of the date pattern and their usage with the help of sample patterns.

Pattern Character

Description

Sample Pattern

Display '_' as placeholder

User Input

Output

y

Years

yy/MM/dd

__/__/__

23317

23/03/17

yyyy/MM/dd

____/__/__

2023317

2023/03/17

M

Months

yyyy/M/dd

____/_/__

2023317

2023/3/17

yyyy/MM/dd

____/__/__

2023317

2023/03/17

d

Days

yyyy/MM/d

____/__/_

202337

2023/03/7

yyyy/MM/dd

____/__/__

202337

2023/03/07

H

24 Hours

HH:mm:ss

__:__:__

2277

22:07:07

H:mm:ss

_:__:__

577

5:07:07

h

12 Hours

hh:mm:ss (am|pm)

__:__:__ am

277 p

02:07:07 pm

h:mm:ss (pm|am)

_:__:__ pm

277 a

2:07:07 am

m

Minutes

HH:mm:ss

__:__:__

2277

22:07:07

HH:m:ss

__:_:__

2277

22:7:07

s

Seconds

HH:mm:ss

__:__:__

2277

22:07:07

HH:mm:s

__:__:_

2277

22:07:7

t

Hour Format

hh:mm:ss t

__:__:__ A

2277p

22:07:07 P

hh:mm:ss tt

__:__:__ AM

2277p

22:07:07 PM

Named Pattern

You can also define named patterns and reuse them in other patterns. However, if there is a string in the pattern that matches any name in the namedPatterns, the mask replaces it with the named pattern. Hence, it is recommended to define patterns with names that have minimum chances of repetition. To get the list of all name patterns, SpreadJS provides a static method getNamedPatterns.

// define a named pattern
GC.Spread.Sheets.InputMask.namedPattern('enterdate', 'MM/dd/yyyy hh:mm tt');
let style = new GC.Spread.Sheets.Style();
style.mask = {
  // reuse it in another pattern
  pattern: '(start): enterdate'
};
sheet.setStyle(0, 0, style);

Formula Pattern

SpreadJS also supports formula patterns, that is, the patterns that are in the form of formula and start from "=". For example, if cell A1-A3 of a worksheet are names of the authors"Chris", "Icey", and "Ian", then the following two patterns give the same result.

Formula Pattern

Equivalent Pattern

'="Aut\\hor:("&TEXTJOIN("|",TRUE,A1:A3)&")"'

'Aut\\hor:(Chris|Icey|Ian)'

The static method validatePattern that confirms if a pattern is valid or not, does not support formula patterns. To evaluate formula patterns, use GC.Spread.Sheets.CalcEngine.evaluateFormula before calling the validatePattern method.

  • The characters in () pattern are a static string, so (am|pm) can be written as it is without using an escape character.

  • When a group restriction has only one group item, the mask treats it as a static string.

  • By default, the mask displays first item of the group restriction in input. On receiving user input, the mask automatically completes the group item text.

  • For better input experience, group restrictions are not case-sensitive.

  • For a static string or group text, SpreadJS does not support quantifiers. Hence, you must not set patterns like 1234{1,5}, (12|34){1,5} etc.

  • SpreadJS does not support nesting of group “()” and optional “[]”.

  • When a masked cell enters the edit mode, the internal formula textbox is prevented, and the external formula textbox is readonly.

  • A mask does not take effect when a formula cell enters edit mode.

  • After editing with a mask, if the editor value starts with “=”, “-”, “+”, quotePrefix is added automatically.

Example Patterns

The following table lists commonly used patterns for quick reference:

Case

Pattern or Options

Display

Input

Output

E-mail

[a0]{1,}@[a0]{1,}.(com|cn|gov|edu)

_@_.com

chris@grapecity.e

chris@grapecity.edu

Name

><{1,} ><{1,}

__ __

chris diao

Chris Diao

Long date

dd-MM-yyyy HH:mm

__-__-____ __:__

16720231620

16-07-2023 16:20

Short date

dd-MM-yyyy

__-__-____

1672023

16-07-2023

Verification code

[>0]{5}

_____

a7osn

A7OSN

Decimal number

[\-]{,1}0{0,}[.]{,1}0{0,}


-12.34

-12.34

12.34

12.34

Binary number

[\\01]{0,}


10101

10101

US phone number

[\\(]0{3}[\\)][-]0{3}[-]0{4}

(___)-___-____

1234567890

(123)-456-7890