DATA TYPES |
FORMAT OPTIONS |
SUB-OPTIONS |
Text |
- |
- |
Number |
Thousands separator |
None, Comma (,), Dot (.) |
Decimal |
Thousands separator |
None, Comma (,), Dot (.) |
Decimal separator |
Comma (,), Dot (.) |
|
Time |
Time format |
|
Date |
Date format |
|
Date time |
Date time format |
|
Timestamp |
- |
- |
Currency |
Thousands separator |
None, Comma (,), Dot (.) |
Decimal separator |
Comma (,), Dot (.) |
|
Select unit |
Click here to know the units supported for currency datatype. |
|
Length |
Thousands separator |
None, Comma (,), Dot (.) |
Decimal separator |
Comma (,), Dot (.) |
|
Temperature |
Thousands separator |
None, Comma (,), Dot (.) |
Decimal separator |
Comma (,), Dot (.) |
|
Boolean |
- |
- |
|
- |
- |
URL |
- |
- |
List |
- |
- |
Map |
- |
- |
Duration |
Duration format |
|
Positive number |
- |
- |
Percentage |
- |
- |
Data type |
Option |
Sub-options |
Text |
Wildcard |
Contains |
|
|
Doesn't contain |
|
|
Starts with |
|
|
Doesn't start with |
|
|
Ends with |
|
|
Doesn't end with |
|
|
In |
|
|
Not in |
|
|
Is |
|
|
Is not |
|
|
Patterns |
|
|
Regex |
|
String length comparators |
Length greater than(>) |
|
|
Length greater than or equal to(>=) |
|
|
Length equal to(=) |
|
|
Length not equal to() |
|
|
Length lesser than(<) |
|
|
Length less than or equal to(<=) |
|
|
Length range |
|
String length values |
In |
|
|
Not in |
Number |
Comparators |
Greater than(>) |
|
|
Greater than or equal to(>=) |
|
|
Equal to(=) |
|
|
Not equal to() |
|
|
Less than(<) |
|
|
Less than or equal to(<=) |
|
|
Range |
|
Individual values |
In |
|
|
Not in |
Decimal |
Comparators |
Greater than(>) |
|
|
Greater than or equal to(>=) |
|
|
Equal to(=) |
|
|
Not equal to |
|
|
Less than(<) |
|
|
Less than or equal to(<=) |
|
|
Range |
|
Individual values |
In |
|
|
Not in |
|
Precision |
NA |
Date, Date time |
Quarter |
Q1, Q2, Q3, Q4 |
|
Month |
January to December |
|
Week |
Week 1 to Week 53 |
|
Date
|
NA
|
|
Date & time |
NA |
|
Hours |
0 to 23 |
|
Day of the week |
Sunday to Saturday |
|
Day of the month |
1 to 31 |
|
Period(AM/PM) |
AM, PM |
|
Range |
NA |
Date and Datetime delimiters
|
/ : - , . \s T Z
|
Time delimiters
|
/ : - , . \s Z
|
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Write to us: support@zohoforms.com