Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
[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....
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.
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