Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[FenceFurniture]

Referring to the attached screenshot, the bottom 8 lines had no entries for Soloists or Instrument, so I selected them along with the line above them (4th line down), pressed F2 to edit the 4th line and pressed enter as I usually do. These are of course protected fields where no changes to the data type can be made, "List (semicolon delimited), Not Relational, Edit type "List"

What has happened is the the spaces after the ";" have no disappeared, and I much prefer them to be there for clarity. This has happened numerous times today - is it because of a recent update? I have manually entered the spaces, but they get deleted upon pressing enter.

[EnglishTiger]

Can't remember which version of MC26 it was introduced in but MC now removes spaces from all ; delimited fields/tags however we have been promised that in a "future version" those ; delimited fields will have spaces added to them for legibility/readability purposes when presented "on screen".

[marko]

In the meantime, if you can't wait, an expression column using this expression will insert the spaces you desire:

Replace([soloists,0],;,;/ )

For files still showing spaces in the soloists field, an 'update library from tags' will remove those spaces, bringing uniformity to the field.

[lepa]

In the meantime, if you can't wait, an expression column using this expression will insert the spaces you desire:

Replace([soloists,0],;,;/ )

For files still showing spaces in the soloists field, an 'update library from tags' will remove those spaces, bringing uniformity to the field.

Maybe it is better to use

Code: [Select]

ListFormat([Soloist],0)https://wiki.jriver.com/index.php/List_Manipulation_Functions#ListFormat

If there are spaces left in data Replace would add space also for "; " and make it ";  ". ListFormat shows both cases correctly

[marko]

Indeed. Good thinking.
My OCD was off the chart with this, and, some of my base expressions were breaking, so I ran an update from tags over everything to restore conformity.

You have to be sure that library and tags are in sync before doing this though, otherwise any old out of date info in the file tags will replace the current library info, and you wouldn't want that, for sure

[FenceFurniture]

Thank you for your responses.

You have to be sure that library and tags are in sync before doing this though, otherwise any old out of date info in the file tags will replace the current library info, and you wouldn't want that, for sure

I only just very recently did an update of the tags from library (2 weeks ago?), after some heavy duty changes were made, and have done little work since then, until today. However, anything I have done today (a fair bit) will have already updated the tags I think - they are set to "store the data in the tags if possible".

[MusicBringer]

MC now removes spaces

Maybe it is better to use

Code: [Select]

ListFormat([Soloist],0)

@lepa, that is wonderful. Thank you soo much. That new-fangled display IS impossible to read. 👴

[FenceFurniture]

Yes, the listformat brings it back to what it was....so I got to thinking....

What about combining Marko's Replace and Listformat because even "; " makes for a pretty clunky looking list to read. I'm a fan of En and Em spaces and dashes. Dashes can be typed using Alt, but spaces have to be copied from something like Excel.

En dash – is Alt 0150
Em dash — is Alt 0151
A normal space is between the two colons here : :
En space is like a double space between the two colons here : :
Em space is like a triple space between the two colons here : :
(and you can copy those En and Em spaces from there, btw)

So, my expression became
Replace(ListFormat([Soloists],0),; ,; ) and that's with an Em space just before the closing ")"

However, super-annoyingly, the Em space (or any other trailing space) is truncated, which took it right back to square one of my original post.
The only way I can get the Em space to show is by putting something after it, like a 1, which just looks ridiculous. Hmmpf!
Nor can I lead with a space (to eliminate the ; altogether).

Using The Tokyo String Quartet as an example:
Kikuei Ikeda;Martin Beaver;Kazuhide Isomura;Clive Greensmith  is how MC wants to display it
Kikuei Ikeda; Martin Beaver; Kazuhide Isomura; Clive Greensmith  is how lepa's Listformat displays it
Kikuei Ikeda; Martin Beaver; Kazuhide Isomura; Clive Greensmith  is how I want to display it
or even better (with commas)
Kikuei Ikeda, Martin Beaver, Kazuhide Isomura, Clive Greensmith  
or just Em spaced out (a bit like me....)
Kikuei Ikeda Martin Beaver Kazuhide Isomura Clive Greensmith  this actually looks the best I think

Any of the last 3 options are much more readable, IMO, but how to achieve it? Seems to me that commas can't be put in place of semi-colons, and the leading and trailing spaces get truncated.

Even with Em dashes looks better than semi-colon space "; "
Kikuei Ikeda—Martin Beaver—Kazuhide Isomura—Clive Greensmith  
or a Horizontal Elipsis … (Alt 0133)
Kikuei Ikeda…Martin Beaver…Kazuhide Isomura…Clive Greensmith  (looks a bit ordinary)

Any thoughts? Can a leading and/or trailing space be achieved?

[FenceFurniture]

AHA! Got it.

Replace(ListFormat([Soloists],0),; ,/ / )
there's an Em space between the //

[FenceFurniture]

And fleshing that out to the different formats I will use for a couple of different panes:

[JimH]

Spaces after semi-colon should re-appear in the next build available.

[marko]

Well they still be saved without spaces, but displayed with spaces, or are we rolling back to saving all with spaces again?

[Hendrik]

Only display is changing.

[marko]

That's a relief. Thanks for confirming Hendrik.

[Matt]

Hi everyone.

I just wanted to bring this to the top in case anyone thinks we have more work to do.

The history was that we originally switched to not storing spaces around the delimiter.  Then we made it so we still show spaces even though they're not stored.

If there's more to do, please let us know.  Thanks.

[EnglishTiger]

The spaces are not being added to ;Delimited List Fields/Tags when they are used in the Player and the Status Bar

[Matt]

The spaces are not being added to ;Delimited List Fields/Tags when they are used in the Player and the Status Bar

No, only the lists format them with extra spaces.

[JimH]

The spaces are not being added to ;Delimited List Fields/Tags when they are used in the Player and the Status Bar

How about posting a screenshot?

[MusicBringer]

Replace(ListFormat([Soloists],0),; ,/ / )
there's an Em space between the //

Only just seen this.
I am now using it for my field I call - Involved People
It tells me Who plays What.
Much neater.
thanks,