m+ and w+ column prefixes in CSV Data Type

Chris Anderson asked on August 9, 2019

Hi, 
We’re using your doc here: https://www.flexmonster.com/doc/data-types-in-csv/
We’re developing a configurable UI for end users to choose their own prefix to manage their data. When we add w+ and m+ to a date field we were expecting it to display just the day of the month or just the month respectively. Is this correct?
When we use D+, D4+, etc we get the hierarchy correctly, so the prefixes are working.
If our assumption of functionality above is not correct, what exactly do w+ and m+ do please?
Thanks in advance

2 answers

Public
Ian Sadovy Flexmonster August 9, 2019

Hello Chris,
 
Thank you for writing to us.
 
The m+ prefix specifies that the field is a month. This prefix is used for fields containing string values, for example, “January”, “February”, etc.
The w+ prefix specifies that the field is a day of the week. This prefix is used for fields containing string values, for example, “Monday”, “Tuesday”, etc.

m+Month,w+Weekday
January,Tuesday
February,Thursday
January,Monday
...

These prefixes help to sort weekdays and months correctly.
 
Please let us know if this helps.
 
Best Regards,
Ian

Public
Chris Anderson August 9, 2019

Thanks Ian

Please login or Register to Submit Answer