Define Pingtree’s field mapping data transformer and various use-cases.
home_type
) appears on the left; the target field (e.g., homeType
) is on the right.Transformed Value Result | Date Format in Enter Custom Value |
---|---|
2021 | YYYY |
202108 | YYYYMM |
2021-08 | YYYY-MM |
8/5 | M/D |
08/05 | MM/DD |
20210805 | YYYYMMDD |
2021-08-05 | YYYY-MM-DD |
2021_08_05 | YYYY_MM_DD |
2021.08.05 | YYYY.MM.DD |
8/5/21 | M/D/YY |
08/05/21 | MM/DD/YY |
08/05/2021 | MM/DD/YYYY |
05 Aug 21 | DD MMM YY |
05 Aug 2021 | DD MMM YYYY |
05 August 2021 | DD MMMM YYYY |
Aug 5, 21 | MMM D, YY |
Aug 5, 2021 | MMM D, YYYY |
Aug 05, 2021 | MMM DD, YYYY |
August 5, 2021 | MMMM D, YYYY |
August 05, 2021 | MMMM DD, YYYY |
202108051315 | YYYYMMDDHHmm |
20210805_1315 | YYYYMMDD_HHmm |
2021.08.05.1315 | YYYY.MM.DD.HHmm |
2021-08-05-1315 | YYYY-MM-DD-HHmm |
2021-08-05_1315 | YYYY-MM-DD_HHmm |
2021.08.05.13.15 | YYYY.MM.DD.HH.mm |
2021-08-05-13-15 | YYYY-MM-DD-HH-mm |
2021-08-05 13:15 | YYYY-MM-DD HH:mm |
2021-08-05 1:15 PM | YYYY-MM-DD h:mm A |
2021-08-05 01:15 PM | YYYY-MM-DD hh:mm A |
2021-08-05 @ 1:15 PM | YYYY-MM-DD @ h:mm A |
20210805131504 | YYYYMMDDHHmmss |
2021.08.05.131504 | YYYY.MM.DD.HHmmss |
2021-08-05-131504 | YYYY-MM-DD-HHmmss |
2021-08-05_131504 | YYYY-MM-DD_HHmmss |
2021-08-05_1315.04 | YYYY-MM-DD_HHmm.ss |
2021.08.05.13.15.04 | YYYY.MM.DD.HH.mm.ss |
2021-08-05-13-15-04 | YYYY-MM-DD-HH-mm-ss |
2021-08-05 13:15:04 | YYYY-MM-DD HH:mm:ss |
2021-08-05 13:15.04 | YYYY-MM-DD HH:mm.ss |
2021-08-05 1:15:04 PM | YYYY-MM-DD h:mm:ss A |
2021-08-05 01:15:04 PM | YYYY-MM-DD hh:mm:ss A |
2021-08-05 @ 1:15:04 PM | YYYY-MM-DD @ h:mm:ss A |
We Aug 5 21 | dd MMM D YY |
Wed Aug 5 21 | ddd MMM D YY |
Wed Aug 5 2021 | ddd MMM D YYYY |
Wed Aug 05 2021 | ddd MMM DD YYYY |
Wednesday, Aug 5 2021 | dddd, MMM D YYYY |
Wednesday, August 5, 2021 | dddd, MMMM D, YYYY |
Wednesday, August 05, 2021 | dddd, MMMM DD, YYYY |
1:15 PM | h:mm A |
01:15 PM | hh:mm A |
@ 1:15 PM | @ h:mm A |
Wed Aug 5 21 1:15 PM | ddd MMM D YY h:mm A |
Wed Aug 5 2021 1:15 PM | ddd MMM D YYYY h:mm A |
Wed Aug 05 2021 1:15 PM | ddd MMM DD YYYY h:mm A |
Wednesday, Aug 5 2021 1:15 PM | dddd, MMM D YYYY h:mm A |
Wednesday, August 5, 2021 1:15 PM | dddd, MMMM D, YYYY h:mm A |
Wednesday, August 05, 2021 1:15 PM | dddd, MMMM DD, YYYY h:mm A |
Wed Aug 5 21 01:15 PM | ddd MMM D YY hh:mm A |
Wed Aug 5 2021 01:15 PM | ddd MMM D YYYY hh:mm A |
Wed Aug 05 2021 01:15 PM | ddd MMM DD YYYY hh:mm A |
Wednesday, Aug 5 2021 01:15 PM | dddd, MMM D YYYY hh:mm A |
Wednesday, August 5, 2021 01:15 PM | dddd, MMMM D, YYYY hh:mm A |
Wednesday, August 05, 2021 01:15 PM | dddd, MMMM DD, YYYY hh:mm A |
Wed Aug 5 21 @ 1:15 PM | ddd MMM D YY @ h:mm A |
Wed Aug 5 2021 @ 1:15 PM | ddd MMM D YYYY @ h:mm A |
Wed Aug 05 2021 @ 1:15 PM | ddd MMM DD YYYY @ h:mm A |
Wednesday, Aug 5 2021 @ 1:15 PM | dddd, MMM D YYYY @ h:mm A |