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?
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.