INTERACT FORUM

Please login or register.

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

Author Topic: Expressions / Find & Replace  (Read 1231 times)

darichman

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1362
Expressions / Find & Replace
« on: August 15, 2006, 12:44:33 am »

To the expression gurus!

How can I make an expression which finds and replaces part of a field automatically?

Eg: I want to find  " & " in the artist field and replace with " ; " for use in a list.

For example: "Bob & Fred" will output as "Bob;Fred"

Just trying to streamline my whole artist display process :)
Logged

jgreen

  • Citizen of the Universe
  • *****
  • Posts: 2419
Re: Expressions / Find & Replace
« Reply #1 on: August 15, 2006, 09:54:11 am »

This can be done in 35 seconds using "find and replace". 

(Select files, right-click/library tools/find and replace.)
Logged

darichman

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 1362
Re: Expressions / Find & Replace
« Reply #2 on: August 15, 2006, 07:07:32 pm »

Thanks jgreen, I'm aware of that feature :) Actually this is what I've been doing for a while now.

I was just wondering if there was a better way to do it, that's all.

But it poses two problems:
1) I don't want to change the [Artist] field itself... It is not a list field and I don't want artists displayed as X;Y in playing now etc. This will mean I have to create a new field eg [Artists] and copy the fields over.

2) This process would be entirely manual ~ I would have to (a) copy fields from artist to artists every time I add new files (b) find & replace every time I add new fields.

Logged
Pages: [1]   Go Up