Where Condition

[#1]

Hi,

How can I write values like 'Amazon's.com' in where condition?

Usually I write the where condition as follows:

where Name='ABC'

Please help.

[robert_mika]

Like this?

LOAD

SaelsOrder_ID,

SalesOrder_BP,

SalesOrder_Text,

mapsubstring('map1',SalesOrder_Text) as Changed

FROM

[152744.xlsx]

(ooxml, embedded labels, table is Sheet1)

where SaelsOrder_ID= 'Amazon.com'

[maxgro · Accepted solution]

t:

load * inline [

str

Virgilio

Google

Yahoo

Amazon's.com

];

set v='Amazon' & chr(39) & 's.com';

v:

NoConcatenate load str, str as str2 Resident t

where str = $(v);

[#4]

Thanks , this works