• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
'|' as separator for value lists
#1
I work a lot with CSV import. Sometimes it makes sense to import a PDF via CSV import, edit and refine field values in MSP and export as CSV file again.
I described a workaround to use Generate Song List for CSV export long ago:
https://zubersoft.com/mobilesheets/forum...-5213.html

When doing that, one important feature is missing: when a field contains multiple values, which is often the case for composers or source types, a value list is exported where multiple values always are separated by a comma followed by a blank. For CSV import values in a value list have to be separated by |.
Search and replace in the exported file needs a lot of attention as e.g. for composers comma is frequently used as part of a single composer entry.

It would be great if I could choose between ', ' and '|' as value list separator when configuring a song list format.

Or, even better, if there existed a specific Song List Format for CSV export. This should use
| as separator for fields with multiple values, allow choosing tab or semicolon as field separator and include the column headers in the file.
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply


Messages In This Thread
'|' as separator for value lists - by itsme - 03-10-2023, 10:30 PM
RE: '|' as separator for value lists - by itsme - 08-19-2023, 04:40 PM



Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2024 MyBB Group.