Can we get a Substring in Report Studio for a Cube source Package

[Venu_Gollapudi]

Hi,

I have requirement, in which I have to retrieve a substring for a column, the values of the columns will be like this

SCHWARTZBERG, MORI - 10 NEPTUNE BLVD  NEPTUNE , NJ 07753|40.22|-74

end of that values few numbers have been separated with Pipe symbol [|] those I need to pull them in to two separate columns, for example in the above value I need to pull 40.22 into one columns and -74 into another column, can we do like this in report studio..

Also let me know if we can do by using any MDX function.

Thanks in advance,
Venu.

[Venu_Gollapudi]

Hey Guys, I only did it man, we can achieve this by using the functions
'position','char_length' and 'substring'

Cheers,
Venu Gollapudi.