Print

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

[SkGe]

Ok. I'm trying to find a way to get work with an expression for some of my custom field but i can't find a better solution so i came here for some help.
My custom field is a delimited list with different value, ex:
Name1 [01]; Name02 [02]; Name3 [03]; Name04 [04]; etc. Where name is different information and the digit is a value. What do i want my expression to show me is just only the value from each ex to be extrated.
Expression to shown is like these.
Ex1 get the first value. 01 (hide the name01 and []);
Ex2 get the second value: 02 (same as ex1);
Ex3, ex4 and so on get the next value.
The number of information on the field can vary so is not a fix number. Can be from 1 value from n value.
So far what method i know and try is useless. Maybe someone knew a better way to solve and can try to help.
Thanks in advice.

[blgentry]

So do you want several expressions:  One expression to give you the numeric value of the first list element?  Then another to give you the numeric value of the second element?  Etc..

Or do you want one expression that returns a LIST with the numeric values of all of the list elements?

Maybe give an example of a real field that you are using, and then the output of the expression, or multiple expressions that you want.

Brian.

[fridden]

Perhaps this might be what you are looking for?

=RegEx(ListItem([MyCustomField],2),/#\[([^]]+)\]#/,1)

This will retrieve the 2nd item and parse out the text between [ and ]

So the expression will first pick out the nth item from the list with the expression:
ListItem([MyCustomField], n)

Then it will use Regex to parse out the text between brackets from that item.

Hope this helps!

/fridden

[SkGe]

Just one expression who had the possibilities to pull that information from the field.
Lets say i have these information in the field
The 405 [90]
AV Club [91]
Drowned in Sound [90]
Entertainment Weekly [91]
Northern Transmissions [100]
Paste [91]
The Guardian [100]
The Skinny [100]
Pretty Much Amazing [100]
NME [100]

[RoderickGI]

So if you answered Brian's question specifically..

You have a field with the contents:
The 405 [90]; AV Club [91]; Drowned in Sound [90]; Entertainment Weekly [91]; Northern Transmissions [100]; Paste [91]; The Guardian [100]; The Skinny [100]; Pretty Much Amazing [100]; NME [100]

And you want the output to be:
90; 91; 90; 91; 100; 91; 100; 100; 100; 100

Is that correct?

[SkGe]

That is the thing i want to get.
I did try the formula of fridden and format like these:
removeright(right(ListItem([custom field], 0),3),1) and it show me only the digit. But the problem is, when i do that, these expression will select each value as first, second and so on.
Here is an example of implementation

[RoderickGI]

Ah, your data is a rating from various sources, all in one list type field, and you want to break them out to make use of them.

Could you just confirm, do you want the results (all the numbers) in one List type field as per my example? Or do you want one number in each of a series of fields, as per your image?

I would bet that Brian (not me!) could write an Expression to not only pull out the numbers for you, but also save them into the correct MC field. i.e. Read both the source of the rating and the number, then write the number to the corresponding MC field. That would mean that you need a custom field for every source though, plus a catch-all field for unknown sources. But that just adds to the challenge, right? 

So rather than splitting the numbers out into "First Value", "Second Value". etc., write them out to the correct field as per the source.


However, that seems like a fair bit of work and processing. It may slow down MC Views quite a bit. Perhaps you should explain how you get the contents of the "AllMusic" field, which contains ratings from various source, and what your end goal is. For example, do you want to calculate an average rating across known sources, or do you really want one field per source? Are you going to apply these results to a View to select music to play?

Because there may be a better to achieve the end goal.