Mid()

[nihhalmca]

Hi All,

Please find the attachment.

[MK_QSL]

Table:

LOAD * ,

   mid(Transaction,1,4) as Filed1,

   mid(Transaction,5,4) as Field2,

   mid(Transaction,9,13) as Field3;

LOAD Concat(Transaction,'') as Transaction INLINE [

    Transaction

    11112222

    3333

];

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[nihhalmca]

Thanks Gysbert.

[nihhalmca]

Thanks Manish.