Text formating TDR if condition

[L911]

Hi everyone.

Until now I was able to get some values and data in the TDR in function of the file I open, which is nice. However, I would love to write a specific text in function of the file I open.

Example, the file I open has a format x_y_z is called 1_2_3

I want then if x = 1 the title will be for example "First test type", if x = 2, "Second test type" etc. Same for the other ones. (y = 1, "DOW", y = 2, "GVW")  etc.

I managed to get the numbers with a split, for example for the run number, I take the last value like this:

@@Split(data.Root.Name, "_", -1, VBTextCompare)(Ubound(split(data.Root.Name, "_", -1, VBTextCompare)))@@

Any suggestion? Thanks,

L911

[ML927]

Hi L911,

I am unsure of what you are trying to achieve. In my understanding, you have a file named something like X_Y_Z and depending on the value of X, Y and Z you want to achieve a certain kind of post processing. Am i right ?

Thanks,

[gsklyr · Accepted solution]

Like this?

[L911]

Hi Brad, Hi Gsklyr,

Sorry for the delay.

Indeed that is what I what looking for, the "IIF" function.

I assumed that to use it, we have to write @@IIF(condition, iftrue, ifwrong)@@

Is there a similar command for a switch case?