Automate

Hi,

I am creating a query where I want to add a criteria where the results does not contain the character "*" (asterisk) 

I think I have to use the operator "Not Like" and then use an escape. But I don't know how to create the escape. Hopefully someone can help me out.

Greetings, Leo.

 In SAP, you can search in MM02 on the description field using *#**. SAP uses # as an escape so * is input as a character instead of a wildcard.

Excel uses ~ for an escape so the * is input as a character instead of a wildcard;  you can search using ~*.

hth, jan

------------------------------
jan ketele
release expert
Xeikon Manufacturing NV

Original Message:
Sent: 09-12-2024 09:56
From: Leo van Horrik
Subject: Does not contain * (asterisk)

Hi,

I am creating a query where I want to add a criteria where the results does not contain the character "*" (asterisk) 

I think I have to use the operator "Not Like" and then use an escape. But I don't know how to create the escape. Hopefully someone can help me out.

Greetings, Leo.

------------------------------
Leo van Horrik
Knowledge Community Shared Account
Burlington MA
------------------------------

Hi,

I am creating a Winshuttle query where I want to add a criteria where the results does not contain the character "*" (asterisk).

For example, if I have these material numbers: 1234, 1234*, 12*34 and 1234**, I want the result to be only material number 1234.

I think I have to use the operator "Not Like" and then use an escape. But I don't know how to create the escape in a Winshuttle query.

Hopefully someone can help me out.

Greetings, Leo.

------------------------------
Leo van Horrik
Knowledge Community Shared Account
Burlington MA
------------------------------

Hi Loe,

Please try % in place of *.

Use like if you want the 1234 to match as shown in my attachments. 

Hope this helps to what you are looking for.

Hi,

I am creating a Winshuttle query where I want to add a criteria where the results does not contain the character "*" (asterisk).

For example, if I have these material numbers: 1234, 1234*, 12*34 and 1234**, I want the result to be only material number 1234.

I think I have to use the operator "Not Like" and then use an escape. But I don't know how to create the escape in a Winshuttle query.

Hopefully someone can help me out.

Greetings, Leo.

------------------------------
Leo van Horrik
Knowledge Community Shared Account
Burlington MA
------------------------------

Hi,

I am creating a Winshuttle query where I want to add a criteria where the results does not contain the character "*" (asterisk).

For example, if I have these material numbers: 1234, 1234*, 12*34 and 1234**, I want the result to be only material number 1234.

I think I have to use the operator "Not Like" and then use an escape. But I don't know how to create the escape in a Winshuttle query.

Hopefully someone can help me out.

Greetings, Leo.

------------------------------
Leo van Horrik
Knowledge Community Shared Account
Burlington MA
------------------------------

Hi, 

This blog post might be of help here - https://community.precisely.com/discussion/studioevolve-tip-handling-strings-with-special-characters#bm462ce168-cf6f-4e7c-8dae-feda08a710bd

Here is how to use ESCAPE for special characters: https://docs.progress.com/bundle/datadirect-openaccess/page/topics/sqlref/escape-clause-in-like-operator.html

Hi,

I am creating a Winshuttle query where I want to add a criteria where the results does not contain the character "*" (asterisk).

For example, if I have these material numbers: 1234, 1234*, 12*34 and 1234**, I want the result to be only material number 1234.

I think I have to use the operator "Not Like" and then use an escape. But I don't know how to create the escape in a Winshuttle query.

Hopefully someone can help me out.

Greetings, Leo.

------------------------------
Leo van Horrik
Knowledge Community Shared Account
Burlington MA
------------------------------