INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: Well1234 on May 13, 2003, 06:37:31 am

Title: Can you catenate strings in scemas?
Post by: Well1234 on May 13, 2003, 06:37:31 am

I'd like to create a schema like:

Rolling Stones:
1964 Goats Head Soup
         Track 1...
1965 Flowers
         Track 1...
1990 Tattoo You
         Track 1...

etc (yeah I know the data is not accurate :-))

Can I catenate the Year of the album to the Album to create a new Year-Album field and then create a schema with that field?  Ideas?

Tried a few things with custom fields, but no luck.

Thanks in advance.

Title: Re: Can you catenate strings in scemas?
Post by: iCamp on May 13, 2003, 10:42:16 am

I feel dumb...I had to look "catenate" up.  I thought you were making up a new word.  ;)

I guess you could create your own code in the various database fields you may not be using.  Use the "composer" field to link all tracks you designate as "A" together or something like that.

Title: Re: Can you catenate strings in scemas?
Post by: whoeveryouare on May 13, 2003, 12:22:09 pm

Quote

I feel dumb...I had to look "catenate" up.  I thought you were making up a new word.  ;)

Almost...  The more correct term would be "concatenate".

Title: Re: Can you catenate strings in scemas?
Post by: Chris Shaw on May 13, 2003, 03:15:58 pm

I'd love this option too. Preferably with the option to add a spacer character. So concatenating
ARTIST - ALBUM
and
TRACK # - NAME
would give

Massive Attack - 100th Window
 01 - Future Proof
 02 - What Your Soul Sings

I could do  this with custom fields, but I'd have to do every track manually, wouldn't I? I'd like an option that says:
Create custom field and fill it according to this rule.
A procedurally generated custom field, if you will.

Title: Re: Can you catenate strings in scemas?
Post by: NoCodeUK on May 13, 2003, 03:17:55 pm

I have mentioned this b4 and it would just be great.  maybe that is the w00t we are waiting for??

Adam

Title: Re: Can you catenate strings in scemas?
Post by: Well1234 on May 14, 2003, 01:48:48 am

Thanks for the feedback.  I stand corrected on the word "catenate" (ie sb concatenate) but then I'm a lazy typer. :)