INTERACT FORUM

Please login or register.

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

Author Topic: What expression extracts GTIN/EAN/UPC from Album title?  (Read 5136 times)

chrisjj

  • Citizen of the Universe
  • *****
  • Posts: 750
What expression extracts GTIN/EAN/UPC from Album title?
« on: May 24, 2011, 06:37:46 am »

Is there an expert who can tell me an expression to extract GTIN/EAN/UPC from Album title? e.g.

Album: Bailando tangos, valses y milongas [00724359515922]
GTIN/EAN/UPC: 00724359515922

Thanks.
Logged

mark_h

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1854
Re: What expression extracts GTIN/EAN/UPC from Album title?
« Reply #1 on: May 24, 2011, 07:36:45 am »

=listitem([album],1,/[)

Should give you the data along with a trailing ] which could be cleaned up.

=replace(listitem([name],1,/,),/[,)

Haven't tried it though...
Logged

chrisjj

  • Citizen of the Universe
  • *****
  • Posts: 750
Re: What expression extracts GTIN/EAN/UPC from Album title?
« Reply #2 on: May 24, 2011, 08:38:37 am »

=replace(listitem([name],1,/,),/[,)
Thanks Mark.

Amended to replace(listitem([Album],1,/[,),/],) it succeeds... except where there's e.g. [Disc 1 of 2] or anything after the GTIN/EAN/UPC.

I'd like a specific match. Does MC support any kind of regexp in expressions?

Logged

Vincent Kars

  • Citizen of the Universe
  • *****
  • Posts: 1154
Re: What expression extracts GTIN/EAN/UPC from Album title?
« Reply #3 on: May 24, 2011, 09:44:36 am »

Here you can find all the functions: http://wiki.jriver.com/index.php/Media_Center_expression_language
Unfortunately there isn’t a ‘find’ function so the ListItem is the only one to break down a string.
If you want to use regexp have a look at MP3Tag
Logged

chrisjj

  • Citizen of the Universe
  • *****
  • Posts: 750
Re: What expression extracts GTIN/EAN/UPC from Album title?
« Reply #4 on: May 24, 2011, 10:16:15 am »

Unfortunately there isn’t a ‘find’ function so the ListItem is the only one to break down a string.
Thanks.
Logged

chrisjj

  • Citizen of the Universe
  • *****
  • Posts: 750
Re: What expression extracts GTIN/EAN/UPC from Album title?
« Reply #5 on: February 04, 2013, 07:23:23 pm »

Logged
Pages: [1]   Go Up