INTERACT FORUM

Please login or register.

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

Author Topic: Function Replace(...), parenthesis problem  (Read 912 times)

llafriel

  • World Citizen
  • ***
  • Posts: 230
Function Replace(...), parenthesis problem
« on: March 14, 2008, 12:38:32 pm »
I'm trying to remove "(OST)" from my soundtrack albums in a view scheme. All my soundtracks have "(OST)" in their album names. So I try with this function:
   Replace([Album], (OST))
This removes "(OST", but adds "))" on the end of the album names. It seems the function ends when it sees the first right parenthesis. Is there a workaround for this?
Logged

Matt

  • Administrator
  • Citizen of the Universe
  • *****
  • Posts: 42053
  • Shoes gone again!
Re: Function Replace(...), parenthesis problem
« Reply #1 on: March 14, 2008, 02:09:19 pm »
You need to escape the parenthesis with a slash.

So:
Replace([Album], /(OST/))
Logged
Matt Ashland, JRiver Media Center

llafriel

  • World Citizen
  • ***
  • Posts: 230
Re: Function Replace(...), parenthesis problem
« Reply #2 on: March 14, 2008, 03:34:05 pm »
Worked perfectly, thanks!
Logged
Pages: [1]   Go Up
« previous next »