Selecting a value inside an excel cell

[#1]

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]

U can use

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

[nilesh_gangurde · Accepted solution]

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

[#4]

subfield(Datefield,"=",2)

[Anonymous]

Hi,

Use this.

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

[#6]

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

[#7]

thankyou very much.. ill try them all

[#8]

thankyou very much.. ill try them all

[#9]

thankyou very much.. ill try them all 

[#10]

thanks...