Using SubField in LOAD

[#1]

Hi, I have this:

SET CenterType='Type1;Type2;Type3;Type4;Type5;Type6;Type7';

And then, I make a LOAD:

[ABC_XYZ]:

LOAD

     @1 as xYear,

     @2 as xMonth,

     @3 as xDay,

      SubField($(CenterType),';',Left(@4,1)) as TypeData

          FROM

      ABC.qvw.log

          (txt, codepage is 1252, no labels, delimiter is spaces, msq)

;

But the 'SubFields' don't work.

Thanks.

[fosuzuki · Accepted solution]

Try:

SubField('$(CenterType)',';',Left(@4,1)) as TypeData

Does Left(@4,1) return a numeric value?

Hope this helps

Fernando

[#3]

That´s perfect !!.Thank you Fernando.