Criteria select in a script with special characters '<'

[pperrochaud]

Hello,

In a Xls file the possible value of a field is '<--->' and I have to select only rows whith this value.

I wrote my script like this:

Offers_Diffus_tmp:
LOAD DateOffre,
Référence,
Marque,
Famille,
Produit,
Quantité,
[Prix de base],
[Prix client],
[Prix négoce],
[Prix total],
Client
FROM
$(vOffers_Diffus)
(ooxml, embedded labels)
where Référence = '<--->';

But no line is loaded.

Could you help me please ?

[sunny_talwar · Accepted solution]

May be try this

Where Trim(Référence) = '<--->';

or this

Where WildMatch(Référence, '*<--->*');

[amrinder]

Hi,

Try below:

Let vWildChar=chr(60)&'*';

Offers_Diffus_tmp:
LOAD DateOffre,
Référence,
Marque,
Famille,
Produit,
Quantité,
[Prix de base],
[Prix client],
[Prix négoce],
[Prix total],
Client
FROM
$(vOffers_Diffus)
(ooxml, embedded labels)
where where WildMatch(Référence,'$(vWild)');

Hope it helps.

-amrinder

[amrinder]

Sorry I passed wrong variable name in where clause please correct it:

Try below:

Let vWildChar=chr(60)&'*';

Offers_Diffus_tmp:
LOAD DateOffre,
Référence,
Marque,
Famille,
Produit,
Quantité,
[Prix de base],
[Prix client],
[Prix négoce],
[Prix total],
Client
FROM
$(vOffers_Diffus)
(ooxml, embedded labels)
where where WildMatch(Référence,'$(vWildChar)');

Regards,
Amrinder

[pperrochaud]

Thanks It's works.