INTERACT FORUM

Please login or register.

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

Author Topic: Can you catenate strings in scemas?  (Read 2081 times)

Well1234

  • Regular Member
  • Recent member
  • *
  • Posts: 8
  • nothing more to say...
Can you catenate strings in scemas?
« 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.

Logged

iCamp

  • Regular Member
  • Galactic Citizen
  • ****
  • Posts: 318
  • nothing more to say...
Re: Can you catenate strings in scemas?
« Reply #1 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.

whoeveryouare

  • Regular Member
  • Member
  • *
  • Posts: 0
  • nothing more to say...
Re: Can you catenate strings in scemas?
« Reply #2 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".
Logged

Chris Shaw

  • Regular Member
  • Galactic Citizen
  • ****
  • Posts: 365
Re: Can you catenate strings in scemas?
« Reply #3 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.
Logged

NoCodeUK

  • Citizen of the Universe
  • *****
  • Posts: 1820
Re: Can you catenate strings in scemas?
« Reply #4 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
Logged
"It's called No Code because it's full of code. It's misinformation." - Eddie Vedder

Well1234

  • Regular Member
  • Recent member
  • *
  • Posts: 8
  • nothing more to say...
Re: Can you catenate strings in scemas?
« Reply #5 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. :)
Logged
Pages: [1]   Go Up