help with if statement.....

[#1]

[stupid question alert]

I got this in my load statement.

  left(subfield(FileName(),'Open',2),8) As Test1,

  if(left(subfield(FileName(),'Open',2),8) = 'Changes','CHG','INC') As Test2

  and getting this result...

what do I do wrong....

[Anonymous]

left(subfield(FileName(),'Open',2),8) will return 8 characters, but Changes is only 7 characters. So you'll either need to adjust your Left() to be 7 instead of 8, or adjust 'Changes' to whatever left(subfield(FileName(),'Open',2),8) returns.

[sunny_talwar]

Try this:

If(Trim(Left(SubField(FileName(),'Open',2),8)) = 'Changes','CHG','INC') As Test2

or

If(WildMatch(Left(SubField(FileName(),'Open',2),8), '*Changes*'),'CHG','INC') As Test2