topic Re: Mid() in QlikView

Mid()

nihhalmca — Thu, 02 Jul 2015 10:05:17 GMT

Hi All,

Please find the attachment.

MK_QSL — Thu, 02 Jul 2015 10:10:25 GMT

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 — Thu, 02 Jul 2015 10:10:36 GMT

See attached qvw.

nihhalmca — Thu, 02 Jul 2015 12:37:00 GMT

Thanks Gysbert.

nihhalmca — Thu, 02 Jul 2015 12:37:12 GMT

Thanks Manish.