{"id":31493,"date":"2006-04-18T10:00:11","date_gmt":"2006-04-18T10:00:11","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/oldnewthing\/2006\/04\/18\/how-to-fill-in-that-number-grouping-member-of-numberfmt\/"},"modified":"2006-04-18T10:00:11","modified_gmt":"2006-04-18T10:00:11","slug":"how-to-fill-in-that-number-grouping-member-of-numberfmt","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/oldnewthing\/20060418-11\/?p=31493","title":{"rendered":"How to fill in that number grouping member of NUMBERFMT"},"content":{"rendered":"

If you look at the NUMBERFMT<\/code> structure, the way groups are expressed by the Grouping<\/code> member do not match the value returned by LOCALE_SGROUPING<\/code>:<\/p>\n\n\n\n\n\n
LOCALE_
SGROUPING<\/th>\n		Grouping<\/th>\nSample<\/th>\nCulture<\/th>\n<\/tr>\n
3;0<\/td>\n3<\/td>\n1,234,567<\/td>\nUnited States<\/td>\n<\/tr>\n
3;2;0<\/td>\n32<\/td>\n12,34,567<\/td>\nIndia<\/td>\n<\/tr>\n
3<\/td>\n30<\/td>\n1234,567<\/td>\n(none I know of)<\/td>\n<\/tr>\n<\/table>\n

LOCALE_SGROUPING<\/code> expresses grouping as a series of semicolon-separated numbers, each expressing the number of digits in each group (least-significant group first). A trailing zero indicates that the last grouping should be repeated indefinitely. For example, “3;2;0” means “Group the three least significant digits, then in twos until you run out of digits.” If there is no trailing “;0”, then there are no commas past that point. For example, “3” means “Group the three least significant digits, then stop.”\n The Grouping<\/code> member expresses the grouping rules differently. Each significant digit represents a group, with the most significant digit representing the least-significant group, with the units digit repeated indefinitely. For example, “32” means “make a group of three digits, then group by twos thereafter.” To suppress the repetition, multiply by ten.\n In other words, the two systems are basically the same, with the Grouping<\/code> consisting of the LOCALE_SGROUPING<\/code> string with the semicolons removed. Except that the meaning of the trailing zero is reversed, so if LOCALE_SGROUPING<\/code> has a trailing zero, you have to remove it to get the Grouping<\/code>, and if it lacks a trailing zero, then you have to add one to the Grouping<\/code>.\n It’s kind of strange that the two systems differ, considering that they both came from the same NLS team! It’s probably a case of parallel evolution, wherein the locale-string folks and the number-formatting folks came up with their respective systems independently.\n Writing code to implement this conversion from LOCALE_SGROUPING<\/code> to Grouping<\/code> shouldn’t be hard once you understand the algorithm, so I’ll leave that as an exercise.<\/p>\n

Fortunately, in real life you rarely have need to perform this conversion, for you can just pass the desired locale as the first parameter to the GetNumberFormat<\/code> (or even better, LOCALE_USER_DEFAULT<\/code>), pass a NULL<\/code> pointer as the lpNumberFormat<\/code>, and let NLS do all the work. <\/p>\n","protected":false},"excerpt":{"rendered":"

If you look at the NUMBERFMT structure, the way groups are expressed by the Grouping member do not match the value returned by LOCALE_SGROUPING: LOCALE_SGROUPING Grouping Sample Culture 3;0 3 1,234,567 United States 3;2;0 32 12,34,567 India 3 30 1234,567 (none I know of) LOCALE_SGROUPING expresses grouping as a series of semicolon-separated numbers, each expressing […]<\/p>\n","protected":false},"author":1069,"featured_media":111744,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[25],"class_list":["post-31493","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oldnewthing","tag-code"],"acf":[],"blog_post_summary":"

If you look at the NUMBERFMT structure, the way groups are expressed by the Grouping member do not match the value returned by LOCALE_SGROUPING: LOCALE_SGROUPING Grouping Sample Culture 3;0 3 1,234,567 United States 3;2;0 32 12,34,567 India 3 30 1234,567 (none I know of) LOCALE_SGROUPING expresses grouping as a series of semicolon-separated numbers, each expressing […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/posts\/31493","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/users\/1069"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/comments?post=31493"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/posts\/31493\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/media\/111744"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/media?parent=31493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/categories?post=31493"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/oldnewthing\/wp-json\/wp\/v2\/tags?post=31493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}