- \n
- <\/i><\/span> A: Set String *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> B: Select Thousands Separator *<\/span><\/li>\n
- <\/i><\/span> C: Select STRING DATA that stores Replaced String (update) *<\/span><\/li>\n<\/ul>\n<\/div><\/div>\n\n\n
<\/span>Script (click to open)<\/div>\n\n\n\n\/\/ GraalJS Script (engine type: 2)\n\n\/\/\/\/\/\/\/\/ START "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\nmain();\nfunction main(){ \n\n\/\/\/\/ == Config Retrieving \/ \u5de5\u7a0b\u30b3\u30f3\u30d5\u30a3\u30b0\u306e\u53c2\u7167 ==\nconst strInput = configs.get( "StrConfA" ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\n if( strInput === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {A: String} is empty \\n" );\n }\nconst strSeparator = configs.get( "SelectConfB" ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\n engine.log( " AutomatedTask Config: Separator: " + strSeparator );\nconst strPocketOutput = configs.getObject( "SelectConfC" ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\n\/\/ (Nothing. Retrieved via Expression Language in Config Retrieving)\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\nlet strOutput;\nif( strSeparator === "comma" ){\n strOutput = strInput.replace(\/(\\d)(?=(\\d{3})+(?!\\d))\/g, '$1,'); \/\/ supports zh ja\n \/\/ scripts consistently written without punctuation to separate words\n \/\/ strOutput = strInput.replace(\/\\B(?=(\\d{3})+(?!\\d))\/g, ','); \/\/ non-word boundary\n}else if( strSeparator === "dot" ){\n strOutput = strInput \/\/ 'dot' sign is used to separate decimal places in JavaScript\n .replace(\/(\\d)\\.(?=\\d)\/g, '$1,')\n .replace(\/(\\d)(?=(\\d{3})+(?!\\d))\/g, '$1.');\n}else if( strSeparator === "space" ){\n strOutput = strInput\n .replace(\/(\\d)\\.(?=\\d)\/g, '$1,')\n .replace(\/(\\d)(?=(\\d{3})+(?!\\d))\/g, '$1 ');\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nengine.setData( strPocketOutput, strOutput );\n\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\/*\nNotes:\n- When the process reaches this automated task, the string data will be converted.\n - Numeric characters with more than 4 digits (4 characters) will be replaced.\n - This would also apply to postal codes, phone numbers, and the year (2022).\n- For example, strings such as "Total Report" or "Summary TSV" will be easier to read.\n\n\nAPPENDIX:\nJavaScript Numeric literals A decimal point (".")\n- Input Sample: `$12345678.90`\n - Output: `$12,345,678.90`\n- Input Sample: "\u20ac12345.00`\n - Output: `\u20ac12,345.00`\n- Input Sample: `12345678.90123`\n - Output: `12,345,678.90,123` (not good)\n- Input Sample: `0120-345-678`\n - Output: `0,120-345-678` (not good)\n- Implementation of regular expression replacement (comma added)\n - Add digit separator `","`.\n - `.replace(\/(\\d)(?=(\\d{3})+(?!\\d))\/g, '$1,')`\n - Replace all "{number}" with "{number},".\n - But only if immediately followed by the pattern `(\\d{3})+(?!\\d)`\n - `(\\d{3})`: three numeric characters\n - `(?!\\d)`: non-numeric character\n- Implementation of regular expression replacement (period => comma)\n - Replace the decimal period (JavaScript literal) with a comma\n - `.replace(\/(\\d)\\.(?=\\d)\/g, '$1,')`\n - Replace all "{number}." will be replaced with "{number},".\n - But only if immediately followed by `\\d` (Lookahead assertion)\n - https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Guide\/Regular_Expressions\/Assertions\n\n\nNotes-ja:\n- \u6848\u4ef6\u304c\u3053\u306e\u81ea\u52d5\u51e6\u7406\u5de5\u7a0b\u306b\u5230\u9054\u3057\u305f\u969b\u3001\u6587\u5b57\u5217\uff08\u8907\u6570\u884c\/\u5358\u4e00\u884c\uff09\u3092\u81ea\u52d5\u7684\u306b\u5909\u63db\u3057\u307e\u3059\u3002\n - 4\u6841\u4ee5\u4e0a\uff084\u6587\u5b57\u4ee5\u4e0a\uff09\u306e\u6570\u5b57\u6587\u5b57\u5217\u304c\u7f6e\u63db\u3055\u308c\u307e\u3059\u3002\n - \u90f5\u4fbf\u756a\u53f7\u3001\u96fb\u8a71\u756a\u53f7\u3001\u897f\u66a6\uff082022\u5e74\uff09\u306a\u3069\u306b\u3082\u9069\u7528\u3055\u308c\u3066\u3057\u307e\u3044\u307e\u3059\u3002\n- \u305f\u3068\u3048\u3070\u3001\u81ea\u52d5\u751f\u6210\u3055\u308c\u305f\u300c\u5408\u8a08\u5024\u30ec\u30dd\u30fc\u30c8\u300d\u3084\u300c\u58f2\u4e0a\u96c6\u8a08TSV\u300d\u3092\u8aad\u307f\u3084\u3059\u304f\u3057\u307e\u3059\u3002\n\nAPPENDIX-ja:\n- \u30b5\u30f3\u30d7\u30eb\n - Input: `$12345678.90`\n - Output: `$12,345,678.90`\n - Input: "\u20ac12345.00`\n - Output: `\u20ac12,345.00`\n - Input: `12345678.90123`\n - Output: `12,345,678.90,123` (not good)\n - Input: `0120-345-678`\n - Output: `0,120-345-678` (not good)\n- \u6b63\u898f\u8868\u73fe\u306b\u3088\u308b\u7f6e\u63db\u306e\u5b9f\u88c5\uff08\u30ab\u30f3\u30de\u8ffd\u52a0\uff09\n - \u6841\u533a\u5207\u308a\u8a18\u53f7\u3014,\u3015\u3092\u8ffd\u52a0\n - `.replace(\/(\\d)(?=(\\d{3})+(?!\\d))\/g, '$1,')`\n - \u5168\u3066\u306e\u300e{\u6570\u5b57}\u300f\u3092\u300e{\u6570\u5b57},\u300f\u306b\u7f6e\u63db\u3057\u307e\u3059\u3002\n - \u305f\u3060\u3057\u3001\u305d\u306e\u76f4\u5f8c\u306b `(\\d{3})+(?!\\d)` \u306e\u30d1\u30bf\u30fc\u30f3\u304c\u7d9a\u304f\u5834\u5408\u306e\u307f\uff08\u5148\u8aad\u307f\u8a00\u660e\uff09\n - `(\\d{3})`: \u6570\u5b573\u6587\u5b57\n - `(?!\\d)`: \u6570\u5b57\u4ee5\u5916\u306e\u6587\u5b57\n- \u6b63\u898f\u8868\u73fe\u306b\u3088\u308b\u7f6e\u63db\u306e\u5b9f\u88c5\uff08\u30d4\u30ea\u30aa\u30c9\u21d2\u30ab\u30f3\u30de\uff09\n - \u5c0f\u6570\u70b9\u30d4\u30ea\u30aa\u30c9\u3014JavaScript \u30ea\u30c6\u30e9\u30eb\u3015\u3092\u30ab\u30f3\u30de\u306b\u7f6e\u63db\n - `.replace(\/(\\d)\\.(?=\\d)\/g, '$1,')`\n - \u5168\u3066\u306e\u300e{\u6570\u5b57}.\u300f\u3092\u300e{\u6570\u5b57},\u300f\u306b\u7f6e\u63db\u3057\u307e\u3059\u3002\n - \u305f\u3060\u3057\u3001\u305d\u306e\u76f4\u5f8c\u306b `\\d`\uff08\u6570\u5b57\uff09\u304c\u7d9a\u304f\u5834\u5408\u306e\u307f\uff08\u5148\u8aad\u307f\u8a00\u660e\uff0fLookahead assertion\uff09\n - https:\/\/developer.mozilla.org\/ja\/docs\/Web\/JavaScript\/Guide\/Regular_Expressions\/Assertions\n*\/\n\n<\/code><\/pre><\/div>\n\n\n<\/div><\/div>\n\n\n\n<\/a><\/figure><\/div>\n\n\n\n
<\/i> Download<\/h3>\n\n\n\n
- string-batch-add-thousands-separators-2022.xml<\/a><\/li><\/ul>\n\n\n\n
2022-01-16 (C) Questetra, Inc. (MIT License)
https:\/\/support.questetra.com\/addons\/string-batch-add-thousands-separators-2022\/<\/a>
<\/i> The Add-on import feature is available with Professional<\/strong><\/span> edition.
Freely modifiable JavaScript (ECMAScript) code. No warranty of any kind.<\/p>\n\n\n<\/div>\n\n\n\n<\/i> Notes<\/h3>\n\n\n\n
- When the process reaches this automated task, the string data will be automatically converted.
- Numeric characters with more than 4 digits will be replaced.<\/li>
- This will also apply to postal codes, phone numbers, and the year (2022).<\/li><\/ul><\/li>
- For example, it makes automatically generated total value reports and sales summary TSVs easier to read.<\/li><\/ul>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"Detects](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/01\/string-batch-add-thousands-separators-capture-en.png?resize=1200%2C675&ssl=1\")
<\/a><\/figure>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/01\/string-batch-add-thousands-separators-capture-select.png?resize=1200%2C675&ssl=1\")
<\/a><\/figure>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2022\/01\/string-batch-add-thousands-separators-config-en-1024x619.png?resize=1024%2C619&ssl=1\")
<\/a><\/figure>\n\n\n\n<\/i> Appendix<\/h3>\n\n\n\n
- Input Sample:
$12345678.90<\/code>- Output:
$12,345,678.90<\/code><\/li><\/ul><\/li>- Input Sample: “\u20ac12345.00`
- Output:
\u20ac12,345.00<\/code><\/li><\/ul><\/li>- Input Sample:
12345678.90123<\/code>- Output:
12,345,678.90,123<\/code> (not good)<\/li><\/ul><\/li>- Input Sample:
0120-345-678<\/code>- Output:
0,120-345-678<\/code> (not good)<\/li><\/ul><\/li>- Implementation of regular expression replacement (comma added)
- Add digit separator
\",\"<\/code>.<\/li>.replace(\/(\\d)(?=(\\d{3})+(?!\\d))\/g, '$1,')<\/code>- Replace all “{number}” with “{number},”.<\/li>
- But only if immediately followed by the pattern
(\\d{3})+(?!\\d)<\/code>(\\d{3})<\/code>: three numeric characters<\/li>(?!\\d)<\/code>: non-numeric character<\/li><\/ul><\/li><\/ul><\/li><\/ul><\/li>- Implementation of regular expression replacement (period => comma)
- Replace the decimal period (JavaScript literal) with a comma<\/li>
.replace(\/(\\d)\\.(?=\\d)\/g, '$1,')<\/code>- Replace all “{number}.” will be replaced with “{number},”.<\/li>
- But only if immediately followed by
\\d<\/code> (Lookahead assertion)<\/li><\/ul><\/li>- https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Guide\/Regular_Expressions\/Assertions<\/a><\/li><\/ul><\/li><\/ul>\n\n\n\n
<\/i> See also<\/h3>\n\n\n\n
- https:\/\/developer.mozilla.org\/en-US\/docs\/Web\/JavaScript\/Guide\/Regular_Expressions\/Assertions<\/a><\/li><\/ul><\/li><\/ul>\n\n\n\n
- Implementation of regular expression replacement (comma added)
- Input Sample:
- Input Sample:
- Input Sample: “\u20ac12345.00`
- Output:
- Input Sample:
- When the process reaches this automated task, the string data will be automatically converted.
- <\/i><\/span> B: Select Thousands Separator *<\/span><\/li>\n