INTERACT FORUM

More => Old Versions => Media Center 11 (Development Ended) => Topic started by: darichman on August 15, 2006, 12:44:33 am

Title: Expressions / Find & Replace
Post by: darichman 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 :)

Title: Re: Expressions / Find & Replace
Post by: jgreen 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.)

Title: Re: Expressions / Find & Replace
Post by: darichman 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.