Hi
Create 3 formulas IF else is used as some records will return 0 for INSTR as not all description has GAL. 1/12, 1/55
frm1 is it GAL. or Just GAL if just GAL then check for GALLON
IF INSTR({File_.Description},'GAL.') = 0 THEN
'NO'
ELSE
LEFT(Mid({File_.Description},instr({File_.Description},'GAL.')),4)
--------------------------------------------------------------------------------------
frm2
IF INSTR({File_.Description},'1/12') = 0 THEN
'NO'
ELSE
LEFT(Mid({File_.Description},instr({File_.Description},'1/12')),4)
--------------------------------------------------------------------------------------------
frm3
IF INSTR({File_.Description},'1/55') = 0 THEN
'NO'
ELSE
LEFT(Mid({File_.Description},instr({File_.Description},'1/55')),4)
Create parameters where user will enter the values check against the formula .....
Cheers
Rahul