Data types, column operations

This example shows how to define column types with the col_types option and specifically numeric formats with:

and date types with locale and format specified on a column basis.

Email Id Phone US $ Url EU Date US Date DD-MMM-YYYY Date IP
Tot
devo@flexomat.com 66672 941-964-8535
2.482,79
2,482.79
http://gmail.com 14/12/1988 12/14/1988 14-Dec-1988 186.114.137.213
henry@mountdev.net 35889 941-964-9543
2.776,09
2,776.09
http://www.gmail.com 19/1/1984 1/19/1984 19-Jan-1984 170.138.54.12
christian@reno.gov 60021 941-964-5617
2.743,41
2,743.41
http://www.dotnet.ca 25/3/2000 3/25/2000 25-Mar-2000 219.115.156.141
muffins@donuts.com 17927 941-964-9511
2.998,18
2,998.18
http://google.se 24/1/1993 1/24/1993 24-Jan-1993 252.253.244.189
muffins@reno.gov 76375 941-964-2757
1.836,09
1,836.09
http://www.samba.org 4/4/1988 4/4/1988 4-Apr-1988 88.233.9.89
mendez@gmail.com 45834 941-964-2575
2.805,46
2,805.46
http://flexomat.com 12/12/1985 12/12/1985 12-Dec-1985 88.233.9.89
dev@gmail.com 20022 941-964-4967
3.296,54
3,296.54
http://www.flexomat.com 3/7/2002 7/3/2002 3-Jul-2002 219.115.156.145
foo@polyester.se 55987 941-964-745
2.953,73
2,953.73
http://www.donuts.com 4/8/1987 8/4/1987 4-Aug-1987 88.233.9.87
adam@aftonbladet.se 38867 941-964-6302
1.949,27
1,949.27
http://flexomat.com 27/7/1995 7/27/1995 27-Jul-1995 170.138.54.16
devo@donuts.com 51426 941-964-1234
1.067,00
1,067.00
http://www.polyester.se 5/1/1986 1/5/1986 5-Jan-1986 252.253.244.186
henry@samba.org 40859 941-964-4856
3.401,19
3,401.19
http://www.flexomat.com 7/3/1990 3/7/1990 7-Mar-1990 88.233.9.85
found@dotnet.ca 23986 941-964-2686
1.393,52
1,393.52
http://lostnfound.org 22/7/1993 7/22/1993 22-Jul-1993 113.231.1.44
carl@fish.org 73392 941-964-5792
3.876,04
3,876.04
http://www.google.se 14/7/1984 7/14/1984 14-Jul-1984 219.115.156.137
found@mountdev.net 03519 941-964-1599
1.176,48
1,176.48
http://donuts.com 6/8/2000 8/6/2000 6-Aug-2000 88.233.9.86
lost@fish.org 36628 941-964-5985
822,23
822.23
http://www.gmail.com 14/7/1994 7/14/1994 14-Jul-1994 252.253.244.184
mendez@dotnet.ca 90442 941-964-1649
1.985,72
1,975.72
http://reno.gov 20/10/1997 10/20/1997 20-Oct-1997 113.231.1.79
carl@donuts.com 00412 941-964-6432
1.834,77
1,834.77
http://gmail.com 23/8/1997 8/23/1997 23-Aug-1997 170.138.54.19
foo@fish.org 80653 941-964-1022
260,26
260.26
http://samba.org 24/11/1991 11/24/1991 24-Nov-1991 88.233.9.89
found@fish.org 54635 941-964-6439
1.442,80
1,442.80
http://dotnet.ca 12/7/1987 7/12/1987 12-Jul-1987 88.233.9.90
found@flexomat.com 20953 941-964-5544
575,42
575.42
http://gmail.com 10/6/1988 6/10/1988 10-Jun-1988 88.233.19.89

Below an example of ISO date support ({yyyy|yy}/{MM}/{dd}). Use locale to set a locale globally (defaults to 'en').

