• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
'|' as separator for value lists
#3
No, I cannot control that.
The song title format allows specifying the separator between fields, but not the separator between list entries.

e.g. a song with several composers:
The CSV file
Title;AlternativTitel;PDFPage;Pages;SourceTypes;Keys;Years;Composers;Tempos;Signatures;Albums
Achin' Hearted Blues;;331;331-332;LS|2 S.|Tx;Eb;;Clarence Williams|Clarence Johnson|Spencer Williams;;4/4;CJB Fakebook 2023
also works with tabs between the fields and creates three composer entries in the MobileSheets database as expected.

Exporting with this setlist format

%TITLE%;%CUSTOM_GROUPS%;%KEYS%;%PAGE_ORDER%;%FILE_NAMES%;%SOURCE_TYPES%;%FILE_PATHS%;%COMPOSERS%;%GENRES%;%YEARS%;%SIGNATURES%;%TEMPOS%

creates this

CJB Fakebook 2023 Sample

Achin' Hearted Blues;;Eb;331-332;_CJB_Fakebook_2023_C.pdf;2 S., LS, Tx;D:\HerbertsGoogleDrive\_MobileSheets\Fkbk0\CJB_Fakebook_2023\_CJB_Fakebook_2023_C.pdf;Clarence Johnson, Clarence Williams, Spencer Williams;;;4/4;

Simply copying the setlist format into the file should create a valid CSV file for import. But re-importing that creates one composer entry, not three.
The commas between the composers for the export as well as the | for CSV import seem to be hardcoded. Using search&replace or a script to replace comma with | is not possible because composers often are specified as
Williams, Clarence|Johnson, Clarence|Williams, Spencer;
to get them sorted by lastname.
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.