topic Re: Mid function in the script in QlikView

Mid function in the script

Fri, 04 Mar 2011 11:38:22 GMT

Anyone knows why the Mid function in the script does not work.

It said the Mid function is not the build-in function.

Please help.

Thanks

Fri, 04 Mar 2011 11:41:30 GMT

You can use MID function in the script:


mid(FieldName,StartNum,EndNum) as NewFieldValue;
Mid(MonthName,1,3) as Month_Name;

Verify this as an answer once you check.

Femke — Fri, 02 Oct 2020 11:09:50 GMT

Hi,

I had the same issue. Try to shut your previous load with ' ; '. For me that helped.

Kind regards

Chanty4u — Sat, 10 Oct 2020 14:47:47 GMT

its script function aswell see below one example