cancel
Showing results for 
Search instead for 
Did you mean: 

long dash not appear in query result

former_member419030
Active Participant
0 Kudos
153

Dear Experts,

I have some items master data, created by copy paste from excel/PDF/word.

Upon query all of these items, found out it will not appear in the result. After further checking, found out that the issue is due to long dash which is part of the item code

ABC – 123 (not appear in the query result)

ABC - 123 (appear in the query result)

anyone has similar issue like this and is it possible to query the item, without recreating the item using the correct dash?

Accepted Solutions (0)

Answers (1)

Answers (1)

Johan_Hakkesteegt
Active Contributor
0 Kudos

Hi,

The value in the database is correct. The problem is with the interface showing you the result of the query. It interprets both characters as being the same, or at least it shows them as being the same. It is probably best not to try and have two item codes which only difference is the length of the dash.

You can test by copying the returned value for example into MS Word, a program that usually does recognize the difference, and will show it.

You may encounter similar problems with characters like ñ, õ, å, ä, ö and the like. When creating item codes, it is best to avoid certain characters anyway, like space, #, /, \, ;, :, ", ', =, <, >, and ,

Regards,

Johan