Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[darichman]

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

[jgreen]

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

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

[darichman]

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.