Not logged in.  Login/Logout/Register | List snippets | | Create snippet | Upload image | Upload data

5
LINES

< > BotCompany Repo | #1029693 // formatCSVFileForExcel2 [dev.]

JavaX fragment (include) [tags: use-pretranspiled]

Libraryless. Click here for Pure Java version (2609L/16K).

sS formatCSVFileForExcel2(L<L> rows) {
  S sep = "|"; // multi-character separator doesn't work with Excel
  ret windowsLineBreaks("sep=" + sep + "\n" + mapToLines_rtrim(rows, row -> join(sep, map(row, col
    -> replace(newLinesToSpaces(str(col)), sep, " ")))));
}

Author comment

Began life as a copy of #1029692

download  show line numbers  debug dex  old transpilations   

Travelled to 6 computer(s): bhatertpkbcr, mqqgnosmbjvj, pyentgdyhuwx, pzhvpgtvlbxg, tvejysmllsmz, vouqrxazstgt

No comments. add comment

Snippet ID: #1029693
Snippet name: formatCSVFileForExcel2 [dev.]
Eternal ID of this version: #1029693/3
Text MD5: 07c3a3b117b72a86f17cc600a1ae33d8
Transpilation MD5: d5c5fe42618f8bee4eccb82c29f7707c
Author: stefan
Category: javax
Type: JavaX fragment (include)
Public (visible to everyone): Yes
Archived (hidden from active list): No
Created/modified: 2020-09-07 15:12:03
Source code size: 269 bytes / 5 lines
Pitched / IR pitched: No / No
Views / Downloads: 95 / 155
Version history: 2 change(s)
Referenced in: [show references]