Can any one explan substing count,concatinate functions

[Anonymous]

Hi,

Can any one help me SubStringCount(Concat(Dimension_List_Ord,'|'),'a')   how it works.

Thanks,

[sagarkharpude · Accepted solution]

Hi,

In this expression, the Concat() function will concatenate all the selected or possible Dimension_List_Ord values separating them with a Pipe (for example, Dimension_List_Ord | Dimension_List_Ord | Dimension_List_Ord ).  The Substringcount() function will then check that string and will return the number of times that "a" is in that string. 

Please refer the attached file.