Subfield not searching case sensitive

[davyqliks]

Hi

I am using the following to take everything after the search value ('ORANGE' in this example)

I need this to be case sensitive but it is not.

How can i achieve this please?

Load

SubField([Product Name],'ORANGE',1) as ProductName,
[Product Code]
FROM [\\uk1-file01\Office-LabUK\Sales\Boohoo\Portal\Data files\QVD\dataload.qvd(qvd)] (qvd)

WHERE WILDMATCH(ColourCode,'152');

Is there any way to achieve this?

Example - this value

Multi Satin Wide Leg Trouser MULTI-8

is returning the same when i should just get  this

Multi Satin Wide Leg Trouser

thank you in advance.

Daniel

[NitinK7]

Can you upload here some sample/dummy data?

with your exact output whatever you want 

[marcus_sommer · Accepted solution]

Subfield() is case-sensitive - at least in QlikView and there is no reason why it should be different in Sense. Therefore I suggest that you check your field-values and the used functions/syntax again if they are look like expected respectively are applied properly.

- Marcus

[Or · Accepted solution]

Confirmed that Subfield() is case sensitive in Qlik Sense as well. If you are separating based on 'ORANGE', why would you expect it to recognize 'MULTI' as a separator?

[Gabriel · Accepted solution]

Hi,

May be try

Load

SubField(UPPER([Product Name]),'ORANGE',1) as ProductName,
[Product Code]
FROM [\\uk1-file01\Office-LabUK\Sales\Boohoo\Portal\Data files\QVD\dataload.qvd(qvd)] (qvd)

WHERE WILDMATCH(ColourCode,'152');

[davyqliks]

Thank you so much for taking the time to reply.

As mentioned seems it is caps sensitive ( i made an error in a lookup) but thank you for the information. good to know about the Upper() function, thanks

Daniel