INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Ignoring articles in an expression  (Read 536 times)

stubbo

  • Recent member
  • *
  • Posts: 44
Ignoring articles in an expression
« on: May 10, 2018, 06:41:01 am »

Can you specify to ignore articles in an expression?

I have panes set up where I am want to group artists by their initial....so....

mid([Album Artist],0)

But this does not strip the article from the artist name, so although all my bulk lists ignore the articles when sorting I can't exclude them in the expression when I calculate my own values.

Is there an expression that could do this...for example, something like.....

mid(ignoreArticles([Album Artist]),0)

That would solve a lot of problems for me.

Or is there a new initial mechanism that does the job?
Logged

stubbo

  • Recent member
  • *
  • Posts: 44
Re: Ignoring articles in an expression
« Reply #1 on: May 10, 2018, 06:45:02 am »

Never mind...found it ....

mid(NoArticles([Album Artist]),0)

That did the job! I knew you wouldn't have missed that out!
Logged
Pages: [1]   Go Up