Variables

[#1]

Hi everybody

i'm facing a strange issue or misunderstanding

When I

LOAD * FROM   [$(PathQVD)\$(FileNameQVD).qvd] (qvd);

everyting's OK

BUT When i'm doing

LET v =filename([$(PathQVD)\$(FileNameQVD).qvd]);

my variable v is NULL

Any idea ?

Thnak you

Chris

[#2]

What exactly u want to store in variable v??

[maxgro]

this is an example of using filename from online help

Load *, filename( ) as X from

C:\UserFiles\abc.txt

Will return 'abc.txt' in field X in each record read.

[MK_QSL]

Try this

LET v =filename('[$(PathQVD)\$(FileNameQVD).qvd]');

[rustyfishbones]

You don't need a variable

try

LOAD *,

FileName() as Filename

FROM [$(PathQVD)\$(FileNameQVD).qvd] (qvd);

[#6]

I want to check wether or not the file exists

so if i get a filename it does

Chris

[#7]

I did already,  it doesn't

Chris

[#8]

Yes I do,

i don't want to load data, just check if the file exists

Chris

[rustyfishbones]

Hi Chris,

You may want to use this instead

LOAD *,

FilePath() as Path

FROM [$(PathQVD)\$(FileNameQVD).qvd] (qvd);

This will give you the full path of where the file is located and the filename

Regards

Alan

[maxgro]

for qvd file there are qvd file functions

answer here (and example)

Re: How can I check if a file exists ?

QvdCreateTime

Returns the XML-header time stamp from a QVD file if any (otherwise NULL).

The filename is the name of a QVD file, if necessary including path.

Examples:

QvdCreateTime('MyFile.qvd')

QvdCreateTime('C:\MyDir\MyFile.qvd')