COGNOiSe.com - The IBM Cognos Community

Hello, I have a product description field and I want to seperate the data in the field.  For example the product description may say "SWEW 732-04458.0180 X 0.187 X 111" and I want to take everything that is after the first period to show in its own field so in this case the output would be ".0180 X 0.187 X 111".  The number of characters in front of the first period varies. Thank you in advance for any suggestions!

Try this out

substring('732-04458.0180 X 0.187 X 111',position('.','732-04458.0180 X 0.187 X 111'),char_length('732-04458.0180 X 0.187 X 111'))

Thanks,HalfBloodPrince.

Thanks,HalfBloodPrince.