how substring(concat()) function works in adhoc reporting?

[omkarvamsi]

Hi,

Could any one please explain how the functionalityof the below expression which i have used in adhoc reporting.

.

=SubStringCount(concat(Dimension_flag, '|'), 3)

I could not understand why pipe or vertical bar '|' is being used?

I know how substringcount() and concat() individually  works but I couldn't get idea about Pipe symbol.

Even If i'm using this below expressions,my adhoc report is working.

SubStringCount(Mflag,1)

SubStringCount(Mflag,2)

Then why we are using '|'

Thanks In advance.!!

[sunny_talwar · Accepted solution]

The use of Pipe is to ensure that each value of Dimension_flag is separate from each other when you do a check. I would further change it to this may be

=SubStringCount(Concat('|' & Dimension_flag & '|', ','), '|3|')

Just to make sure that 3 can be differentiated from 13 because 13 also includes a 3.

[omkarvamsi]

I understood.

Thank you Sunny