Email Id Phone Total Url ISO Date
found@mountdev.net 03519 941-964-1599 $1176.48 http://donuts.com 2000/8/6
lost@fish.org 36628 941-964-5975 $822.23 http://www.gmail.com 1994/7/14
mendez@dotnet.ca 90442 941-964-1649 $1985.72 http://reno.gov 1997/10/20
carl@donuts.com 00412 941-964-6432 $1834.77 http://gmail.com 1998/8/23
foo@fish.org 80653 941-964-1022 $260.26 http://samba.org 1991/11/24
found@fish.org 54635 941-964-6439 $1442.80 http://dotnet.ca 1987/7/12
found@flexomat.com 20953 941-964-5544 $575.42 http://gmail.com 1988/6/10
lost@aftonbladet.se 60810 941-964-8406 $1054.39 http://www.samba.org 1988/5/18
carl@reno.gov 22666 941-964-104 $373.59 http://www.lostnfound.org 1981/11/5
carl@donuts.com 82867 941-964-1031 $631.03 http://www.reno.gov 1985/1/22
foo@donuts.com 11268 941-964-208 $3730.64 http://aftonbladet.se 1989/8/4
devo@google.se 17059 941-964-2903 $1404.67 http://www.gmail.com 1983/4/28
muffins@flexomat.com 90584 941-964-4640 $3706.01 http://www.fish.org 1997/4/8
foo@samba.org 82966 941-964-7245 $1001.38 http://www.reno.gov 1995/11/1
foo@reno.gov 03603 941-964-8942 $1677.07 http://www.flexomat.com 1980/7/31
found@flexomat.com 84939 941-964-7004 $3916.83 http://www.fish.org 1980/8/26
henry@lostnfound.org 76453 941-964-3084 $3875.88 http://www.fish.org 2000/10/22
sam@aftonbladet.se 36274 941-964-7784 $73.43 http://www.dn.se 1994/11/11
dev@polyester.se 15971 941-964-7527 $1855.18 http://www.flexomat.com 1984/8/16
devo@fish.org 31734 941-964-9760 $3201.35 http://www.samba.org 1989/3/4
devo@reno.gov 52074 941-964-2068 $3035.24 http://www.dn.se 1998/2/24
mendez@fish.org 87800 941-964-7933 $618.59 http://www.dn.se 1989/5/28
muffins@reno.gov 95926 941-964-147 $3897.91 http://www.flexomat.com 2003/4/1
carl@donuts.com 74513 941-964-4507 $2150.68 http://www.fish.org 1987/4/8
sam@fish.org 82420 941-964-2134 $3947.54 http://mountdev.net 1990/11/26
devo@mountdev.net 81905 941-964-3535 $722.17 http://fish.org 1985/12/28
john@lostnfound.org 93124 941-964-1508 $394.82 http://www.mountdev.net 1989/12/10
adam@google.se 51938 941-964-5533 $3519.06 http://dotnet.ca 1986/6/27
carl@lostnfound.org 51270 941-964-805 $2101.59 http://flexomat.com 1987/10/25
muffins@dotnet.ca 44995 941-964-8299 $1708.57 http://fish.org 1987/9/24
adam@samba.org 04065 941-964-8643 $1461.31 http://polyester.se 1993/9/13
carl@donuts.com 01801 941-964-1839 $2434.33 http://www.google.se 1987/7/8
muffins@mountdev.net 49570 941-964-877 $3273.22 http://polyester.se 2000/4/23
dev@google.se 31947 941-964-3956 $1647.20 http://www.dn.se 2006/9/25
christian@fish.org 05775 941-964-9882 $3203.96 http://flexomat.com 1981/5/3
henry@mountdev.net 18946 941-964-5204 $3281.09 http://www.lostnfound.org 1989/9/29
carl@mountdev.net 39096 941-964-5708 $1788.11 http://www.samba.org 1983/2/7
sam@dn.se 45043 941-964-7175 $1254.08 http://google.se 1981/3/30
henry@dotnet.ca 41456 941-964-4812 $1779.17 http://mountdev.net 1980/9/11
christian@polyester.se 78584 941-964-6967 $3956.45 http://www.reno.gov 1982/7/24
muffins@flexomat.com 56098 941-964-9399 $558.88 http://www.fish.org 1981/3/1
muffins@gmail.com 92303 941-964-1958 $1094.38 http://www.fish.org 1983/1/10
christian@mountdev.net 96564 941-964-3947 $3593.94 http://www.dn.se 2004/11/26
lost@polyester.se 53352 941-964-7300 $1548.49 http://www.mountdev.net 1989/7/22
adam@flexomat.com 17411 941-964-6808 $3744.57 http://www.lostnfound.org 1998/4/17
john@gmail.com 55140 941-964-5592 $641.84 http://www.dn.se 1989/12/15
foo@google.se 19355 941-964-5290 $3053.28 http://donuts.com 1987/6/25
dev@dn.se 38729 941-964-1565 $1539.30 http://www.flexomat.com 1989/3/13
mendez@dn.se 22531 941-964-4285 $18.39 http://google.se 1996/8/19
found@mountdev.net 03979 941-964-3119 $2961.55 http://www.dotnet.ca 2005/5/27
foo@reno.gov 59240 941-964-3593 $3039.37 http://www.lostnfound.org 2005/8/27
dev@polyester.se 53160 941-964-8179 $468.97 http://www.samba.org 1988/10/23
christian@reno.gov 96671 941-964-99 $994.56 http://gmail.com 1984/4/22
christian@gmail.com 60247 941-964-341 $1358.07 http://www.donuts.com 1987/11/20
lost@dotnet.ca 92437 941-964-6495 $3384.20 http://mountdev.net 1982/10/14
dev@flexomat.com 08314 941-964-5549 $223.00 http://flexomat.com 1985/12/6
henry@lostnfound.org 46306 941-964-8496 $3170.19 http://www.dotnet.ca 1986/7/7
foo@mountdev.net 07328 941-964-3503 $2486.92 http://www.dn.se 1999/7/24
lost@flexomat.com 66996 941-964-5705 $3333.71 http://www.aftonbladet.se 1989/1/17
henry@donuts.com 83394 941-964-3776 $1808.67 http://dn.se 1981/6/14
muffins@fish.org 76935 941-964-5150 $403.02 http://www.samba.org 1986/7/13