If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Seperating Data in Field

Started by gatorfe, 16 Jan 2012 01:00:48 PM

Previous topic - Next topic

gatorfe

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!

HalfBloodPrince

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'))

barrysaab

Boy! Cognos getting on to me!!!

barrysaab

Boy! Cognos getting on to me!!!