Splitting of articles by article ids: Difference between revisions
Jump to navigation
Jump to search
m
Splitting of articles by article ids (edit)
Revision as of 10:59, 13 December 2023
, 13 December 2023no edit summary
No edit summary |
mNo edit summary |
||
| Line 15: | Line 15: | ||
== Case2: Articles IDs which mix of string and number == | == Case2: Articles IDs which mix of string and number == | ||
If the article ID consists of numbers or text, it is divided into two parts after a formula calculation with the remainder equal to 0 or 1, resulting in two parts of different quantities. | If the article ID consists of numbers or text e.g. [https://en.wikipedia.org/wiki/Amazon_Standard_Identification_Number Amazon Standard Identification Number], it is divided into two parts after a formula calculation with the remainder equal to 0 or 1, resulting in two parts of different quantities. | ||
CONV(HEX(article_id), 16, 10) converts HEX(article_id) from hexadecimal (base 16) to decimal (base 10). Then, MOD(CONV(HEX(article_id), 16, 10), 2) computes the remainder when the converted decimal number is divided by 2. | CONV(HEX(article_id), 16, 10) converts HEX(article_id) from hexadecimal (base 16) to decimal (base 10). Then, MOD(CONV(HEX(article_id), 16, 10), 2) computes the remainder when the converted decimal number is divided by 2. | ||