How to Split the string into number of sub strings

[#1]

Hi,

I am creating one QVW file in my project by taking the QVD file as a data source. In this QVD one of the field called HeaderDateKey has the data like,

C:\Project\QlikView\CAR\QVD\INPACT\CAR.QVD_2011-09-27.

But I would like to display the output as three fields like,        ApplicationName      QVDName            LoadDate

                                                                                          CAR                          CAR.QVD             2011-09-27

How can we spilt the data and show in number of subfields.

It would be the greate help.

Thanks in advance................

Regards,

Praveen

[Miguel_Angel_Baeyens]

Hi Praveen,

Since you are building the QVW file, you can create the name of the QVD to fit easiest your needs, but as it is now, using a few string functions will do

LOAD SubField(FileName(), '.', 1) AS ApplicationName,
     SubField(FileName(), '_', 1) AS QVDName,
     Date(Date#(SubField(FileName(), '_', 2), 'YYYY-MM-DD')) AS LoadDate,
...

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica