Print

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

[raym]

I'm trying to use the Replace(...) function to remove spaces from the start of a field but it's not working. For example,

Replace(xxxABBA,x) returns "ABBA"

But,

Replace(   ABBA, ) still returns "   ABBA"

I've tried putting single and double quotes around the space/search char eg, Replace(   ABBA,' ') but nothing seems to work.

How can I strip leading spaces? I was expecting a Trim() type function but Replace() seems to be my best bet.

Thanks for any help on this.

[gappie]

hey raym,

you could use
replace([artist],/ )
note the slash. it makes the space behind it work.

the expression also removes the spaces between words, dont know if that is what you are after..

what works better is

clean([artist])

 
gab

[raym]

Oh, perfect! Both solutions work. Didn't even know about Clean!!

Thanks again.

[fitbrit]

Am I mistaken in that this is one of the functions to be found in "Clean file properties" under the Library tools section of the contextual menu? Mind you it does simultaneously clean up trailing spaces too - if it finds them - so that may not be what you want.