03-10-2023, 10:30 PM
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.
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.