Print

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

[Mars]

Hi,

I need an expression to replace whitespaces with dashes in a field.

I've tried:

Code: [Select]

Replace ([Artist],  , -)
Replace ([Artist], ' ', -)
Replace ([Artist], " ", -)
but none seems to work...

[blgentry]

When you write expressions, MC generally discards white space.  This makes sense most of the time because spacing between words, functions, etc really shouldn't matter when you're writing an expression.

But what about those times that you *want* MC to see your space characters and take them into account?  The answer is to use a quoting character to tell MC, "Hey, everything after this is a literal character, and you shouldn't throw any of them away or assign special meaning to them.  They are literally what is written."

MC's primary quoting character is the slash (/).  So the expression you want is:

Code: [Select]

replace([name],/ ,-)
The space after the slash will be interpreted as a literal space, which is what you want.  Now if you want to turn multiple spaces in a row into dashes, then it becomes another game.  Which MC can do, if you need it to.

Brian.

[Mars]

Thank you Brian! Didn't know about the slash being the quoting mark...

[glynor]

The / character is a single-character escape* (meaning, the character that follows a slash is passed through without normal processing). You can also do a multi-character escape with /# string literal goes here #/.

Lots More:
http://wiki.jriver.com/index.php/Expression_Language#Expression_Language_Syntax

* Just FYI, it is called, as is typical in programming, an escape character (as opposed to a "quoting character").