Discussion Board for collaboration on QlikView Scripting.
hi in the following excel applikation i wish to extract only the last four numbers off each row.
if a row is lacking the four numbers (companycode) i wish not to read them.
i have tried trim function without luck as each of the rows have different lengths;
Go to Solution.
Try something like
if(isnum(right(Company,4)),right(Company,4)) as Company_num,
(ooxml, embedded labels, table is Sheet1);
or if you only want to read these companies:
right(Company,4) as Company_num
(ooxml, embedded labels, table is Sheet1)
I suggest you attach the excel file.
Thanks i have attached the excel sheet