Print

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

[llafriel]

Hi,

This function:

Code: [Select]

If(IsEqual(Mid([Video Type],0,8), TV Serie),[Episode]. [Name],[Name] ([Year]))
If true returns:

Code: [Select]

[Episode]. [Name])Notice the paranthesis, if false the paranthesis is left out.
If i remove the last paranthesis from the function then true returns:

Code: [Select]

[Episode]. [Name]But false returns:

Code: [Select]

[Name] ([Year]Missing the last paranthesis.

Does anyone see what I'm doing wrong here?

[marko]

If you want to treat the parenthesis literally, as part of the output string, as opposed to being a part of the actual expression, you must 'escape' them using a forward slash immediately before.... shown in bold below:


If(IsEqual(Mid([Video Type],0,8), TV Serie),[Episode]. [Name],[Name] /([Year]/))


-marko.

[llafriel]

Worked. thanks!