Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
4
Erster Beitrag:
vor 8 Jahren, 2 Monaten
Letzter Beitrag:
vor 8 Jahren, 2 Monaten
Beteiligte Autoren:
Al, Fabrice Harari, Dan M

How do you include/exclude dashes, slashes & spaces when searching?

Startbeitrag von Dan M am 23.07.2009 01:22

I am trying to search for for part numbers from several different suppliers.

Everyone does things differently.

Some remove all dashes (-), slashes (/) (\), and spaces ( ).

Others put dashes (-) where most put slashes (/) or (\)

Others put slashes (/) (\) where most put dashes (-)

and other put spaces( ) in the strangest of places ...

I have seen sights that can account for this but do not understand how they are going about doing this ... ?? wildcards??

Can anyone point me in the right direction ...

Thanks ... Dan

Antworten:

Re: How do you include/exclude dashes, slashes & spaces when searching?

Hello Dan

WIndev has a couple of ways to search for wildcards but they may not be very quick as they are more character matching of strings on a result set.

Have a look at MatchRegularExpression
http://www.regular-expressions.info/tutorial.html

There is also the "LIKE" operator in queries and you could search the help for "Comparison Operators"

Hfilter with conditions can help if some part of what you are looking for is in an index

Regards
Al



von Al - am 23.07.2009 01:38

Re: How do you include/exclude dashes, slashes & spaces when searching?

Hi Dan

that one is easy...

in the analysis, you declare that your reference is a key, and in the right side of the window, General tab, you have an area where you define the parameters of the key (for text keys)...

The first one is for upper/lowercase, the second for accents (éà...) and the 3rd is for spaces, punctuation and special chars (ie -/ ....)

As long as you leave ALL 3 checkboxes uncheck, then the key will behave as you request, so a simple hreadseek will do the trick

Best regards

von Fabrice Harari - am 23.07.2009 11:12

Re: How do you include/exclude dashes, slashes & spaces when searching?

Hello Fabrice

I was really interested in your answer because the Windev help is quite vague on this point and I had never really taken much notice of the punctuation index option.
The help only refers to :
Take the punctuation characters (comma, period, and so on) into account when performing searches on an item

I wrote to PCSoft Tech support asking for a list of the characters that they interpret as "punctuation characters" and they have replied:

This is the list of char that are unaware by HyperFileSQL when the key was not punctuation sensible in latin alphabet :


1/2/3/4/5/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/42/43/44/45/46/47/58/59/60/61/62/63/64/91/92/93/94/95/96/123/124/125/126/127/128/129/130/132/133/134/135/136/137/139/141/143/144/145/146/147/148/149/150/151/152/155/157/160/161/162/163/164/165/166/167/168/169/171/172/173/174/175/176/177/180/181/182/183/184/187/191/215/247/



If we list only printable char, we obtain this list:

TAB RC - ! " # $ % & ' ( ) * + , - . / : ; = ? @ [ \ ] ^ _ ` { | } ~ ¤ ‚ „ … † ‡ ˆ ‰ ‹ ‘ ’ “ ” • – — ˜ › ¢ £ ¤ ¥ ¦ § ¨ © « ¬ ­ ® ¯ ° ± ´ µ ¶ · ¸ » ¿ × ÷

Note: the list contains the greater than and less than symbols which do not appear because of the web page.

Regards
Al



von Al - am 24.07.2009 22:18
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.