topic Re: Selecting a value inside an excel cell in QlikView

Selecting a value inside an excel cell

Wed, 09 Apr 2014 05:49:07 GMT

hey

i'm kind of new to qlikview, so any help would be much appreciated.

the problem i have is that in the excel sheet i have, the data i need is written with some other values.

for example, in the date field the data is written as " date= 02/03/14 " where as i just need the 02/03/14 part...

is there any way to extract it?

thankyou in advance

cheers

mato32188 — Wed, 09 Apr 2014 06:05:19 GMT

U can use

date#(right([Your Date Field], 8), 'DD/MM/YY') as Date

nilesh_gangurde — Wed, 09 Apr 2014 06:07:05 GMT

Hi,

this can be done, please have a look on below mentioned script.

load Datefield,

Right(Datefield, 😎 as NewDate,

From TABALE_NAME;

hope this will help you.

-Nilesh

Wed, 09 Apr 2014 06:14:31 GMT

subfield(Datefield,"=",2)

Anonymous — Wed, 09 Apr 2014 06:22:18 GMT

Hi,

Use this.

= date(right(date,10),'DD/MM/YY')

Wed, 09 Apr 2014 06:27:17 GMT

use this in your load

Date(Date#(subfield(Datefield,"= ",2),'DD/MM/YYYY'),'DD/MM/YYYY') as CorrectDate //If space is there after =

Otherwise

Date(Date#(subfield(Datefield,"=",2),'DD/MM/YYYY'),'DD/MM/YYYY') as CorrectDate

Wed, 09 Apr 2014 06:31:43 GMT

thankyou very much.. ill try them all

Wed, 09 Apr 2014 06:31:54 GMT

thankyou very much.. ill try them all

Wed, 09 Apr 2014 06:33:19 GMT

thankyou very much.. ill try them all

Wed, 09 Apr 2014 06:33:56 GMT

thanks...