Converter, Multiline-String to Singleline-CSV-String<\/div>
Converts a multiline string to a CSV string. Converts each row of a multiline string as the value of each cell in the CSV. If commas are included they will be deleted in advance. Lines with only line feed code are recognized as empty data.<\/div><\/div>\n\n\n
<\/span>Configs<\/div>
\n
- \n
- <\/i><\/span> A1: Set Multiline Text *<\/span>#{EL}<\/sup><\/span><\/li>\n
- <\/i><\/span> B1: Select STRING DATA that stores Singleline CSV (update)<\/li>\n
- <\/i><\/span> B2: Select STRING DATA that stores Singleline CSV (append)<\/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 strMultilineText = configs.get( "StrConfA1" ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n if( strMultilineText === "" ){\n throw new Error( "\\n AutomatedTask ConfigError:" +\n " Config {A1: Text} is empty \\n" );\n }\nconst strPocketSinglelineCsv = configs.getObject( "SelectConfB1" ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\nconst strPocketMultilineCsv = configs.getObject( "SelectConfB2" ); \/\/\/ REQUIRED \/\/\/\/\/\/\/\/\/\n\n\n\/\/\/\/ == Data Retrieving \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u306e\u53c2\u7167 ==\nlet strTmp = "";\nif( strPocketMultilineCsv !== null ){ \/\/ Pocket defined\n if( engine.findData( strPocketMultilineCsv ) !== null ){ \/\/ Data exists\n strTmp = engine.findData( strPocketMultilineCsv );\n }\n}\n\n\n\/\/\/\/ == Calculating \/ \u6f14\u7b97 ==\n\n\/\/\/ Replace `,` to ""\nlet arrText = strMultilineText.replace(\/,\/g, '').split( "\\n" );\n\n\/\/\/ Append to Tmp\nif( strTmp === "" ){\n strTmp = arrText.join( "," );\n}else{\n strTmp = strTmp + "\\n" + arrText.join( "," );\n}\n\n\n\/\/\/\/ == Data Updating \/ \u30ef\u30fc\u30af\u30d5\u30ed\u30fc\u30c7\u30fc\u30bf\u3078\u306e\u4ee3\u5165 ==\nif( strPocketSinglelineCsv !== null ){\n engine.setData( strPocketSinglelineCsv, arrText.join( "," ) );\n}\nif( strPocketMultilineCsv !== null ){\n engine.setData( strPocketMultilineCsv, strTmp );\n}\n\n} \/\/\/\/\/\/\/\/ END "main()" \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\n\n\/*\nNotes:\n- When the process arrives, the Text stored in Multiline String data is automatically loaded.\n - Comma-separated values in each row are combined.\n - If the input text contains commas (`,`), they will be deleted in advance.\n- The CSV is output as "the simplest comma-separated string".\n - Double quote characters are also preserved unescaped.\n- The CSV output has an update mode and an append mode.\n - In the append mode, one CSV line is added.\n\n\nNotes-ja:\n- \u6848\u4ef6\uff08\u30d7\u30ed\u30bb\u30b9\uff09\u304c\u5230\u9054\u3057\u305f\u969b\u3001\u8907\u6570\u884c\u6587\u5b57\u5217\u578b\u30c7\u30fc\u30bf\u306b\u4fdd\u5b58\u3055\u308c\u3066\u3044\u308b\u30c6\u30ad\u30b9\u30c8\u304c\u8aad\u307f\u8fbc\u307e\u308c\u307e\u3059\u3002\n - \u5404\u884c\u306e\u5024\u3092\u30ab\u30f3\u30de\u533a\u5207\u308a\u3067\u7d50\u5408\u3055\u308c\u307e\u3059\u3002\n - \u5165\u529b\u30c6\u30ad\u30b9\u30c8\u5185\u306b\u30ab\u30f3\u30de\uff08`,`\uff09\u304c\u542b\u307e\u308c\u3066\u3044\u308b\u5834\u5408\u3001\u3042\u3089\u304b\u3058\u3081\u524a\u9664\u3055\u308c\u307e\u3059\u3002\n- \u51fa\u529b\u3055\u308c\u308bCSV\u306f\u300c\u3082\u3063\u3068\u3082\u30b7\u30f3\u30d7\u30eb\u306a\u30ab\u30f3\u30de\u533a\u5207\u308a\u6587\u5b57\u5217\u300d\u3068\u3057\u3066\u51fa\u529b\u3055\u308c\u307e\u3059\u3002\n - \u30c0\u30d6\u30eb\u30af\u30aa\u30fc\u30c8\u6587\u5b57\u3082\u3001\u30a8\u30b9\u30b1\u30fc\u30d7\u3055\u308c\u3066\u3044\u306a\u3044\u72b6\u614b\u3067\u4fdd\u6301\u3055\u308c\u307e\u3059\u3002\n- CSV\u51fa\u529b\u306f\u3001\u66f4\u65b0\u30e2\u30fc\u30c9\u3068\u8ffd\u8a18\u30e2\u30fc\u30c9\u304c\u3042\u308a\u307e\u3059\u3002\n - \u8ffd\u8a18\u30e2\u30fc\u30c9\u306e\u5834\u5408\u3001CSV\u884c\u304c\u4e00\u884c\u8ffd\u52a0\u3055\u308c\u307e\u3059\u3002\n\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
- converter-multiline-string-to-singleline-csv-string-2021.xml<\/a><\/li><\/ul>\n\n\n\n
2021-11-21 (C) Questetra, Inc. (MIT License)
https:\/\/support.questetra.com\/addons\/converter-multiline-string-to-singleline-csv-string-2021\/<\/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 arrives the text stored in multiline String data is automatically loaded.
- Comma-separated values in each row are combined.<\/li>
- If the input text contains commas they will be deleted in advance.<\/li><\/ul><\/li>
- The CSV is output as the simplest comma-separated string.
- Double quote characters are also preserved unescaped.<\/li><\/ul><\/li>
- The CSV output has an update mode and an append mode.
- In the append mode one CSV line is added.<\/li><\/ul><\/li><\/ul>\n\n\n\n
<\/i> Capture<\/h3>\n\n\n\n
![\"Converts](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/converter-multiline-string-to-singleline-csv-string-2021-capture-en.png?resize=1200%2C675&ssl=1\")
<\/a><\/figure>\n\n\n\n![\"Converts](\"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2021\/11\/converter-multiline-string-to-singleline-csv-string-2021-config-en-1024x616.png?resize=1024%2C616&ssl=1\")
<\/figure>\n\n\n\n<\/p>\n\n\n\n
<\/i> See also<\/h3>\n\n\n\n
- In the append mode one CSV line is added.<\/li><\/ul><\/li><\/ul>\n\n\n\n
- When the process arrives the text stored in multiline String data is automatically loaded.
- <\/i><\/span> B1: Select STRING DATA that stores Singleline CSV (update)<\/li>\n