Stimulsoft Business Intelligence System | Forum

Hi,
I need to use a part of text but i haven't always the same number of characters.

e.s
first step: to wake up
second step: to wash hands
third step: to get dressed

I need to use the part of the sentence before of ":"

like this
first step
second step
third step

I need something like "substring(text,1,index of ":")"

Could you help me?
thanks

Hello,

You can use the following expression:
{(Variable.IndexOf(":") != -1 ? Substring(Variable, 1, Variable.IndexOf(":") - 1) : "")}

Thank you.

Great! Thank You

You are welcome, Fabio!