Impromptu Function help

[cbmilo]

hi all,
I am unsure of how to do this in Impromptu...I need to parse out a material field using a function. For example, my mtrl is 100083-0-AA. I need to use a function on a new field to just show the 100083 and drop the rest. Ideas?

[MFGF]

Impromptu...  It's been a long while since I used this...  If memory serves, you need to use the Substring function to extract the first 6 characters  - substring([your item],1,6)

Apologies if this is not precisely correct - after a few years, the different function sets in Impromptu/Data Manager/Cognos 8/SQL Server/Oracle/DB2/Excel etc etc become blurred in the mind of an old-timer like me!

MF.